一、Sqlserver 死锁查询以及解锁方法 (1)下面是查询死锁进程 select request_session_id spid, (死锁进程id) OBJECT_NAME(resource_associated_entity_id) tableName (死锁进程名称) from sys.dm_tran_locks where resource_type='OBJECT' (数据类型所有) (2)杀死死锁进程 declare @spid int //声明id Set @spid = 62