22,209
社区成员
发帖
与我相关
我的任务
分享
--检索死锁进程
select spid, blocked, loginame, last_batch, status, cmd, hostname, program_name
from sys.sysprocesses
where spid in
( select blocked from sys.sysprocesses where blocked <> 0 ) or (blocked <>0)
--为了防止死锁,在可接受范围内,试试with (nolock)选项
select * from dbo.t with (nolock)