笔记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>
