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

Other Knowledgebase Articles

Basic SQL Hosting

# of Domains: 4
# of SQL Server Databases: 4
Disk Space: 50GB
Bandwidth: Unmetered
SQL Server 2014
Monthly: $4.99
More Information About Basic Shared SQL Server Hosting Plan

Express Hyper-V Hosting

Dedicated Memory:2GB
Disk Space: 100GB
Bandwidth: Unmetered
Windows 2012/2008: Free
Monthly: $11.99
More Information About Express Windows Hyper-V Server

Dedicated SQL Server

CPU: Quad-Core X3440 CPU
RAM: 16GB RAM
Disk: 2x120GB SSD + 300GB SATA
RAID: RAID 1
Bandwidth: Unmetered
Windows 2012/2008: Free
Monthly: $79.00
More Information About Dedicated SQL Server with SSD
SQL Server Hosting | ASP.NET Hosting | DotNetNuke Hosting | Windows VPS Hosting | Dedicated Windows Server Hosting