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”的即为阻塞源