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 2:29pm

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 4:19am

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

Other recent topics Other recent topics