SQLServer数据库死锁问题

 

--查询死锁表
select 
    request_session_id spid,   
    OBJECT_NAME(resource_associated_entity_id) tableName    
from 
    sys.dm_tran_locks   
where 
    resource_type='OBJECT'


--删除死锁
declare @spid int
Set @spid = 54 --锁表进程
declare @sql varchar(1000)
set @sql='kill '+cast(@spid as varchar)
exec(@sql)

 

参阅：https://www.cnblogs.com/LearningFromyou/p/17144303.html