SQL Server查询死锁，杀死进程解决死锁

时间：2019-06-04 14:31:08 收藏：0 阅读：692

查询死锁进程和表

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://www.cnblogs.com/weifeng123/p/10973331.html