如何排查数据库死锁问题

[问题描述]

如何排查数据库死锁问题?
哪个进程、具体到哪个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