SQL SERVER 查找阻塞源
1、T-SQL
select * from master..sysprocesses where blocked = 0 and spid in ( select blocked from master..sysprocesses where blocked <> 0 )
2、圖形界面


“頭阻塞程序”為“1”的即為阻塞源
1、T-SQL
select * from master..sysprocesses where blocked = 0 and spid in ( select blocked from master..sysprocesses where blocked <> 0 )
2、圖形界面


“頭阻塞程序”為“1”的即為阻塞源