<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2005
»
Administering
»
Disable TCP Chimney by default?
Disable TCP Chimney by default?
Rate Topic
Display Mode
Topic Options
Author
Message
Jon.Morisi
Jon.Morisi
Posted Monday, January 25, 2010 11:35 AM
SSC Veteran
Group: General Forum Members
Last Login: Tuesday, May 07, 2013 8:12 AM
Points: 275,
Visits: 679
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
SQLRNNR
SQLRNNR
Posted Monday, January 25, 2010 4:15 PM
SSCoach
Group: General Forum Members
Last Login: Yesterday @ 1:07 PM
Points: 18,733,
Visits: 12,332
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 2008
SQL RNNR
Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #853373
Ignacio A. Salom Rangel
Ignacio A. Salom Rangel
Posted Monday, January 25, 2010 4:19 PM
Hall of Fame
Group: General Forum Members
Last Login: Friday, May 10, 2013 2:49 PM
Points: 3,051,
Visits: 1,356
I agree with Jason!
My blog
Post #853375
Brad Griffin
Brad Griffin
Posted Tuesday, February 09, 2010 9:33 PM
Grasshopper
Group: General Forum Members
Last Login: Tuesday, February 19, 2013 8:14 PM
Points: 12,
Visits: 80
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
mike 84768
mike 84768
Posted Thursday, February 11, 2010 1:20 AM
SSC 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
Brad Griffin
Brad Griffin
Posted Thursday, February 11, 2010 4:13 PM
Grasshopper
Group: General Forum Members
Last Login: Tuesday, February 19, 2013 8:14 PM
Points: 12,
Visits: 80
So far, by disabling the TCP Chimney Offload feature our issue seems to have been resolved.
Brad
Post #864386
Jon.Morisi
Jon.Morisi
Posted Thursday, February 11, 2010 4:31 PM
SSC Veteran
Group: General Forum Members
Last Login: Tuesday, May 07, 2013 8:12 AM
Points: 275,
Visits: 679
Good to know, thanks Brad
Post #864396
Ignacio A. Salom Rangel
Ignacio A. Salom Rangel
Posted Friday, February 12, 2010 2:16 AM
Hall of Fame
Group: General Forum Members
Last Login: Friday, May 10, 2013 2:49 PM
Points: 3,051,
Visits: 1,356
Thank you for sharing the solution.
My blog
Post #864501
Jon.Morisi
Jon.Morisi
Posted Monday, February 22, 2010 12:33 PM
SSC Veteran
Group: General Forum Members
Last Login: Tuesday, May 07, 2013 8:12 AM
Points: 275,
Visits: 679
interesting....
TCP Offloading again?!
Post #870639
Ignacio A. Salom Rangel
Ignacio A. Salom Rangel
Posted Monday, February 22, 2010 2:27 PM
Hall of Fame
Group: General Forum Members
Last Login: Friday, May 10, 2013 2:49 PM
Points: 3,051,
Visits: 1,356
Thank you Jon. That was a great blog.
My blog
Post #870743
« Prev Topic
|
Next Topic »
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
