• 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