Wednesday, November 01, 2006

 

Speed Up SQL Server Management Studio (SSMS) - SSMS Is Slow!

A friend of mine, Chris Radcliffe, shared this tip with me last week and lo and behold, it fixed a SQL Server installation that took up to 2 minutes to load Management Studio and made it insta-load! Here is what Chris says to do and it worked for me -

  • Go to Internet Explorer ( yes IE!)
  • Browse to Tools>Internet options>Advanced tab
  • Uncheck the check box under Security called "Check for publisher's certificate revocation" - This stops MS from checking the Internet every 15 seconds.........

Good one Bill Gates..

regards to all

Chris

Thanks, Chris! One caveat - there are ramifications of not checking for the certificate information so know what they are before you set this...



# posted by Scott Whigham @ 7:31 PM
Comments:
Thanks a lot for the tip

Bye
# posted by Anonymous Anonymous : 12:50 AM
 
This issue was literally haunting my worst nightmares: it was driving me crazy!!!

Thank you a *LOT* for this tip!!

Roberto Dev
# posted by Anonymous Anonymous : 7:39 AM
 
Post a Comment

Links to this post:

Create a Link



<< Home

This page is powered by Blogger. Isn't yours?