Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The Idera SQLdm 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 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.

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:
 

...

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.

 

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