LinkedIn | FaceBook | Twitter
This report shows information similar to the Locking and Blocking reports I’ve covered in the other posts in this series, but since this is a database-level report, it only focuses on one database at a time, and it gives you more lock information than some of the server-level reports.
The first band groups the blocking information by the Transaction ID, which is a unique number assigned to each unit of work the server is doing. You can use this number to locate lots of other information in many of the Dynamic Management Views or other Meta-Data views:
The second band starts a grouping for the Resource Name. This name shows the table or other database object that is involved in the transaction.
Below each resource being locked, you’ll see the following columns:
The last band shows the partial contents of the Currently Executing SQL Statement.