• Adam Thurgar

Disable TCP settings

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.

9 views0 comments

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 compatibility level of 110 (SQL Server 2012), but when run unde

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 from the software provider is always the same - you have index f

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 from. They also knew that deleting large amounts of data causes t