SQL Server query extremely slow on new Windows 7 PC
I installed the SQL 2008 Management Studio on a new HP ProBook 6540b laptop. I run a script to a server running SQL 2008 x64. The query returns about 10 record sets. This script takes under a second to run on all our old PC's, but it takes 30 seconds on the new PC. Management Studio seems to take its time drawing the boxes for each result set. I turned off Aero, and it now takes 15 seconds, but it is still much slower than on our other PC's. This PC is generally faster than the others, e.g. copying files over the network is faster. Do I need to change any settings? The settings in SQL configuration manager are the same as on the old PC. I have applied all Windows updates and applied SQL SP1. Any ideas? Thanks!
April 13th, 2010 12:53pm

Have you installed the latest SQL Server 2008 Sp1 cumulative update pack? It includes a lot of fixes."A programmer is just a tool which converts caffeine into code" CLIP- Stellvertreter http://www.winvistaside.de/
Free Windows Admin Tool Kit Click here and download it now
April 13th, 2010 4:45pm

Thanks, I'll try that. I'm downloading CUP6. What confuses me is that I'm not having performance problems on any other PC with the same version of Management Studio on XP, Vista or Windows 7. I was wondering if it is an issue with a display driver - you can see it taking its time drawing the windows for each result set. But no other application has problems with the display.
April 14th, 2010 9:49am

I applied CUP6 to the PC (not the server), and it hasn't made a difference. The version number of Management Studio didn't change after installing CUP6 - is it supposed to change? The log shows that it succeeded.For the record:Microsoft SQL Server Management Studio 10.0.2531.0Microsoft Analysis Services Client Tools 10.0.1600.22Microsoft Data Access Components (MDAC) 6.1.7600.16385Microsoft MSXML 3.0 4.0 5.0 6.0 Microsoft Internet Explorer 8.0.7600.16385Microsoft .NET Framework 2.0.50727.4927Operating System 6.1.7600
Free Windows Admin Tool Kit Click here and download it now
April 15th, 2010 12:29pm

Has there been any resolution to this? I am experiencing similar problems. I have even upgraded to 2008 R2. When I open a new tab for a sql query, SSMS says "Management Studio Not Responding" for about a minute while the tab partially opens. Then it opens completely and you can work. When I run a query, it takes very long (30 seconds to a minute for something very simple -- even returning a single row and column). The same query runs in less than a second on my older machines. Mark
July 13th, 2010 5:59pm

I am also experiencing the same issue. Running a SQL SERVER 2008 R2 STANDARD server on Windows Server 2003, some clients are XP machines and query the host instantly and there is no lag with requests. On all my new Windows 7 Machines there is at least a 5 - 6 second period in which the program is unresponsive everytime it makes an SQL request. I have tried the following: 1. Disable LLMNR - No performance change 2. Use IP address instead of Hostname in my connection string - No performance change 3. Use SSPI=NTLM in my connection string - Does not even run Any other ideas microsoft?
Free Windows Admin Tool Kit Click here and download it now
November 4th, 2010 9:25pm

I am also experiencing the same issue, and I found solution. In this topic problem was resolved. You need to disable AutoTuning network feature. Just execute command on you Windows 7 machine: netsh interface tcp set global autotuninglevel=disabled
December 12th, 2010 12:15pm

Still if you are facing the issue, please see blow resolution: Root Cause ------------------------------------------------------------------- The issue which we were seeing on Win7 VDIs could be due to the Network hardware device connected with the machine. If TCP/IP scaling is not supported by the network device then the performance will be slow. Solution ------------------------------------------------------------------- Disable auto tuning level of the TCP. Please follow below steps: Open command Prompt with admin right (Run as Admin)Type netsh interface tcp set global autotuninglevel=disabledAfter running above command restart the machine. For other information on this command, visit link http://support.microsoft.com/kb/935400
Free Windows Admin Tool Kit Click here and download it now
February 16th, 2012 10:48pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics