I've istalled SQL2005/SSMS on my development machine and connecting to a local SQL Server 2005. Executing queries is fast but the results grid populating is slow and so is the refresh of the same data. This is not a slow query, its the gridview draw/redraw. I've other PC's with slower processors and less ram with the same software run circles around the SMSSPerformance on this Laptop

I've read posts about nvidia graphics drivers and mouse drivers causing issues similar to this. I do have an nvidia quadro x1600M (this isa laptop Compaq 8710w) and switching off the accelerator using Displays/Advanced/Troubleshootingby moving the slider to the middle/center position causes the gird refresh to dramatically increase.It's funny how turning oof the accelerator increases performance.

I have the latest HP nvidia drivers and SSMS is useable without hardware acceleration but I also develop software that uses directx and its getting really troublesome to work this way.

I am running:

Operating System: Windows XP Professional (5.1, Build 2600) Service Pack 2 (2600.xpsp_sp2_qfe.070227-2300)
Language: English (Regional Setting: English)
System Manufacturer: Hewlett-Packard
System Model: HP Compaq 8710w
BIOS: EPP runtime BIOS - Version 1.1
Processor: Intel(R) Core(TM)2 Duo CPU T7300 @ 2.00GHz (2 CPUs)
Memory: 3072MB RAM
Page File: 515MB used, 4439MB available
Windows Dir: C:\WINDOWS
DirectX Version: DirectX 9.0c (4.09.0000.0904)
DX Setup Parameters: Not found
DxDiag Version: 5.03.2600.2180 32bit Unicode

All drivers up-to-date and latest microsoft updates (as of this posting)

Major Software Instaled

VS2005 Professional

SQL Server 2005

Office 2003 Professional

Gotta add my voice to the mix ...

Exact same issue here. I am running an Nvidia Quadro FX 1600M on a Dell Precision M6300. SSMS draws the results grid painstakingly slow. I tried the above suggestion and it worked. If i change Display -> Settings - > Advanced -> Troubleshooting -> Hardware Acceleration to the 3rd tick or lower then the problem completely goes away. But that seems like an unreasonable solution. For now at least I got something to help me get through the workday. Thank you wbochar!

Any other suggestions out there would be wonderfully appreciated!

Spike

Same issue here. I'm on a Dell Precision T3400 with a Core 2 Quad and an Nvidia Quadro FX 1700. The redraw time on the results grid in SSMS is painfully slow and even spurred a BSOD on me earlier today. Like the others here, turning down my hardware acceleration corrects the issue and the performance becomes snappy. Not exactly a great solution. Anyone figure anything outaboutthis? It's rather annoying.

Thanks!

Same problem here on a Dell Precision M6300, looks like it fixed by lowering hardware acceleration, which I agree is certainly not a solution. This problem presented it self secondary to upgrading the BIOS to version A08 and the video drivers to v.167.55, A00 for the Quadro FX3600M. I’m assuming that this problem is a result of the newer driver version judging by the dates on these posts. Going to try to find the original driver and reinstall to see if that resolves the issue.

Has anyone had any success with this or any other fix?

I tried the directX refresh and it didn't help. Did anyone else have any success?

I wish I could revert, my laptop's drivers for its nvidia chipset will only install using the HP driverset. When I try to use the nvidia installer, it doesnt allow me to install -- it forwards me to HP.

Since this laptop and design are relatively new, there is only 2 driver sets available and both exhibit this issue.

lowering the hardware acceleration. At least, it's easy to switch back on, when 3d acceleration is req. I find it strange that noone knows the reason/solution.

Yes -- attempting to rollback drivers is messy business. The best thing to do is for everyone concerned is to post their graphics accelerators and general hardware config. As well as What OS and Graphics driver version they have. Maybe we will be able to see a pattern emerge.

When you move the slider down to that level you are disabling Directx for the OS. So it looks like either the controls that rely on the directx are having a problem. The Grid control is pretty standard, does anyone have a windows app that uses the same grid control? If we can find something that uses it and its having the same problem -- then its to do with the grid. Maybe replacing the grid with a newer version or finding out if SQL server's client tools upgrade the grid control might have somehting to do with it.

Anyone else have any ideas?

Everyone so far in the threads is using an Nvidia chipset. Also, looks like a Quadro based chipset too.

Is there anyone with another manufacturer's chipset getting the same issue?

If its so far only nvidia; maybe we should contact their driver team and ask them some questions. Anyone got a contact at Nvidia?

Hi.

Yup, I downloaded and switched to pinstriped background mode in Lightroom 2 beta:

HW Acceleration on fullmade it unusable, while on level 2 you don't notice a refresh at all.

I have this problem off and on when connecting to sql server on network and sql server on remote site. I use Dell OptiPlex GX280 with Intel 82915G/GV/910GL Express Chipset.

What is the deal with this problem? At first I thought it was the connection but connecting on local network has same problem so now I'm not sure.

Drawing the Result grid have no performance problems!

FWIW, I have the same issue with my hardware, which is using an NVIDIA Quadro FX 3700. ForceWare version 169.39. Video BIOS version 62.92.19.00.07. I am not only seeing this issue with SQL Server Management Studio 2005, but also with the Query Results window from Team Explorer 2005 within Visual Studio 2005. Setting the hardware acceleration to the third tick solves the problem for both pieces of software. One tip for those with multiple monitors is that you can set the hardware acceleration up for each monitor - so you could have one monitor set to Full and run your DirectX intensive apps on that monitor.

I guess we by now know that something isn't as it should be. But I don't have a clue on where and how to start testing in order to find a solution (better than lowering the hardware acceleration).

Are there any that have contacted M$ and gotten a decent reply/hotfix/tip? I find it rather weak by M$ not to take this seriously, but maybe they haven't been given it enough focus? Do they even READ these forum threads?

Anyone contacted NVIDIA about it?I noticed that my NVIDIA GTX 8800 also gave me a slow MSSQL experience.

Has anyone found a solution to this problem? I'm running into the same issue on an 8500gt.

Turning down acceleration to ensure directx acceleration is turned off is the tweak you need. With the nview desktop manager you can create application-specific settings. I've had to do this to accommodate autodesk Inventor running alongside apps that use the grid control with good results.

The question is:

Does Microsoft fix the Gridview component - so it works along with all hardware accelerators?

Does anyone know if this problem still exists in SQL 2008 Management Studio (onhardware accelerators pc's) or any other newer VS2008 software?

Terkild

Just turn hardware acceleration down to the point where DirectX acceleration is turned off. Another option is to use the nview desktop manager to create application-specific settings for those apps where the gridview is used and turn off DirectX acceleration just for those apps. Hope this helps.

Thanks for the reply. I had already disabled DirectX but that doesn't seem to be an ideal solution. The nview desktop sounds like it would be great except itlooks likenvidia has excluded it from their latest drivers and although it says in the release notes thatit exists as an add-in I can't seem to find it. This is a problem that Nvidia and/or MS should address. I guess we're in the minority so it's not important.

I'm running an 8600M GT. I have the same issue with management studio grids but mine is a bit more serious. If I open a grid it is slow and causes screen artifacts. If I try to scroll it I get a BSOD. Not good. You mention using nview. I've added sqlwb to the applications in the nview properties, but the options I see for available tweaks in "Individual Settings" and "Enhancements" don't seem to have anything to do with turning DirectX on or off. Could you please indicate what settings you modified at the nview application level? It is really difficult to work with Management Studio, Visual Studio 2008, and Flash at the same time. I need the directx for flash and I'm constantly having to shut down management studio and turn the acceleration back on through the advanced display properties.

Thanks in advance!

The only settings I've added are for AutodeskInventor. I turned hardware acceleration down to the point that DirectX acceleration was off at the desktop level. I then created an application-specific setting for Inventor and disabled it. This effectively forced NView to disregard settings for the desktop and allowedInventor to manage it's own DirectX settings. I'm assuming that some of the calls the application makes into the DirectX libraries are somehow optimized when the manager is active. You might try the same trick with Flash. We have a laptop that is having the same problem with screen artifacts and this didn't seem to resolve that problem. I'm starting to wonder if the NVidia drivers are really fully DirectX compliant.

I ran into this problem for a long time with nVidia cards. I just recently installed the latest nVidia drivers and it has drastically improved the performance of the grids in SSMS and other programs.

You can download the latest drivers here: http://www.nvidia.com/Download/index.aspx?lang=en-us

I installed: 178.24, released 15 Oct, 2008 for my GeForce 8500 GT PCIx card.

Yes. Confirmed! This completely fixed the issue for me. Yahoo!

Thank you!

- Spike