locked
SQL Server Import/Export Wizard RRS feed

  • Question

  • Hello,

    We have a virtual server in our DMZ with SSMS installed in order for our offsite end users to access a Data Warehouse.

    Our end users are complaining that loading the SQL Server Import/Export Wizard takes an extremely long time. The server with SSMS on has 1 CPU and 4GB of RAM. Loading SSMS itself is fairly quick, has anyone had the same issue?

    Any advice would be most appreciated,

    Andrew
    Monday, February 18, 2013 4:20 PM

Answers

  • Hi,

    Using web based operations is best option for performing task.

    The server configuration  with SSMS on has 1 CPU and 4GB of RAM is very low end. You need a server with at least 2 to 4 cpu and 16gb+ RAM.

    For analyzing you can use performance monitors to analyze the bottlenecks.



    Please help and appreciate others by using these features: "Propose As Answer", "Vote As Helpful" and "Mark As Answer"

    Waqas

    MS(SPM), MS(E&F),M.Engg, MCP, MCT, MCTS, MCITP, MCSE, MCPD, MCSD, MCDBA , Author
    Twitter: @Waqas_m1
    Linked In: http://www.linkedin.com/in/waqasm1


    • Proposed as answer by Waqas M Wednesday, February 20, 2013 8:06 AM
    • Marked as answer by Maggie Luo Tuesday, February 26, 2013 9:35 AM
    • Edited by Waqas M Thursday, February 28, 2013 10:25 AM
    Wednesday, February 20, 2013 7:39 AM

All replies

  • What is your remote access solution like. Are you using something like Citrix or VPN ? I would prefer a Citrix type solution where you access via a browser and only screen updates are sent to the client; so not much network traffic over the wide area network which means app response is much faster.

    Thong

    Tuesday, February 19, 2013 1:21 AM
  • Hi,

    Using web based operations is best option for performing task.

    The server configuration  with SSMS on has 1 CPU and 4GB of RAM is very low end. You need a server with at least 2 to 4 cpu and 16gb+ RAM.

    For analyzing you can use performance monitors to analyze the bottlenecks.



    Please help and appreciate others by using these features: "Propose As Answer", "Vote As Helpful" and "Mark As Answer"

    Waqas

    MS(SPM), MS(E&F),M.Engg, MCP, MCT, MCTS, MCITP, MCSE, MCPD, MCSD, MCDBA , Author
    Twitter: @Waqas_m1
    Linked In: http://www.linkedin.com/in/waqasm1


    • Proposed as answer by Waqas M Wednesday, February 20, 2013 8:06 AM
    • Marked as answer by Maggie Luo Tuesday, February 26, 2013 9:35 AM
    • Edited by Waqas M Thursday, February 28, 2013 10:25 AM
    Wednesday, February 20, 2013 7:39 AM