The IDERA SQLDM Management Pack (SQLDM MP) integrates and extends the Microsoft System Center Operations Manager (SCOM) monitoring capabilities by providing database administrators and IT operators with additional insight into the availability and performance of their SQL Server interfaces, all from one console.

SQLDM MP includes automatic discovery of SQLDM installations and of the SQL Server instances managed from those installations. Once discovered, SQLDM MP propagates the current status, health, and events of monitored instances up to SCOM.

SQLDM uses Alert Actions and Responses to control which alerts are escalated to SCOM and whether they go into SCOM as an Event or an Alert. For additional information, go to SCOM Event Action or SCOM Alert Action.

For additional information about SQLDM Management Pack, click Product Documentation, select the SQL Diagnostic Manager version you need, and click View. A dialog box opens with documentation options for SQL Diagnostic Manager plug-ins, click System Center Management Pack option, and download the SQLDM MP file.

Note that the IDERA SQLDM Management Pack for integration with SCOM is designed for System Center Operations Manager 2007 R2 and above.

Understanding the SQLDM Management Pack health model

The SQLDM Management Pack reports the health of each SQL Server instance monitored by SQL Diagnostic Manager, as well as the server health of SQL Diagnostic Manager itself. The following main characteristics help define the SQL Diagnostic Manager health model:

SQLDM Server

The health of SQL Diagnostic Manager is tracked by monitoring the state of three underlying services, using the following three service monitors:

  • Collection Service Monitor
  • Management Service Monitor
  • Predictive Service Monitor

The automatically discovered Object ID for the SQLDM Service is Idera.SQLDM.Service.

SQLDM Instance

The health of each SQL server instance being monitored by SQL Diagnostic Manager is rolled up by reflecting the Alerts counts opened for that instance within SQL Diagnostic Manager.

If a SQL server instance currently has one or more Critical alerts open, then the Health of that instance is recorded as Critical. If one or more Warning alerts are open, but no Critical alerts show, then the health of the instance is recorded as Warning.

In Health Explorer the Diagnostic Manager Alert status which drove a specific Health state change is recorded and displayed in the State Change Events tab.

The automatically discovered Object ID for a SQL Instance is Idera.SQLDM.SqlInstance.

SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >