LinkedIn | FaceBook | Twitter
I'm continuing my series on the Standard Reports in SQL Server Management Studio, and today we’re in the database reports. You can find these reports by starting SQL Server Management Studio and right-clicking a database name. From the menu that appears, click the “Standard Reports”, and then select the title at the top of this post.
This report is very similar to the Transaction reports I’ve covered in the other posts in this series. Because this is a database-level report, it only focuses on one database at a time, and it gives you more lock information than the server-level reports.
The first band shows the some general statistics about the “Wait” status of the system. Waits are just that; the time taken by the system waiting on something else. Normally these require investigation:
The second band grouping has breakdowns from the State of the transactions, then on to the sessions, then the individual transactions, the resource type and down to the lock type:
PingBack from http://geeklectures.info/2007/12/27/sql-server-management-studio-standard-reports-%e2%80%93-all-transactions-databasename/
I'm continuing my series on the Standard Reports in SQL Server Management Studio , and today we’re