【sqlserver-死锁】sqlserver 批量kill（查询|死锁）

--查看被锁表

SELECT

request_session_id spid, --锁表进程ID

OBJECT_NAME( resource_associated_entity_id ) tableName --锁表表名

FROM sys.dm_tran_locks

WHERE resource_type = 'OBJECT'

ORDER BY request_session_id ASC

--解锁

DECLARE @spid INT

SET @spid = 185--锁表进程ID

DECLARE @SQL VARCHAR (1000)

SET @SQL = 'kill ' + CAST (@spid AS VARCHAR) EXEC (@SQL)