笔记321 利用Ring Buffer在SQL Server 2008中进行连接故障排除 2013-7-13

 1 --利用Ring Buffer在SQL Server 2008中进行连接故障排除 2013-7-13
 2 SELECT CAST(record AS XML) FROM sys.dm_os_ring_buffers
 3 WHERE ring_buffer_type = 'RING_BUFFER_CONNECTIVITY'
 4 
 5 ------------------------------------------------------------------
 6 <Record id="0" type="RING_BUFFER_CONNECTIVITY" time="98492">
 7   <ConnectivityTraceRecord>
 8     <RecordType>Error</RecordType>
 9     <RecordSource>Tds</RecordSource>
10     <Spid>51</Spid>
11     <SniConnectionId>646DCD93-DAD4-43D1-BBB3-DD3E90B9A83C</SniConnectionId>
12     <ClientConnectionId>00000000-0000-0000-0000-000000000000</ClientConnectionId>
13     <OSError>0</OSError>
14     <SniConsumerError>18456</SniConsumerError>
15     <SniProvider>7</SniProvider>
16     <State>38</State>
17     <RemoteHost>fe80::6c44:a392:940c:a82b%11</RemoteHost>
18     <RemotePort>49167</RemotePort>
19     <LocalHost>fe80::6c44:a392:940c:a82b%11</LocalHost>
20     <LocalPort>1433</LocalPort>
21     <RecordTime>7/13/2013 14:48:47.815</RecordTime>
22     <TdsBuffersInformation>
23       <TdsInputBufferError>0</TdsInputBufferError>
24       <TdsOutputBufferError>0</TdsOutputBufferError>
25       <TdsInputBufferBytes>378</TdsInputBufferBytes>
26     </TdsBuffersInformation>
27     <TdsDisconnectFlags>
28       <PhysicalConnectionIsKilled>0</PhysicalConnectionIsKilled>
29       <DisconnectDueToReadError>0</DisconnectDueToReadError>
30       <NetworkErrorFoundInInputStream>0</NetworkErrorFoundInInputStream>
31       <ErrorFoundBeforeLogin>0</ErrorFoundBeforeLogin>
32       <SessionIsKilled>0</SessionIsKilled>
33       <RoutingCompleted>0</RoutingCompleted>
34       <NormalDisconnect>0</NormalDisconnect>
35     </TdsDisconnectFlags>
36   </ConnectivityTraceRecord>
37   <Stack>
38     <frame id="0">0X000007FEF0C4033F</frame>
39     <frame id="1">0X000007FEF0BE3E05</frame>
40     <frame id="2">0X000007FEF040D03B</frame>
41     <frame id="3">0X000007FEF01E1F9D</frame>
42     <frame id="4">0X000007FEF025F9B3</frame>
43     <frame id="5">0X000007FEF0260FAD</frame>
44     <frame id="6">0X000007FEF0260CF1</frame>
45     <frame id="7">0X000007FEF01E98AB</frame>
46     <frame id="8">0X000007FEF1F73BF0</frame>
47     <frame id="9">0X000007FEF1F74094</frame>
48     <frame id="10">0X000007FEF1F73E97</frame>
49     <frame id="11">0X000007FEF1F9BA8F</frame>
50     <frame id="12">0X000007FEF1F9C240</frame>
51     <frame id="13">0X000007FEF1F9B3AD</frame>
52     <frame id="14">0X000007FEF1F9B878</frame>
53     <frame id="15">0X00000000775F652D</frame>
54   </Stack>
55 </Record>