Where do I find the meaning of TdsInputBufferError numbers? We are having some sporadic connection errors on some of our SQL servers. I did some searching and found out about the Ring Buffer in SQL 2008 R2 and found some information, but I am not entirely sure how to figure it out.

Running the query

SELECT  CAST(record AS XML)
FROM    sys.dm_os_ring_buffers
WHERE   ring_buffer_type = 'RING_BUFFER_CONNECTIVITY'


Gives me some results, on of which is interesting

&lt;Record id="4" type="RING_BUFFER_CONNECTIVITY" time="461419385"&gt;
  &lt;ConnectivityTraceRecord&gt;
    &lt;RecordType&gt;LoginTimers&lt;/RecordType&gt;
    &lt;Spid&gt;0&lt;/Spid&gt;
    &lt;SniConnectionId&gt;40A403B2-B860-4877-A1D3-1FA7024356B7&lt;/SniConnectionId&gt;
    &lt;SniConsumerError&gt;17830&lt;/SniConsumerError&gt;
    &lt;SniProvider&gt;4&lt;/SniProvider&gt;
    &lt;State&gt;11&lt;/State&gt;
    &lt;RemoteHost&gt;&amp;lt;local machine&amp;gt;&lt;/RemoteHost&gt;
    &lt;RemotePort&gt;0&lt;/RemotePort&gt;
    &lt;LocalHost /&gt;
    &lt;LocalPort&gt;0&lt;/LocalPort&gt;
    &lt;RecordTime&gt;5/19/2012 16:29:23.831&lt;/RecordTime&gt;
    &lt;TdsBuffersInformation&gt;
      &lt;TdsInputBufferError&gt;109&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;18010&lt;/TotalLoginTimeInMilliseconds&gt;
      &lt;LoginTaskEnqueuedInMilliseconds&gt;0&lt;/LoginTaskEnqueuedInMilliseconds&gt;
      &lt;NetworkWritesInMilliseconds&gt;0&lt;/NetworkWritesInMilliseconds&gt;
      &lt;NetworkReadsInMilliseconds&gt;18010&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;/Stack&gt;
&lt;/Record&gt;


So, my question is, where do I find the meaning for the TDS error numbers. In this case &lt;TdsInputBufferError&gt;109&lt;/TdsInputBufferError&gt;
I'm not sure that this is an exhaustive list but both Error 109 and Error 10054 (from this similar question) are detailed in the SQL communication errors KB article.