TCP Chimney issue on Windows 2003 Service Pack 2
If you are running Sql Server 2005 on Windows Server 2003 SP2, you may get this message from Sql Server native client connection:
An existing connection was forcibly closed by the remote host
This is most likely caused by a “feature” called TCP Chimney offloading. On the server, run:
Netsh int ip set chimney DISABLED
should fix your problem. It seems Visual Basic 6 (VB6) based applications and Heat Call Logging are particularly susceptible to this problem.
KB article here: http://support.microsoft.com/default.aspx/kb/945977
Farhad Said,
July 1, 2008 @
Does this issue would cause your CPU utilization to go UP to 100% and cause SQLserver to stop responding?
Haidong Ji Said,
July 1, 2008 @
That has NOT been my experience.
Steve Said,
July 28, 2009 @
I had an issue with low throughput on my backup jobs that was corrected by disabling tcpchimney using the Netsh int ip set chimney DISABLED command, went from 35mb per min to 450 MB per min.