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.

Go to Start > Programs > Accessaries. 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

Navigator

Shared Hosting

# of Domains: 2
# of SQL Server Databases: 2
Disk Space: Unlimited
Bandwidth: Unlimited
Email: Unlimited
SQL Server 2008 R2
Monthly: $4.⁹⁹

Windows Hyper-V Server

Dedicated Memory:2GB
Disk Space: 200GB
Bandwidth: Unlimited
Windows 2008/2003: Free
Monthly: $49.⁹⁹

Dedicated SQL Server

CPU: Intel Dual-Core Sandy Bridge I3-2100
RAM: 8GB RAM
Disk: 2x320GB SATA
RAID: Host RAID 1
Bandwidth: Unlimited
Windows 2008/2003: Free
Monthly: $99.⁰⁰