Hi Paul,

Nice article, but we may miss few of the session ids by using "sys.dm_exec_request" like below

Select Session_ID,Blocking_Session_ID

From Sys.DM_Exec_Requests

Where Session_ID > 50

And Blocking_Session_Id <> 0

Better to use...