SQLServer 死锁排查

适用于2012及以上版本

一、创建扩展事件会话

CREATE EVENT SESSION [Deadlock_Monitor] 
ON SERVER 
ADD EVENT sqlserver.xml_deadlock_report
ADD TARGET package0.event_file(SET filename=N'Deadlock_Monitor.xel')
WITH (STARTUP_STATE=ON);
GO
ALTER EVENT SESSION [Deadlock_Monitor] ON SERVER STATE = START;

当有死锁发生时在SSMS查看