SQL Management Studio is slow or hesitates

If your Microsoft SQL Management Studio is slow and/or hesitates, you can tweak your server by performing the steps below.

Open Internet Explorer and select Tools, Internet Options and click the Advanced Tab.

“Check for server certificate revocation” and “Check for signatures for downloaded programs” under the advanced options of Internet Explorer should be unchecked.


You should also navigate to the following registry key –

HKEY_CURRENT_USER\Software\Microsoft\Internet Explorer\Download

Make sure the registry key in the right pane and insure the CheckExeSignatures is set to no

You can also add the following line to the end of  your hosts file –     crl.microsoft.com

Add a switch to the Management Studio shortcut by using /nosplash :
Start > Programs > SQL Server 2005 or 2008 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

Disable Help Online


Note: To speed up connections on client computers, disable LLMNR.

About TCAT Shelbyville IT Department

The Tennessee College of Applied Technology - is one of 46 institutions in the Tennessee Board of Regents System, the seventh largest system of higher education in the nation. This system comprises six universities, fourteen community colleges, and twenty-six Applied Technology Colleges.
This entry was posted in Computer hardware, Information Technology, network, Networking, Technology, Windows and tagged , , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s