[问题描述]

如何排查数据库死锁问题?
哪个进程、具体到哪个SQL,导致了当前进程发生了死锁昵?

[操作步骤]

在数据库中执行下列SQL,即可轻松获取相关死锁信息:

SELECT XEvent.query('(event/data/value/deadlock)[1]') AS DeadlockGraph

FROM (

SELECT XEvent.query('.') AS XEvent

FROM (

SELECT CAST(target_data AS XML) AS TargetData

FROM sys.dm_xe_session_targets st

INNER JOIN sys.dm_xe_sessions s ON s.address = st.event_session_address

WHERE s.NAME = 'system_health'

AND st.target_name = 'ring_buffer'

) AS Data

CROSS APPLY TargetData.nodes('RingBufferTarget/event[@name=xml_deadlock_report]') AS XEventData(XEvent)

) AS source;

[说明]

详见https://vip.kingdee.com/questions/14464/answers/19822