• And remember to include host, IP, process id, login, and SQL text of BOTH the blocker and the blocked.

    make sure you store the wait time in ms so you can determine the top of the block chain (if one is occurring).

    Report should be sorted by wait time desc.