How can we help?
Blockings dashboard
The Blockings dashboard shows information about all blockings including monitor_loop_id and blocked processes report:
Corresponding view in the Performance Store database:
dbo.v_blockings
dbo.v_hist_blockings
Other relevant views in the Performance Store database:
dbo.v_deadlocks
dbo.v_current_activity (shows blocking chain and immediately identifies root blockers)