SQL connection slow in Windows 8 or 8.1

Here are several solutions for latency issues with SQL latency (applications connecting to SQL servers with Windows 8 and 8.1.

  • LLMNR in GPEdit – known SQL connection issues in 7 and 8
  • NetBT in GPEdit – Group Policy in Windows 8/8.1 long and short domain names
  • Network card – disable all advanced features with the exception of flow control (These options often help network cards NOT to offload on the CPU that may latency)
  • Known driver issues with the Realtek GBE Family Controllers (update drivers on all cards)
  • Good core switches at Gigabit speeds or  at least 100 mbps full
  • HOSTS file – adding the SQL server’s IP to NetBIOS name (misconfigured DNS servers or DNS issues) on the client computer
  • Disable your anti-virus and check the speed.  Is your anti-virus causing issues?
  • Network adjustments (depends on hardware) –

From a command prompt (administrator) type the following commands –
netsh int tcp set heuristics disabled

netsh int tcp set global rss=enabled
netsh int tcp set global chimney=enabled
netsh int tcp set global autotuninglevel=restricted
netsh int tcp set global ecncapability=disabled
netsh int tcp set global timestamps=disabled

To return to your default settings, go to a command prompt as an administrator and type –

netsh int tcp set heuristics default
netsh int tcp set global rss=default
netsh int tcp set global chimney=default
netsh int tcp set global autotuninglevel=normal
netsh int tcp set global ecncapability=default
netsh int tcp set global timestamps=default

Reboot your computer

See our other articles on SQL, Networking cards and other posts for screenshots

New policy settings in 8 and 8.1
http://blogs.technet.com/b/configmgrdogs/archive/2013/11/11/windows-8-and-windows-8-1-new-group-policy-settings.aspx

About TCAT Shelbyville IT Department

The Tennessee College of Applied Technology - is one of 46 institutions in the Tennessee Board of Regents System, the seventh largest system of higher education in the nation. This system comprises six universities, fourteen community colleges, and twenty-six Applied Technology Colleges.
This entry was posted in Computers, Education, Information Technology, network, Networking, Software, Technology, Windows. Bookmark the permalink.

2 Responses to SQL connection slow in Windows 8 or 8.1

  1. “Network card – disable all advanced features with the exception of flow control (These options often help network cards NOT to offload on the CPU that may latency)”

    Thank you posting this suggestion! It worked on a dev laptop that was only managing 20KB/s in response to remote queries. Now runs at full speed. It was a Qualcomm Atheros built in ethernet on a Lenovo G series, in case anyone else finds this 🙂

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s