patternMinor
Where do I find the meaning of TdsInputBufferError numbers?
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
Gives me some results, on of which is interesting
So, my question is, where do I find the meaning for the TDS error numbers. In this case
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
109Solution
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.