Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Disable TCP Chimney by default? Expand / Collapse
Author
Message
Posted Monday, January 25, 2010 11:35 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 6:10 PM
Points: 293, Visits: 821
Hi,
I've been reading up on the TCP Chimney offload and the impacts on Windows Server 2003 SP2:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;948496
http://statisticsio.com/Home/tabid/36/articleType/ArticleView/articleId/305/TCP-Chimney-Offload.aspx
http://support.microsoft.com/default.aspx?scid=kb;EN-US;912222
http://blogs.msdn.com/psssql/archive/2008/10/01/windows-scalable-networking-pack-possible-performance-and-concurrency-impacts-to-sql-server-workloads.aspx

I'm considering disabling this feature for all of my servers that run this OS.
There doesn't seem to be any benefits only negative impacts.
Anyone else out there disable this setting on all their servers?
Post #853198
Posted Monday, January 25, 2010 4:15 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 12:45 PM
Points: 17,947, Visits: 15,941
I have never encountered any of these issues outlined in the reference articles. Thus, we have never pursued disabling the chimney. Since we still don't experience the problems, then I would recommend only pursuing the fix if you are experiencing on the problems outlined in the articles.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #853373
Posted Monday, January 25, 2010 4:19 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Wednesday, November 5, 2014 3:47 PM
Points: 3,087, Visits: 1,437
I agree with Jason!




My blog
Post #853375
Posted Tuesday, February 9, 2010 9:33 PM


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, November 20, 2014 10:07 PM
Points: 16, Visits: 127
We are about to disable the TCP Chimney Offload feature. After about 8 months of the occasional failure we have been able to isolate it to this feature (see MS KB article 942861).

Hopefully by disabling this feature our problem will be resolved.

Brad




Post #862919
Posted Thursday, February 11, 2010 1:20 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, April 19, 2011 7:18 PM
Points: 40, Visits: 35
I had a giant problem with dropped packets if a NIC was running over 70% capacity...was resolved by disabling this feature. This only happened on a particular type of server (blade) with a specific NIC model (driver version had no impact). I have never seen this problem before or since and have never seen it impact SQL adversely.
Post #863894
Posted Thursday, February 11, 2010 4:13 PM


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, November 20, 2014 10:07 PM
Points: 16, Visits: 127
So far, by disabling the TCP Chimney Offload feature our issue seems to have been resolved.

Brad



Post #864386
Posted Thursday, February 11, 2010 4:31 PM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 6:10 PM
Points: 293, Visits: 821
Good to know, thanks Brad
Post #864396
Posted Friday, February 12, 2010 2:16 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Wednesday, November 5, 2014 3:47 PM
Points: 3,087, Visits: 1,437
Thank you for sharing the solution.




My blog
Post #864501
Posted Monday, February 22, 2010 12:33 PM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 6:10 PM
Points: 293, Visits: 821
interesting....
TCP Offloading again?!
Post #870639
Posted Monday, February 22, 2010 2:27 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Wednesday, November 5, 2014 3:47 PM
Points: 3,087, Visits: 1,437
Thank you Jon. That was a great blog.




My blog
Post #870743
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse