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.
We are getting close to the final database level report – for SQL 2005, that is. In SQL Server 2008, we introduce some new performance reports that I will tell you about later. This report gives you some basic information about user activity in a single database. You can pair this up with the user reports at the server level to get a picture of a user’s workload.
This report has only one band:
|Login Name||The server login name of the principal|
|User Name||The database login name of the principal|
|# Active Sessions*||The number of active sessions this principal has across all databases|
|# Active Connections*||The number of active connections this principal has across all databases|
|# Active Requests||The number of active requests this principal has open|
|# Open Transactions||The number of open transactions this principal has active|
|# Active Cursors||The number of active cursors this principal has open|
|CPU Time (ms.)||The cumulative value of CPU time the principal has across all the active sessions|
|Memory Usage (KB)||The cumulative amount of memory the principal has across all the active sessions|
|# Reads||The cumulative number of Read operations the principal has taken across all the active sessions|
|# Writes||The cumulative number of write operations the principal has taken across all the active sessions|
|Last Request Start Time||The time the last operation was requested for this principal|
|Last Request End Time||The time the last operation for this principal completed|