Wednesday, June 6, 2007

Management Studio Speedup : Managed Code

SQL Server Management Studio Speedup (Prevent SQL taking ages to open)
  1. Close SSMS.
  2. Go into IE, select Tools | Internet Options | Advanced
  3. If “Check publisher’s certificate revocation” under the security node is checked, then uncheck it.
  4. Close IE, Reopen SSMS.

Why all this bother? What has Internet Explorer got to do with SQL Management Studio?

Basically, Managment Studio contains 'Managed code'. It attempts to contact crl.microsoft.com on startup to check for a certificate for the code when this setting is allowed.
Bear in mind this setting will affect other apps too.

No comments: