SQL Server 死锁检查

示例代码

select spid, blocked, status, hostname, program_name, hostprocess, cmd 
from sysprocesses
where dbid = db_id('xxx') and blocked > 0 

-- kill spid_xxx

活动和监视器