Blocking is a popular topic in SQL Server. Users are often trying to work out what's blocking what. In our free SDU Tools for developers and DBAs, we have a tool to make that very easy to see. It's called ShowCurrentBlocking.
ShowCurrentBlocking takes one following parameter:
@DatabaseName (sysname) is the database to report on
It returns two sets of data.
The first rowset is a list of all objects that are currently blocked, and the last query that was run on the connection for each of those objects.
The second rowset is a list of all sessions that are currently blocked, and which of the processes in the list above is causing that.
You can see this procedure in action in the main image above, and in this video:
To become an SDU Insider and to get our free tools and eBooks, please just visit here: