Script to log top blocker processes in a database. Top blocker is defined as the process that is at the top of a blocking chain.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(4)

You rated this post out of 5. Change rating

2012-07-12 (first published: 2007-10-30)

3,015 reads

Blogs

"Dave: Open the pod bay doors, HAL.HAL: I’m sorry, Dave. I’m afraid I can’t...

Redgate acquired a data modeling tool from Vertabelo recently and I wanted to explore...

The advantage of understanding the make-up of the exam: I can tailor my efforts...

Forums

Comments posted to this topic are about the item SQL Server 2025 Build List

Comments posted to this topic are about the item Filtered Indexes: The Developer’s Secret...

Comments posted to this topic are about the item Is Data Modeling Common?

I run this code to connect to SQL Server 2022 from the command line.

sqlcmd -S localhost -E

At the command line, I run these two commands:

SELECT ORIGINAL_DB_NAME()
GO

What is returned?