sqlserver查看和解除表死锁

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