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);