原文:
SQL Server 死锁检查
示例代码:
select spid, blocked, status, hostname, program_name, hostprocess, cmd
from sysprocesses
where dbid = db_id('xxx') and blocked > 0
-- kill spid_xxx