SQL Server Management Studio Standard Reports –User Statistics: [DatabaseName]

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:

Column	Description
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