- 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.