• Although, using sys.dm_exec_requests won't show blocking if parallelism is involved.

    Another way to do it, and you can use almost the same query, is to look at sys.dm_os_waiting_tasks.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning