Login or Sign Up to become a member!
LessThanDot Sit Logo

LessThanDot

Data Management

Less Than Dot is a community of passionate IT professionals and enthusiasts dedicated to sharing technical knowledge, experience, and assistance. Inside you will find reference materials, interesting technical discussions, and expert tips and commentary. Once you register for an account you will have immediate access to the forums and all past articles and commentaries.

LTD Social Sitings

Lessthandot twitter Lessthandot Linkedin Lessthandot friendfeed Lessthandot facebook Lessthandot rss

Note: Watch for social icons on posts by your favorite authors to follow their postings on these and other social sites.

Your profile

    Tools

    Tag cloud

    backup bigdata book business intelligence database denali functions gotcha how to howto indexing mongodb nosql performance sql sql advent 2012 sql friday sql server sql server 2000 sql server 2005 sql server 2008 sql server 2008 r2 sql server 2012 sql server denali sqlcop ssis ssms ssrs t-sql tip

    Authors

    Main Categories

    Search

    XML Feeds

    What is RSS?

    Google Ads

    « SQL Saturday #67 Chicago 2011: Have Fun Storming the Castle!24 Hours of PASS: Wrap-Up, Slides, Demos and High-Fives »
    3
    comments

    Do you have Chimney Offload State disabled?

    by SQLDenis on Mar 18, 2011 in categories Data Modelling & Design
    Instapaper

    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 xp_cmdshell

    tsql
    Line number Off | Hide | Select all
    1. 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?

    About the Author

    User bio imageDenis 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.
    Social SitingsTwitterFacebookLinkedInHomePageFlickrLTD RSS Feed
    1556 views
    Read More Posts by SQLDenis
    InstapaperVote on HN

    3 comments

    Comment from: David Forck (thirster42) [Member]
    on my dev server it's set to automatic.
    03/18/11 @ 07:51
    Comment from: SQLDenis [Member] Email
    SQLDenis Yes on my workstation I also have it set to automatic



    Here is the output from a command prompt



    TCP Global Parameters
    
----------------------------------------------
    
Receive-Side Scaling State          : enabled
    
Chimney Offload State               : automatic
    
NetDMA State                        : enabled
    
Direct Cache Acess (DCA)            : disabled
    
Receive Window Auto-Tuning Level    : normal
    
Add-On Congestion Control Provider  : none
    
ECN Capability                      : disabled
    
RFC 1323 Timestamps                 : disabled
    
** The above autotuninglevel setting is the result of Windows Scaling heuristics
    
overriding any local/policy configuration on at least one profile.
    03/18/11 @ 07:57
    Comment from: Naomi Nosonovsky [Member]
    Naomi Nosonovsky output
    Querying active state...
    NULL
    TCP Global Parameters
    ----------------------------------------------
    Receive-Side Scaling State : enabled
    Chimney Offload State : automatic
    NetDMA State : enabled
    Direct Cache Acess (DCA) : disabled
    Receive Window Auto-Tuning Level : normal
    Add-On Congestion Control Provider : none
    ECN Capability : disabled
    RFC 1323 Timestamps : disabled
    ** The above autotuninglevel setting is the result of Windows Scaling heuristics
    overriding any local/policy configuration on at least one profile.
    NULL
    NULL
    03/24/11 @ 21:41

    Leave a comment


    Your email address will not be revealed on this site.

    To mislead the spambots.

    Your URL will be displayed.
    (Line breaks become <br />)
    (Name, email & website)
    (Allow users to contact you through a message form (your email will not be revealed.)

    Powered by B2Evolution
    Valid XHTML | Valid CSS