SqlServer 查询死锁,杀死死锁进程
数据库
19-1-16 11:24:45
select
request_session_id spid,
OBJECT_NAME(resource_associated_entity_id) tableName
from
sys.dm_tran_locks
where
resource_type='OBJECT'
kill 66
kill 61
kill 94
kill 58