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. Click Start > Programs > Accessories. 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.