I am not a DBA, just a programmer, but I could follow most of this wonderful detective story. Some excellent sleuthing. This was a great read.

Please excuse my naïveté; I am new to SQL Server. Could you supply some details about what you use for the "active process report"?