This script logs top blocker processes. Top blocker is defined as the process that is at the top of a blocking chain. This is useful in identifying locking/blocking problems as it will help identify the most frequent SQL statements (inline SQL and Stored procs) which block other processes.
This script is a combination of a few other scripts found in this script library with a few modifications.
1. Run TopBlocker table into database
2. Run sp_who4.sql into database
3. Set up SQL job to execute sp_who4 procedure
A. Step 1 = exec sp_who4