1.查询数据库中的死锁 SELECT request_session_id spid, ----------死锁进程ID object_name( resource_associated_entity_id ) tablename ----死锁进程名称 FROM sys.dm_tran_locks WHERE resource_type = 'object' 2.释放死锁 kill request_session_id request_session_id 是死锁ID 上图示例释放死锁如下: kill 1255