Sql Server查询死锁

sql server 中有时因为异常操作锁表导致的CURD异常，可用此sql进行查询，并复制kill xxx;到查询窗口中杀死远端进程。

select 'kill '+ cast(request_session_id  as varchar)+';',OBJECT_NAME(resource_associated_entity_id) tableName,*
from sys.dm_tran_locks
where resource_type='OBJECT'
and OBJECT_NAME(resource_associated_entity_id)  is not null