GitHub

sql_tools/find_head_of_blocking_chain

WHERE (head.blocking_session_id IS NULL OR head.blocking_session_id = 0) AND head.session_id IN (SELECT DISTINCT blocking_session_id FROM blocking_sessions WHERE blocking_session_id != 0) SELECT ...
LinkedIn

SQL Server Blocking Troubleshooting Simplified with Script

Your SQL maintenance jobs are rebuilding indexes for the wrong reason. Most DBAs still drive decisions off one number: fragmentation percent. Pages out of order. Threshold crossed. Rebuild. That's ...
LinkedIn

SQL Server Locking and Blocking Analysis with AI SQL Tuner Studio

SQL Server Locking and Blocking Analysis with AI SQL Tuner Studio 1.0.37 TL;DR. AI SQL Tuner Studio 1.0.37 adds a new Locking and Blocking Analysis goal that pinpoints the root cause of SQL Server ...
GitHub

DBA SGA Blocking Session Summary.sql

-- Description: Summary of blocked and blocking sessions based on the active session history from the SGA. The link to blocking sessions is deliberately nonunique without jointing to sample_id to ...
Ars Technica

SQL 2008 Blocking process

I am having an issue with my SQL system maintenance job which is failing. This job takes care of all the system databases and has been running fine for a long time. I did some troubleshooting and ...