Appendix: Reports

  • Article

Applies To: Operations Manager 2007, Operations Manager 2007 R2, SQL Server

You can use the reports of the SQL Server Management Pack to track trends or changes across days, weeks, or months. The following tables describe the available SQL Server reports.

Capacity Information Reports

Report Class Description

SQL Broker Performance

Microsoft.SQLServer.2005.DBEngine

Microsoft.SQLServer.2008.DBEngine

Microsoft.SQLServer.2012.DBEngine

Displays a chart with the following performance items:

  • Activation stored procedures invoked per second statistics

  • Activation task limit reached

  • Activation task limit reached per second statistics

  • Activation tasks aborted

  • Messages per second placed in the queue

  • Transport messages per second placed in the queue

  • SQL RECEIVEs per second

  • SQL SENDs per second

  • Tasks started per second

  • Total transaction rollbacks

  • Transport message fragment RECEIVEs per second

  • Transport message fragments

  • Transport open connection count statistics

  • Transport receive I/Os per second

  • Transport Send I/Os per second

SQL Server Database Counters

Microsoft.SQLServer.2005.DBEngine

Microsoft.SQLServer.2008.DBEngine

Microsoft.SQLServer.2012.DBEngine

Displays a chart with the following performance items.

  • Buffer cache hit ratio

  • Lock timeouts per second

  • Number of deadlocks per second

  • SQL recompiles per second

  • Transactions per second

Operations Information Reports

Report Class Description

SQL Server Configuration

Microsoft.SQLServer.2005.DBEngine

Microsoft.SQLServer.2008.DBEngine

Microsoft.SQLServer.2012.DBEngine

When the objects supplied are of the type SQL DB Engine, displays the following discovered properties.

  • Audit level

  • Authentication mode

  • Cluster

  • Enable error reporting

  • Error log location

  • Language

  • Master database location

  • Master database log location

  • Service pack version

  • Replication distribution database

  • Replication working directory

  • Version

SQL Server Lock Analysis

Microsoft.SQLServer.2005.DBEngine

Microsoft.SQLServer.2008.DBEngine

Microsoft.SQLServer.2012.DBEngine

When the objects supplied are of the type SQL DB Engine, displays a chart with the performance item, Number of deadlocks per second.

SQL Server Servicepack

Microsoft.SQLServer.2005.DBEngine

Microsoft.SQLServer.2008.DBEngine

Microsoft.SQLServer.2012.DBEngine

When the objects supplied are of type SQL DB Engine or ServicePackVersion, displays the following discovered properties:

  • Service Pack Version

  • Version

SQL User Activity

Microsoft.SQLServer.2005.DBEngine

Microsoft.SQLServer.2008.DBEngine

Microsoft.SQLServer.2012.DBEngine

For each selected object, displays a chart with the performance item, Logins per second. Data is aggregated to days of a month.

Top 5 Deadlocked Databases

Microsoft.SQLServer.2005.DBEngine

Microsoft.SQLServer.2008.DBEngine

Microsoft.SQLServer.2012.DBEngine

Displays a chart with the top five deadlocked databases and a table detailing the databases and their counter values.

User Connections by Day

Microsoft.SQLServer.2005.DBEngine

Microsoft.SQLServer.2008.DBEngine

Microsoft.SQLServer.2012.DBEngine

When the objects supplied are of type SQL DB Engine, displays a chart for each selected object with the performance item, SQL user connections.

User Connections by Peak Hours

Microsoft.SQLServer.2005.DBEngine

Microsoft.SQLServer.2008.DBEngine

Microsoft.SQLServer.2012.DBEngine

When the objects supplied are of the type SQL DB Engine, displays a chart for each selected object with the performance item, SQL user connections. Data is aggregated to days of a month.

Trend Information Reports

Report Class Description

SQL Database Space Report

Microsoft.SQLServer.2005.DBEngine

Microsoft.SQLServer.2008.DBEngine

Microsoft.SQLServer.2012.DBEngine

When the objects supplied are of the type SQL Database or a type derived from SQL Database, displays a chart for each selected object with the following performance items:

  • Database free space in MB

  • Database free space in percentage

  • Database space in MB

  • Transaction log free space in MB

  • Transaction log free space in percentage

  • Transaction log space in MB

Data is aggregated to days of a month.