sqlserver查看和解除表死锁
时间：2021-07-01 10:21:17
帮助过：36人阅读
object_name(resource_associated_entity_id)
as tableName, request_session_id
as pid
from sys.dm_tran_locks
where resource_type
= ‘OBJECT‘
2，结束死锁的进程
kill 70
sqlserver查看和解除表死锁
标签：server iat nbsp table oci ted weight blog sel
