sql server 查询死锁

select request_session_id spid,OBJECT_NAME(resource_associated_entity_id) tableName
from sys.dm_tran_locks where resource_type='OBJECT'

kill 121 --杀死进程id

 

posted @ 2023-07-27 12:32  曲琦  阅读(134)  评论(0编辑  收藏  举报