This is not the answer to all occurences of the issue but try the following;
Now try SSMS again, was it faster? Either way re-check the setting to be safe.
Ok so here is what is happening. SSMS has a high percentage of managed code, all of this code is signed when we ship it. At start up (if this setting is checked) the .Net Runtime tries to contact crl.microsoft.com to ensure that the cert is valid(there were some fake certs issued in Microsoft's name a while back so this is a very valid concern). If there is no internet connection or there is a problem contacting the certificate revocation list server then this will delay SSMS startup.
Now this problem is not unique to SSMS, it actually applies to all managed code and flipping the switch switches off this check for ALL managed code on the machine which may not be a good idea, but at this time I don't know of a way to switch off the check on a per app basis, there are some folks looking however.
There have been several internal discussions on this and some external ones as well.
It works!!! great!
I just bumped into an interesting article on Euan Garden's blog on how to boost the startup of SSMS.
This issue is covered pretty well by blogs in the context of SSMS ( Dan Jones and Euan Garden ) and in
PingBack from http://maassql.wordpress.com/2007/09/20/sql-server-management-studio-slow/
If you miss Query Analyzer you can still vote on the Connect site for this tool: https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=297428&wa=wsignin1.0
PingBack from http://furrukhbaig.wordpress.com/2008/03/07/ssms-slow-startup/
Like many of you, I find that working in SSMS is a joy, compared to Query Analyzer. Like many of you, I miss things like CTRL B to move the splitter bar between the query window and the results pane, and I've moved on to just using CTRL R to get rid of
As part of my work I have to manage quite a few SQL Server 2005 installations. Some servers I was able