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,019 reads

Blogs

Reading tutorials is fine. Shipping something is better. If you are trying to break...

We work hard at Redgate, though with a good work-life balance. One interesting observation...

Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...

Forums

Comments posted to this topic are about the item Pro SQL Server Internals

Comments posted to this topic are about the item SQL ART: Who's Blocking Who?...

Comments posted to this topic are about the item Running SQLCMD II

I run this command to start SQLCMD:

sqlcmd -S localhost -E -c "proceed"

At the prompt, I type this (the 1> and 2> are prompts):

1> select @@version
2> go

What happens?