Slow SQL Server Management Studio in Vista Operating System

Problem

It is very slow when you try to open a remote database using SQL Server Management Studio in Vista operating system.

Solution

Disable TCP Auto-Tuning and Receive-Side Scaling State.

1. Go to Start > Programs > Accessaries. Right click "Command Prompt" and choose "Run as administrator".
   
2. Type the following command and press Enter:

       C:\>netsh interface tcp set global rss=disabled
       C:\>netsh interface tcp set global autotuninglevel=disabled
   			

   
3. Reboot the computer

Navigator

Express SQL Server

Standard SQL Server