Frequently Asked Question

Microsoft SQL Server Management Studio is too Slow
Last Updated 10 months ago

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 to

  1. Exit SSMS
  2. Press the keys [Win] + [R]
  3. Enter the following..
    notepad %systemroot%\system32\drivers\etc\hosts.
  4. Append the following..
  5. Save the file.
  6. Start SSMS (ah! much better)
The reason why it is slow is because .Net Runtime tries to contact 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 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 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.


Please Wait!

Please wait... it will take a second!