I've followed the instructions in http://blogs.msdn.com/b/psssql/archive/2010/02/21/tcp-offloading-again.aspx to disable TCP Chimney Offload. Disabled the Chimney Offload via netsh and on the NIC disabled Large Send Offload v2 (IPv4), Large Send Offload
v2(IPv6), Receive Side Scaling, TCP Checksum Offload (IPv4), , TCP Checksum Offload (IPv6). I'm still seeing connection issues and do see them in when querying sys.dm_os_ring_buffers and looking at RING_BUFFER_CONNECTIVITY. Is there a doc somewhere
that explains the values returned by this (i.e. SniProvider, State, TdsInputBufferError, etc) ? Also if anyone has resolved these same issues with SQL Server 2008 R2 running on Windows Server 2008 R2.
Thanks in advance,
View Complete Post