Here is a more updated query for the first one listed in this article
select er.session_id, blocking_session_id, wait_type
, wait_time, last_wait_type, database_id
, user_id, er.cpu_time, er.reads + er.writes AS Physical_IO, granted_query_memory
, es.login_time, es.last_request_start_time, es.host_name
, program_name, nt_domain, nt_user_name, login_name
from sys.dm_exec_requests ER
INNER JOIN sys.dm_exec_sessions ES
ON ER.session_id = ES.session_id
where blocking_session_id <> 0
or ER.session_id in (select blocking_session_id from sys.dm_exec_requests)
Thanks for the article.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events