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
xp_cmdshell 'netsh int tcp show global'
Here is the output for one of my servers
Querying active state... NULL 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 NULL NULL
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: http://blogs.msdn.com/b/psssql/archive/2010/02/21/tcp-offloading-again.aspx
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?
Denis has been working with SQL Server since version 6.5. Although he worked as an ASP/JSP/ColdFusion developer before the dot com bust, he has been working exclusively as a database developer/architect since 2002. In addition to English, Denis is also fluent in Croatian and Dutch, but he can curse in many other languages and dialects (just ask the SQL optimizer) He lives in Princeton, NJ with his wife and three kids.
