死锁检测

--死锁检测
use master
Select * from sysprocesses where blocked<>0
--找到SPID
exec sp_lock
--根据SPID找到OBJID
select object_name(85575343)
--根据OBJID找到表名

select request_session_id spid,OBJECT_NAME(resource_associated_entity_id) tableName ,*
from sys.dm_tran_locks where resource_type='OBJECT'