Sql-Server-2008-R2

我在哪裡可以找到 TdsInputBufferError 數字的含義?

  • June 15, 2021

我們的一些 SQL 伺服器上出現了一些零星的連接錯誤。我做了一些搜尋,發現了 SQL 2008 R2 中的 Ring Buffer 並找到了一些資訊,但我不完全確定如何弄清楚。

執行查詢

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

給我一些結果,其中很有趣

<Record id="4" type="RING_BUFFER_CONNECTIVITY" time="461419385">
 <ConnectivityTraceRecord>
   <RecordType>LoginTimers</RecordType>
   <Spid>0</Spid>
   <SniConnectionId>40A403B2-B860-4877-A1D3-1FA7024356B7</SniConnectionId>
   <SniConsumerError>17830</SniConsumerError>
   <SniProvider>4</SniProvider>
   <State>11</State>
   <RemoteHost><local machine></RemoteHost>
   <RemotePort>0</RemotePort>
   <LocalHost />
   <LocalPort>0</LocalPort>
   <RecordTime>5/19/2012 16:29:23.831</RecordTime>
   <TdsBuffersInformation>
     <TdsInputBufferError>109</TdsInputBufferError>
     <TdsOutputBufferError>0</TdsOutputBufferError>
     <TdsInputBufferBytes>0</TdsInputBufferBytes>
   </TdsBuffersInformation>
   <LoginTimers>
     <TotalLoginTimeInMilliseconds>18010</TotalLoginTimeInMilliseconds>
     <LoginTaskEnqueuedInMilliseconds>0</LoginTaskEnqueuedInMilliseconds>
     <NetworkWritesInMilliseconds>0</NetworkWritesInMilliseconds>
     <NetworkReadsInMilliseconds>18010</NetworkReadsInMilliseconds>
     <SslProcessingInMilliseconds>0</SslProcessingInMilliseconds>
     <SspiProcessingInMilliseconds>0</SspiProcessingInMilliseconds>
     <LoginTriggerAndResourceGovernorProcessingInMilliseconds>0</LoginTriggerAndResourceGovernorProcessingInMilliseconds>
   </LoginTimers>
 </ConnectivityTraceRecord>
 <Stack>...</Stack>
</Record>

所以,我的問題是,我在哪裡可以找到 TDS 錯誤編號的含義。在這種情況下<TdsInputBufferError>109</TdsInputBufferError>

我不確定這是一個詳盡的列表,但錯誤 109 和錯誤 10054(來自這個類似的問題)在數據庫引擎錯誤舊連結:SQL 通信錯誤)一文中有詳細說明。

引用自:https://dba.stackexchange.com/questions/18200