SQL Server Management Studio Standard Reports - Overview

SQL Server Management Studio Standard Reports - Overview

Rate This
  • Comments 8

I mentioned in another post that we’ve been asked to bring back the “TaskPad” from SQL Server 7’s Enterprise Manager. As I described there, when we plumbed out that question a little further we found that what people really wanted back is the quick access to information about a selected object. And in some cases we were told that the graphics were useful.

So of course we took that and made more graphical and textual information. LOTS more. We made them into reports, which you could see off of the icon bar in SQL Server Management Studio, and then moved them onto the right-click menu of each item they applied to.

Still, a lot of people don’t know about these reports. I thought I would start a series of posts on these reports, and in this post I’ll explain what all the reports are. Before I do that, however, I should mention that in Service Pack 2 for SQL Server 2005 we introduced the ability to import your own reports. In fact, a few people have even re-created the TaskPad in one of these custom reports. I’ll talk about that later. And in a subsequent download we’ve made a complete set of performance tuning reports available for free. I’ll explain those later as well.

OK, let’s start off with the reports you have available in SSMS by right-clicking an object and selecting “Reports” and then “Standard Reports”:

On the Server Object:
Server Dashboard
Configuration Changes History
Schema Changes History
Scheduler Health
Memory Consumption
Activity – All Blocking Transactions
Activity – All Cursors
Activity – Top Cursors
Activity – All Sessions
Activity – Top Sessions
Activity – Dominant Sessions
Activity – Top Connections
Top Transactions by Age
Top Transactions by Blocked Transactions Count
Top Transactions by Locks Count
Performance – Batch Execution Statistics
Performance – Object Execution Statistics
Performance – Top Queries by Average CPU Time
Performance – Top Queries by Average IO
Performance – Top Queries by Total CPU Time
Performance – Top Queries by Total IO
Server Broker Statistics
Transaction Log Shipping Status
 
On the Database Object:
Disk Usage
Disk Usage by Top Tables
Disk Usage by Table
Disk Usage by Partition
Backup and Restore Events
All Transactions
All Blocking Transactions
Top Transactions by Age
Top Transactions by Blocked Transactions Count
Top Transactions by Locks Count
Resource Locking Statistics by Objects
Object Execution Statistics
Database Consistency History
Index Usage Statistics
Index Physical Statistics
Schema Changes History
User Statistics
 
On the Logins Object:
Login Statistics
Login Failures
Resource Locking Statistics by Logins
 
On the Management Object:
Tasks
Number of Errors
 
On the Notification Services Object:
General
 
On the SQL Server Agent Object:
Job Steps Execution History
Top Jobs

In the next few posts, I’ll examine each of these reports, and show you how you can use them to monitor and report on your systems.

Leave a Comment
  • Please add 7 and 6 and type the answer here:
  • Post
Page 1 of 1 (8 items)