HiveBrain v1.2.0
Get Started
← Back to all entries
patternMinor

Where do I find the meaning of TdsInputBufferError numbers?

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
meaningthewherenumberstdsinputbuffererrorfind

Problem

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


  
    LoginTimers
    0
    40A403B2-B860-4877-A1D3-1FA7024356B7
    17830
    4
    11
    <local machine>
    0
    
    0
    5/19/2012 16:29:23.831
    
      109
      0
      0
    
    
      18010
      0
      0
      18010
      0
      0
      0
    
  
  ...


So, my question is, where do I find the meaning for the TDS error numbers. In this case 109

Solution

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 Database engine errors (old link: SQL communication errors) article.

Context

StackExchange Database Administrators Q#18200, answer score: 8

Revisions (0)

No revisions yet.