SQL Server查看死锁语句

--SQL Server 2008
SELECT
XEventData.XEvent.value('@timestamp', 'datetime2(3)'),
cast(XEventData.XEvent.value('(data/value)[1]',
'varchar(max)') AS XML) AS DeadlockGraph
FROM
(SELECT
CAST (target_data AS XML) AS TargetData
FROM
sys.dm_xe_session_targets st
JOIN sys.dm_xe_sessions s ON s.address = st.event_session_address
WHERE [name] = 'system_health' AND st.target_name = 'ring_buffer') AS Data
CROSS APPLY TargetData.nodes ('//RingBufferTarget/event') AS XEventData (XEvent)
WHERE XEventData.XEvent.value('@name', 'varchar(4000)') = 'xml_deadlock_report'
OPTION(maxdop 1,RECOMPILE);