Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

FROM    sys.dm_os_ring_buffers

Gives me some results, on of which is interesting

<Record id="4" type="RING_BUFFER_CONNECTIVITY" time="461419385">
    <RemoteHost>&lt;local machine&gt;</RemoteHost>
    <LocalHost />
    <RecordTime>5/19/2012 16:29:23.831</RecordTime>

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

share|improve this question
@MartinSmith. Yup, that appears to be what I was looking for. Type it up as an answer and I can mark it as the answer. – Jim May 21 '12 at 15:46
up vote 5 down vote accepted

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.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.