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.
In the top area of the report you’re shown a small graph that displays the number of locks against the number of transactions that are waiting. You can use this information to correlate the blocking chains, and trace back what the transactions are waiting on. In this way you can re-code your applications to ensure that an update doesn’t block a read and so on.
The first band in the report groups the blocking information by the Object Number, which is a unique number within this report:
The second band starts a grouping for the Lock type. Lock types indicate the level the database is locking, such as TABLE, OBJECT and so on. You can read more about those lock types here. Just next to the type of lock is the # Locks (Granted). This number shows how many locks (of this type) are currently being used by this Object.
Below each Lock Type, you’ll see the following columns:
I'm continuing my series on the Standard Reports in SQL Server Management Studio , and today we’re