Improve SQL Network Performance

Need to improve your SQL Network Performance?

  • Disable LLMNR – Clients and Server (Click enable)
  • Adapter settings adjustment to match registry entry- RSS (below)
    • Disable all but Flow Control and RSS settings – match registry entries for RSS
    • Applies to both client and servers
  • Add the registry entry (Server and Client)-
    HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters. The MaxNumRssCpus value is a DWORD type and, if it is not present, NDIS uses the default value of 4.
  • Adjust as necessary. References – 
  • netsh interface tcp set global rss=enabled from command prompt
    Client and Server
  • Clean your TempDB (Server)
    • If you write an odd query on your SQL server, you may have made your tempdb large. This can cause problems by filling your disk. While Tempdb stores temporary tables and cached information that helps with the performance of your server, you may want to shrink the table and allow it to rebuild – thus making your server perform better. Here’s a query that may help.

      The apostrophe ‘ may need to be changed if you copy and paste this query.

      use tempdb
      DBCC SHRINKDATABASE(tempdb, 10);
      dbcc shrinkfile (‘tempdev’)
      dbcc shrinkfile (‘templog’)
      SELECT name, size
      FROM sys.master_files
      WHERE database_id = DB_ID(N’tempdb’);

Group Policy for LLMNR

GP Edit

The Advanced settings of your network card (If you have more than one, refer to the article listed above).


The registry entry –

RSS Processors

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 Technology and tagged , , , . Bookmark the permalink.

Leave a Reply

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

You are commenting using your 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