sql 发生死锁

SELECT  request_session_id spid ,
        OBJECT_NAME(resource_associated_entity_id) tableName
FROM    sys.dm_tran_locks
WHERE   resource_type = 'OBJECT ';

KILL 70;
原文地址:https://www.cnblogs.com/myloveblogs/p/12050097.html