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

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

Rate This
  • Comments 3
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

Leave a Comment
  • Please add 6 and 7 and type the answer here:
  • Post