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: msdb.sys.dm_exec_sql_text
Identify Lead Blocker Script
Posted by JackDonnell
on January 9, 2016
Comments Off on Identify Lead Blocker Script