数据库死锁问题

查询死锁进程和表

SELECT request_session_id AS spid ,
OBJECT_NAME(resource_associated_entity_id) AS 'table'
FROM sys.dm_tran_locks
WHERE resource_type = 'OBJECT';
杀死进程

KILL [spid];
---------------------
原文链接：https://blog.csdn.net/mc_linfen/article/details/82115368