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