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 SMSSÃÂ Performance 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 isÃÂ a laptop Compaq 8710w) and switching off the accelerator using Displays/Advanced/TroubleshootingÃÂ by 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-PackardSystem Model: HP Compaq 8710wBIOS: EPP runtime BIOS - Version 1.1ÃÂ Processor: Intel(R) Core(TM)2 Duo CPUÃÂ ÃÂ ÃÂ ÃÂ T7300ÃÂ @ 2.00GHz (2 CPUs)Memory: 3072MB RAMPage File: 515MB used, 4439MB availableWindows Dir: C:\WIN
View Complete Post