TdsInputBufferError not 0 in LoginTimers errors of RING_BUFFER_CONNECTIVITY of sys.dm_os_ring_buffers I've got an issue with SQL Server.

The value of TdsInputBufferError is not 0 in LoginTimers errors of RING_BUFFER_CONNECTIVITY of sys.dm_os_ring_buffers.

This happens randomly, once or twice a week, at different times.

Is it an issue with networking drivers ? Virtualization infrastructure? What to monitor to find out? There is no other error/warning log anywhere (windows logs, syslogs, ...).

Full ringbuffer report:

&lt;Record id="33" type="RING_BUFFER_CONNECTIVITY" time="614408705"&gt;
  &lt;ConnectivityTraceRecord&gt;
    &lt;RecordType&gt;LoginTimers&lt;/RecordType&gt;
    &lt;Spid&gt;0&lt;/Spid&gt;
    &lt;SniConnectionId&gt;A4478B00-18A1-4147-A65E-2EB505DCA470&lt;/SniConnectionId&gt;
    &lt;SniConsumerError&gt;17830&lt;/SniConsumerError&gt;
    &lt;SniProvider&gt;7&lt;/SniProvider&gt;
    &lt;State&gt;11&lt;/State&gt;
    &lt;RemoteHost&gt;xxxx:xxx:xxxx:xx:xxxx:xxx:xxxx:xxxx&lt;/RemoteHost&gt;
    &lt;RemotePort&gt;56201&lt;/RemotePort&gt;
    &lt;LocalHost&gt;xxxx:xxxx:x:xxxx::xxxx&lt;/LocalHost&gt;
    &lt;LocalPort&gt;1433&lt;/LocalPort&gt;
    &lt;RecordTime&gt;1/20/2012 10:12:52.32&lt;/RecordTime&gt;
    &lt;TdsBuffersInformation&gt;
      &lt;TdsInputBufferError&gt;10054&lt;/TdsInputBufferError&gt;
      &lt;TdsOutputBufferError&gt;0&lt;/TdsOutputBufferError&gt;
      &lt;TdsInputBufferBytes&gt;0&lt;/TdsInputBufferBytes&gt;
    &lt;/TdsBuffersInformation&gt;
    &lt;LoginTimers&gt;
      &lt;TotalLoginTimeInMilliseconds&gt;0&lt;/TotalLoginTimeInMilliseconds&gt;
      &lt;LoginTaskEnqueuedInMilliseconds&gt;0&lt;/LoginTaskEnqueuedInMilliseconds&gt;
      &lt;NetworkWritesInMilliseconds&gt;0&lt;/NetworkWritesInMilliseconds&gt;
      &lt;NetworkReadsInMilliseconds&gt;0&lt;/NetworkReadsInMilliseconds&gt;
      &lt;SslProcessingInMilliseconds&gt;0&lt;/SslProcessingInMilliseconds&gt;
      &lt;SspiProcessingInMilliseconds&gt;0&lt;/SspiProcessingInMilliseconds&gt;
      &lt;LoginTriggerAndResourceGovernorProcessingInMilliseconds&gt;0&lt;/LoginTriggerAndResourceGovernorProcessingInMilliseconds&gt;
    &lt;/LoginTimers&gt;
  &lt;/ConnectivityTraceRecord&gt;
  &lt;Stack&gt;
    &lt;frame id="0"&gt;0X00000000019EAC4B&lt;/frame&gt;
    &lt;frame id="1"&gt;0X00000000019E7A36&lt;/frame&gt;
    &lt;frame id="2"&gt;0X00000000019EC6BE&lt;/frame&gt;
    &lt;frame id="3"&gt;0X0000000000CA81BC&lt;/frame&gt;
    &lt;frame id="4"&gt;0X000000000068B888&lt;/frame&gt;
    &lt;frame id="5"&gt;0X000000000064EF40&lt;/frame&gt;
    &lt;frame id="6"&gt;0X000000000064ED12&lt;/frame&gt;
    &lt;frame id="7"&gt;0X000000000064EA17&lt;/frame&gt;
    &lt;frame id="8"&gt;0X0000000000AB598A&lt;/frame&gt;
    &lt;frame id="9"&gt;0X0000000000AB5C25&lt;/frame&gt;
    &lt;frame id="10"&gt;0X0000000000AB5A56&lt;/frame&gt;
    &lt;frame id="11"&gt;0X0000000000AB61E2&lt;/frame&gt;
    &lt;frame id="12"&gt;0X0000000074A737D7&lt;/frame&gt;
    &lt;frame id="13"&gt;0X0000000074A73894&lt;/frame&gt;
    &lt;frame id="14"&gt;0X0000000076D2652D&lt;/frame&gt;
    &lt;frame id="15"&gt;0X00000000772CC521&lt;/frame&gt;
  &lt;/Stack&gt;
&lt;/Record&gt;
I can't give you answer but I can direct you towards it.


You need to download the public symbols for your installed
version of SQL Server
http://www.sqlskills.com/BLOGS/PAUL/post/How-to-download-a-sqlservrpdb-symbol-file.aspx
You need to able the Trace Flag which shows the public function names for
that Stack Trace using DBCC TRACEON(3656) with reference to this blog
Report the public symbol names for those frames back to us or
Microsoft CSS (Customer Support Services)