Monday, April 15, 2013

FIX - Slow SQL Connection in Windows 8 & Windows 7 (MSSQL) (Solution)

So far, the two most useful tweaks i've learned for Windows 7 & Windows 8 to address the issue of horribly slow SQL connection performance to a Microsoft SQL Server from a Windows 8 or Windows 7 machine are as follows:

1. In cmd run this command:
netsh interface tcp set global autotuninglevel=disabled
2. Disable LLMNR in gpedit.msc

After you run the first command you will have to restart the application that is experiencing the bottleneck in order to get the effects.

No comments:

Post a Comment