Microsoft SQL Server Management Studio加速

一直都覺得Microsoft SQL Server Management Studio起動速度很慢，但又算不上是大食(相比VS2010)。
看過這裡，原來是有方法加快開啟速度的。

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..
4. notepad %systemroot%\system32\drivers\etc\hosts. Append the following..
5. 127.0.0.1 crl.microsoft.com
6. Save the file.
7. 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.