December 9, 2010 at 8:23 pm
Problem:
SSMS on many Windows 7 (64) computers are quite slow compared with slower XP computers with less memory. Simple query takes anywhere from 3 to 30 sec.
Solution:
After sifting through many blogs, I came across the following solution which fixed my computer.
1. SSMS need to be set to run in XP (SP3) compatible mode.
Right click on SSMS program link and select Properties. Select “Run this program in compatibility mode for” and select Windows XP (Service Pack 3).
2. Ensure that User Account Control setting is set to at least one level above the lowest.
Control Panel (view by icons) -> User Accounts -> Change User Account Control Settings
Select anything but the lowest setting.
3. Restart the computer
Fix is originally posted at http://social.msdn.microsoft.com/Forums/en/sqltools/thread/27197d4e-3f08-41ea-a8a9-36af33ee431d
Thanks to the original author (may east).
Updated on 3/12/2011:
The above solution worked OK as long as you open the file using file-> open. Drag and drop did not work, and double clicking on file did not work.
Please follow the instructions given below to resolve the issue completely.
1. Uncheck the setting “Run this program …” for SSMS
2. Uninstall the following HP programs (Control Panel -> Programs and Features)
a. Device Access Manger for HP ProtectTools
b. Drive Encryption for HP ProtectTools
c. HP ProtectTools Security Manager (if you want, you can answer Yes to preserve current data, during the process of uninstalling)
3. Restart the computer
Good luck.
May 10, 2011 at 12:21 pm
Thank you very much for posting this. Worked for me. Was driving me crazy for a week straight...couldn't get any work done!
May 10, 2011 at 1:52 pm
It sounds more like this is an HP issue than a Windows 7 one. I'm running on Win 7 64-bit right now, and SSMS has no problem with it, without the workarounds here. Didn't even know there could be a problem with it.
Good to know, nonetheless. In case I ever use an HP computer.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
May 10, 2011 at 1:58 pm
Guess I should have mentioned that... I am using an HP at work and didn't think about HP's apps being the issue. After uninstalling (doing the steps after the 3/12/2011 update) is what worked for me.
May 10, 2011 at 10:15 pm
prasad.perini (12/9/2010)
Problem:SSMS on many Windows 7 (64) computers are quite slow compared with slower XP computers with less memory. Simple query takes anywhere from 3 to 30 sec.....
Thanks Prasad for posting the solution you found. I am sure it has helped many members of SSC.
I had same problem in my HP laptop with Windows 7 64bit.
July 25, 2011 at 7:14 pm
Thank you Prasad!
This was making me go insane. The update you posted was the specific fix I needed as I am using a HP computer. I also changed the compatibility to Windows XP - Service Pack 3 and changed the UAC level, but only after uninstalling the listed HP applications did I get a good result when running SSMS.
Cameron
July 25, 2011 at 9:57 pm
Thanks it helped me
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply