论坛 › SQL Server › 如何查看Sql Server 死锁报告？

lixiaolong 发表于 2017-12-14 15:10:32

如何查看Sql Server 死锁报告？

通过动态视图的扩展事件来查看　　SELECT
　　
xed.value('@timestamp', 'datetime') as Creation_Date,
　　
xed.query('.') AS Extend_Event
　　
FROM
　　
(
　　
SELECT CAST( AS XML) AS Target_Data
　　
FROMsys.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_Data
　　
CROSS APPLY Target_Data.nodes('RingBufferTarget/event[@name="xml_deadlock_report"]') AS XEventData(xed)
　　
ORDER BY Creation_Date DESC

查看完整版本: 如何查看Sql Server 死锁报告？