SQL Server Management Studio Standard Reports – Overview

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:
Number of Errors
On the Notification Services Object:
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.

Comments (8)

  1. You’ve been kicked (a good thing) – Trackback from DotNetKicks.com

  2. Carpe Datum says:

    @font-face { font-family: Cambria Math; } @font-face { font-family: Calibri; } @page Section1 {size:

  3. ghj1976 says:

    之前的两篇博客中有2个例子,来演示要讲述的内容。其中提到了部分查看数据库状态的方法,那里并不是很全面,这篇博客罗列几个我们在后面系列博客中会用到查看这些状态,数据的地方。以及测试中清除缓存的方法。前面两篇博客的链接地址如下: SQL Server 索引基础知识(1)— 记录数据的基本格式 http://blog.joycode.com/ghj/archive/2008/01/02/113290.aspx SQL Server 索引基础知识(2)—-聚集索引,非聚集索引 http://blog.joycode.com/ghj/archive/2008/01/02/113291.aspx..

  4. HappyQQ says:


  5. 之前的两篇博客中有2个例子,来演示要讲述的内容。其中提到了部分查看数据库状态的方法,那里并不是很全面,这篇博客罗列几个我们在后面系列博客中会用到查看这些状态,数据的地方。以及测试中清除缓存的方法。 前面两篇博客的链接地址如下

  6. Chris says:

    What do you do if the database reports option is greyed out? Permissions issue?

Skip to main content