top of page

Disable TCP settings

  • Adam Thurgar
  • Apr 14, 2018
  • 1 min read

As part of an application upgrade at a client. I was asked did I see any issues in disabling the following TCP settings on the SQL Server (and potentially all of their SQL Servers):

- Receive-Side Scaling

- TCP Chimney

- TCP/IP Offload engine

- TCP Segmentation Offloading

These are setting at the Windows Server level and I have never disabled any of these settings and recommended that it only be implemented after thorough testing. Most of these settings are performance based - moving processing away from the CPU to the network adapter. Which made me question why this application needed these to be disabled and what issue within the application they are trying to overcome.

Finally I could see no reason to change this across all SQL Servers, you are better off going with the installation defaults, unless you have a specific reason not to.


 
 
 

Recent Posts

See All
Cardinality estimator

Recently I was asked by a software vendor to review a particular query that ran in under a second on a SQL Server 2014 installation at a...

 
 
 
Index fragmentation

A law firm client, occasionally has issues with their legal software, that is provided by the global leader in this field. The response...

 
 
 
Deleting large amounts of data

I had a client call me about wanting to delete a large amount of data from their database. They knew what tables they wanted to delete...

 
 
 

Comments


bottom of page