November 3, 2007 at 2:10 am
FAQ, Why does SSMS take 2 minutes to start up?
This is not the answer to all occurrences of the issue but try the following;
• Shut down SSMS.
• Go into IE, select Tools|Internet Options|Advanced
• If “Check publisher’s certificate revocation” under the security node is checked, then uncheck it.
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 start-up.
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 application basis, there are some folks looking however.
We did this on a Live Server now it only takes 2 Seconds to Open!!
November 4, 2007 at 9:59 am
Thanks for the note!
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
November 5, 2007 at 12:50 am
-Thanks for the tip. It doesn't change much overhere. (it was unchecked, I checked it and didn't notice big a change)
- I'm using the /nosplash startup parameter, this also gives you a couple of seconds your don't have to wait.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
November 5, 2007 at 6:25 am
Great tip! AAAA++++
Thanks!
Jacob Milter
November 6, 2007 at 2:02 am
I also found this overview :
http://www.sql-server-performance.com/faq/sql_server_management_studio_load_time_p1.aspx
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
November 6, 2007 at 11:26 pm
Try this KB article ... the problem described there is similar yours..
http://support.microsoft.com/?scid=kb%3Ben-us%3B555686&x=14&y=11
bouhss
November 7, 2007 at 5:04 am
The long startup time is usually due to the attempt to contact crl.microsoft.com being blocked by a firewall. Another trick to speeding up the SSMS startup is to make an entry in your hosts file pointing crl.microsoft.com to the loopback address 127.0.0.1. The attempt to phone home fails immediately that way instead of waiting for a timeout. That way every individual user on a server doesn't have to change their IE settings. The attempt to phone home fails immediately instead of waiting for a timeout.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply