Viewing Information in the Operations Manager Console

Article
10/01/2013

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

You can see a high-level view of object types in your SQL Server deployment.

A view can contain a lengthy list of objects. To find a specific object or group of objects, you can use the Scope, Search, and Find buttons on the Operations Manager toolbar. For more information, see the How to Manage Monitoring Data Using Scope, Search, and Find topic in Operations Manager Help.

These views are listed directly under the Microsoft SQL Server node in the Monitoring pane of the Operations Console. Details for most views are listed in the following table.

Active Alerts, which displays an aggregation of all alerts that are not closed.
Computers, which displays a state view of all the computers running SQL Server.
Task Status, which displays a status view of all available tasks.
Databases
Health Monitoring
Performance
Replication
Server Roles
SQL 2005
SQL 2008
SQL 2008 R2
SQL 2012
SQL Agent

Databases Views

View Name	Description
Database Free Space	The Legend pane displays a list of counters for every monitored database. A chart illustrates the information in the Legend pane.
Database State	Displays a list of monitored databases and their current states. The Detail View pane displays the properties of the database selected above.
Transaction Log Free Space	The Legend pane displays a list of Transaction Log files.
SQL Server 2012 Databases Summary Dashboard	Displays list of SQL Server 2012 databases and their state. Provides detailed information about selected database. Use Databases widget to select a database. DB Alerts widget displays alerts and warnings that target the database. Free Space widget displays three series of data that represent Used, Allocated and Disk Free space, if auto grow is disabled only two series of data will be displayed (Used and Allocated). The widget has 2 scale types: Linear and Logarithmic. Hover over Y-Axis to switch between them. Red and Yellow lines represent Upper and Lower thresholds that are set for DB Total Space monitor. Performance section contains eight performance collection rules, four of them can be linked with monitors. If linked monitors are disabled widgets display performance collection data without heath state indication. Since there are no monitors for DB Active Sessions, DB Active Requests, DB Active Connections and DB Transactions/sec they do not have health state indication. Next monitors are linked with top four performance widgets: Transaction Log Free Space (%), DB Total Space, Disk Read Latency and Disk Write Latency monitors. Personalization option allows selecting Time Range for Free Space and Performance widgets by default the value is set to 2 days.

Health Monitoring Views

View Name	Description
Agent Health	This is a dashboard view that displays the health of SQL Agents and, for each agent, the alerts that have not been closed. If you have discovered agent jobs, they are also included in this view. The Detail View pane provides the properties of the agent selected in the SQL Agent State pane.
Database Engine Health	This is a dashboard view that displays the health of each database engine instance, including a list of the alerts that have not been closed for that database engine instance and for any objects that instance contains. The Detail View pane displays the properties of the selected database engine instance.

Agent Health

This is a dashboard view that displays the health of SQL Agents and, for each agent, the alerts that have not been closed.

If you have discovered agent jobs, they are also included in this view.

The Detail View pane provides the properties of the agent selected in the SQL Agent State pane.

Database Engine Health

This is a dashboard view that displays the health of each database engine instance, including a list of the alerts that have not been closed for that database engine instance and for any objects that instance contains.

The Detail View pane displays the properties of the selected database engine instance.

Performance Views

View Name	Description
All Performance Data	The Legend pane contains a list of objects for which data is collected.
Database Free Space	The Legend pane displays a list of databases.
User Connections	The Legend pane displays a list of objects governed by the SQL User Connections rule.
Transaction Log Free Space	The Legend pane displays a list of Transaction Log files.

Replication Views

View Name	Description
Distributor State	Displays the state of the replication distributor.
Publication State	Displays the state of the replication publication.
Publisher State	Displays the state of the replication publisher.
Subscription State	Displays the state of the replication subscription.

Server Roles Views

View Name	Description
Analysis Services	Displays a list of instances with SQL Server Analysis Services installed.
Database Engines	Displays a list of instances with SQL Server Database Engine installed.
Integration Services	Displays a list of instances with SQL Server Integration Services installed.
Reporting Services	Displays a list of instances with SQL Server Reporting Services installed.

SQL Server Agent Views

View Name	Description
SQL Agent Job State	The SQL Server Agent Job State pane displays a list of agent jobs. The Detail View pane contains the properties of the SQL Server Agent Job.
SQL State	Displays a list of SQL Server Agents. If agent jobs have been discovered, it also contains columns for each agent job and their respective health states. The Detail View displays the properties of the SQL Server Agent.

SQL Agent Job State

The SQL Server Agent Job State pane displays a list of agent jobs.

The Detail View pane contains the properties of the SQL Server Agent Job.

SQL State

Displays a list of SQL Server Agents. If agent jobs have been discovered, it also contains columns for each agent job and their respective health states.

The Detail View displays the properties of the SQL Server Agent.

Share via