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.