Many third-party tools have pretty lead blocking graphs and etc. You may not have access to something than grand. My friend and co-work JD Pellerin wrote this script. He used this as a basis for an SSRS report that can be executed by operations teams to identify potential batch issues. Play around with tweak it to fit your needs.
Tag Archives: WAITFOR DELAY
Identify Lead Blocker Script
Posted by JackDonnell
on January 9, 2016
Comments Off on Identify Lead Blocker Script