SELECT XEvent.query('data[@name="xml_report"]/value/deadlock') AS deadlock_graph FROM (SELECT CAST([target_data] AS XML) AS TargetData FROM sys.dm_xe_session_targets AS st INNER JOIN sys.dm_xe_sessions AS s ON [s].[address] = [st].[event_session_address] WHERE [s].[name] = N'system_health' AND [st].[target_name] = N'ring_buffer') AS Data CROSS APPLY TargetData.nodes ('RingBufferTarget/event[@name="xml_deadlock_report"]') AS XEventData (XEvent);
Thứ Hai, 10 tháng 9, 2018
[SQL] Get Deadlock Graph from Extended Events
Đăng ký:
Đăng Nhận xét
(
Atom
)
Không có nhận xét nào :
Đăng nhận xét