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.
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 SQLdm, as well as the server health of SQLdm itself. The following main characteristics help define the SQLdm health model:
SQLdm Server
The health of SQLdm 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 SQLdm is rolled up by reflecting the Alerts counts opened for that instance within SQLdm.
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