CREATE BLOG dbo.SqlServer: Speed Up SQL Server Management Studio (SSMS)

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...