This is a short post, leave me a comment if you have TCP Chimney disabled or enabled. This was suggested to us when we had a problem with mirroring between two servers a while back. I am just wondering if it is disabled or enabled for most of you

You can easily check by running this from a command prompt netsh int tcp show global

Or if you want to use SSMS, you can use _xpcmdshell

sql xp_cmdshell ‘netsh int tcp show global’ ```

Here is the output for one of my servers

Querying active state...
TCP Global Parameters
Receive-Side Scaling State          : enabled 
Chimney Offload State               : disabled 
Receive Window Auto-Tuning Level    : normal 
Add-On Congestion Control Provider  : ctcp 
ECN Capability                      : disabled 
RFC 1323 Timestamps                 : disabled 

There is a post on the CSS SQL Server Engineers blog where you can read why disabling it could speed up your queries if you have a problem:

So leave me a comment telling me if you have it disabled or enabled. And if you have it disabled, did you disable it because you had a problem?