Press "Enter" to skip to content

Identifying a Blocking Chain with WhoIsActive

Ajay Dwivedi walks us through one of the many useful features of sp_whoisactive:

The main benefit of above query is that it uses world famous procedure sp_WhoIsActive to collect blocking metrics with full customization of sp_WhoIsActive.

Click through for the query. I really like the blocking way Ajay displays the blocking tree, especially on busy servers.