sql query to get deadlocks in sql server 2016 code example
Example 1: t sql check active deadlock
select * from sys.sysprocesses where blocked > 0
Example 2: mssql find deadlocks
--[status]
EXEC sp_whoisActive;
select * from sys.sysprocesses where blocked > 0
--[status]
EXEC sp_whoisActive;