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
Other Knowledgebase Articles
Basic SQL Hosting
# of Domains:
4
# of SQL Server Databases:
4
Disk Space:
50GB
Bandwidth:
Unmetered
SQL Server 2016
Monthly:
$4.99
Express Hyper-V Hosting
Dedicated Memory:
2GB
Disk Space:
120GB
Bandwidth:
Unmetered
Windows 2016/2012:
Free
Monthly:
$11.99
Dedicated SQL Server
CPU:
Quad-Core X3440 CPU
RAM:
16GB RAM
Disk:
2x120GB SSD + 300GB SATA
RAID:
RAID 1
Bandwidth:
Unmetered
Windows 2016/2012:
Free
Monthly:
$79.00