Speed up SQL Server Management Studio (SSMS)

 

[Solution] : Add an entry in your HOSTS

1. Press the keys [Win] + [R]
2. notepad %systemroot%\system32\drivers\etc\hosts.
3. Append the following..
   127.0.0.1    crl.microsoft.com
4. Save the file.

ref: http://www.virtualobjectives.com.au/sqlserver/ssms_slow.htm

[Solution] : Use sqlwb Utility –nosplash arguments

ex:

• ssms.exe –nosplash
• ssms.exe -nosplash -S "."
• ssms.exe -nosplash -S ".\SQLEXPRESS"

ref: http://msdn.microsoft.com/en-us/library/ms162825%28v=sql.90%29.aspx

[Solution] : Uncheck “Check publisher’s certificate revocation”

1. Go into IE, select Tools|Internet Options|Advanced
2. If “Check publisher's certificate revocation” under the security node is checked, then uncheck it.

ref: http://blogs.msdn.com/b/euanga/archive/2006/07/11/662053.aspx