VirtualObjectives

Microsoft SQL Server Management Studio is too Slow

In a corporate environment it is not uncommon for Microsoft SQL Server Management Studio (SSMS) for SQL Server 2005 to take over 45 seconds to start as well as lags and delays when opening various windows and dialog boxes from within the application. If you are experiencing this issue, then a quick fix is to add an entry in your HOSTS. file that points crl.microsoft.com to 127.0.0.1

  1. Exit SSMS
  2. Press the keys [Win] + [R]
  3. Enter the following..
    notepad %systemroot%\system32\drivers\etc\hosts.
  4. Append the following..
    127.0.0.1    crl.microsoft.com
  5. Save the file.
  6. Start SSMS (ah! much better)
The reason why it is slow is because .Net Runtime tries to contact crl.microsoft.com to ensure that the certificate in various .Net packages that were shipped with SSMS is valid.
If you are behind a firewall/proxy as is the usual case then there is no direct route out to the internet to crl.microsoft.com to validate the certificate(s) and it eventually times out. The wait for the time out causes the delay for each and every package it checks.

With the change to the HOSTS. file, you are forcing the certificate checks to crl.microsoft.com to route to the local host which immediately fails and the certificate checks are ignored.

The other option is to disable "Check for publisher’s certificate revocation" option in IE Advanced Options, however, this is not advised.

IE Advanced Options