SQL Server Management Studio spends over 10 seconds to load






Problem description
SQL Server Management Studio spends over 10 seconds to load.


Cause
In general, this behavior is due to 2 things:

1. The host computer not has access. By default "SQL Server Management Studio" is configured to use online help resources.

2. The host computer not has access. SSMS tries to go on internet to check for server certificate revocation until "SQL Server Management Studio" got a timeout, is like hanging.


Resolution
To fix the issue, you can follow the 3 steps below :

Step 1 : Following the article : When running "SQL Server Management Studio" the application may load slowly.
http://support.microsoft.com/kb/555686/

Step 2 : Disable "Check for publishers certificate revocation" and "check for server certificate revocation" option under the Internet Explorer -> "Internet Options" -> Advanced".

Step 3 : Add a switch to the Management Studio shortcut by using /nosplash :
Start > Programs > SQL Server 2005 program group > 'SQL Server Management Studio' program.
Then, right-clicking and open the General tab, then select shortcut tab to add 'nosplash' switch.
Sample : "C:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe" /nosplash


These tree steps combined should improve the load time of SQL Server Management Studio.

Enjoy SQL Server 🙂









Michel Degremont | Microsoft EMEA
Product Support Services Developer - SQL Server Core Engineer |

Comments (1)

  1. AndreQ says:

    had no luck with /nosplash, however -nosplash seemed to work just fine.

Skip to main content