Sql-Server-2008-R2
我在哪裡可以找到 TdsInputBufferError 數字的含義?
我們的一些 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 通信錯誤)一文中有詳細說明。