sp_BlitzLock Archives - Brent Ozar Unlimited®

How to Troubleshoot Blocking and Deadlocking with Scripts and Tools

Last Updated November 28, 2018

When you need to find which queries are blocking other queries, your decision comes down to when the blocking happened. Is it happening now, recently, or coming up soon? During a live emergency, start with sp_WhoIsActive. Adam Machanic’s excellent free sp_WhoIsActive replaces Activity Monitor, sp_who, and sp_who2, and it’s way more powerful. The documentation is extensive –…

Introducing sp_BlitzLock: For Troubleshooting SQL Server Deadlocks

Last Updated September 26, 2023

Erik Darling

Deadlocks, First Responder Kit, sp_BlitzLock

Deadlocks are hard – especially when there are a lot of them. When there are dozens or more, looking at each graph is a pain. sp_BlitzLock gives you a slice-and-dice analysis of which tables, indexes, and queries are involved in most of your deadlocks so you can quickly get to the root cause. sp_BlitzLock works…