Partager via

FAQ, Why does SSMS take 45s to start up?

  • Article

This is not the answer to all occurences 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 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.

Comments

  • Anonymous
    July 12, 2006
    That helped. That really did. Thx a lot, Euan

  • Anonymous
    July 13, 2006
    Does anyone know the location of this setting in IE7?  I couldn't find any options with that wording.

  • Anonymous
    July 16, 2006
    In IE7 it is under the Internet Options Advanced tab.  Scroll down to the Security section.
    It is still listed as “Check publisher’s certificate revocation”.

  • Anonymous
    July 19, 2006
    The comment has been removed

  • Anonymous
    July 19, 2006
    Quick fix that works...
    add to your host file the following lines

    # entry to get around diabolical Microsoft certificate checks
    # which slow down non internet connected computers
    127.0.0.1 crl.microsoft.com

  • Anonymous
    September 10, 2006
    The comment has been removed

  • Anonymous
    November 13, 2006
    It works!!! great!

  • Anonymous
    January 31, 2007
    I just bumped into an interesting article on Euan Garden's blog on how to boost the startup of SSMS.

  • Anonymous
    July 28, 2007
    This issue is covered pretty well by blogs in the context of SSMS ( Dan Jones and Euan Garden ) and in

  • Anonymous
    July 28, 2007
    This issue is covered pretty well by blogs in the context of SSMS ( Dan Jones and Euan Garden ) and in

  • Anonymous
    September 20, 2007
    PingBack from http://maassql.wordpress.com/2007/09/20/sql-server-management-studio-slow/

  • Anonymous
    October 01, 2007
    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

  • Anonymous
    March 07, 2008
    PingBack from http://furrukhbaig.wordpress.com/2008/03/07/ssms-slow-startup/

  • Anonymous
    September 27, 2008
    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

  • Anonymous
    October 27, 2008
    As part of my work I have to manage quite a few SQL Server 2005 installations. Some servers I was able

  • Anonymous
    November 13, 2008
    PingBack from http://michaelellerbeck.com/2008/11/13/sql-2005-managment-console-is-really-really-slow-fix/

  • Anonymous
    January 18, 2009
    PingBack from http://www.keyongtech.com/2243897-slow-browsing-to-select-file

  • Anonymous
    May 20, 2009
    FAQ,WhydoesSSMStake45stostartup?终于找到原因了，该描述来自EuanGarden的Blog（FAQ,WhydoesSSMStake45s...

  • Anonymous
    May 29, 2009
    PingBack from http://paidsurveyshub.info/story.php?title=euan-garden-s-blog-faq-why-does-ssms-take-45s-to-start-up

  • Anonymous
    May 31, 2009
    PingBack from http://hammockstandsite.info/story.php?id=380

  • Anonymous
    April 06, 2016
    That helped. That really did. Thx a lot, Euan

  • Anonymous
    September 12, 2018
    I can boot and log into my Surface Pro 4 faster that SSMS will take to get to the log on screen, highly irritating and time consuming for anyone who spends a lot of time managing SQL instances!