Page History

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 an 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.

...

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 a 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.

...