Page History
The Idera SQLdm IDERA SQLDM Management Pack (SQLdm 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 SQLDM MP includes automatic discovery of SQLdm SQLDM installations and of the SQL Server instances managed from those installations. Once discovered, SQLdm 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 |
|---|
Note that the Idera SQLdm 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 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 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.
...
The automatically discovered Object ID for a SQL Instance is : Idera.SQLDM.SqlInstance.
| Scroll pdf ignore | ||||||
|---|---|---|---|---|---|---|
Newtabfooter |
|
...
SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >
...
...