通过动态视图的扩展事件来查看

SELECT       xed.value(‘@timestamp‘, ‘datetime‘) as Creation_Date,       xed.query(‘.‘) AS Extend_EventFROM(       SELECT CAST([target_data] AS XML) AS Target_Data       FROM sys.dm_xe_session_targets AS xt       INNER JOIN sys.dm_xe_sessions AS xs       ON xs.address = xt.event_session_address       WHERE xs.name = N‘system_health‘       AND xt.target_name = N‘ring_buffer‘) AS XML_DataCROSS APPLY Target_Data.nodes(‘RingBufferTarget/event[@name="xml_deadlock_report"]‘) AS XEventData(xed)ORDER BY Creation_Date DESC

如何查看Sql Server 死锁报告？