Slow SQL Server Management Studio in Vista Operating System

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.

• Go to Start > Programs > Accessories. Right click "Command Prompt" and choose "Run as administrator".

• Type the following command and press Enter:

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

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

• Reboot the computer

Posted in: SQL