sqlserver 批量kill死锁 

select 'kill '+CONVERT(varchar,request_session_id) ,OBJECT_NAME(resource_associated_entity_id) tableName from sys.dm_tran_locks
where
   resource_type='OBJECT'
posted @ 2020-11-24 16:49  Observer_Dep  阅读(921)  评论(0)  编辑  收藏  举报