查询阻塞的过程

--查询阻塞的存储过程和表以及SQL等 
SELECT 'kill '+CAST(a.blocking_session_id AS NVARCHAR(50)), a.wait_duration_ms, a.session_id,b.text
FROM sys.dm_os_waiting_tasks a,
(SELECT t.text ,c.session_id
FROM sys.dm_exec_connections c 
CROSS APPLY sys.dm_exec_sql_text (c.most_recent_sql_handle) t) b 
WHERE  a.session_id = b.session_id and a.blocking_session_id IS NOT NULL
GROUP BY 'kill '+CAST(a.blocking_session_id AS NVARCHAR(50)), a.wait_duration_ms, a.session_id,b.text
ORDER BY  b.text