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

沒有留言:

張貼留言