Before importing the SQLDM Management Pack for SCOM, you must import the relevant Microsoft Windows management packs for your current operating system. For example, if SQL Diagnostic Manager is installed on Windows Server 2008 R2, then you must install the management pack for that OS before continuing.
You can find the SQLDM MP (Idera.SQLDM.mp) in the root of the installation kit.
The SQLDM Management Pack requires that the SCOM agent has at least read access to the SQLDM Repository. Grant this access before installing the SQLDM MP and enabling discovery of any SQL Diagnostic Manager installed instances.
SQLDM MP also requires that a SCOM agent (version 2007 or above) be installed locally on each server where an instance of SQL Diagnostic Manager is present. If an agent is not already installed, then use the Discovery Wizard in the SCOM Console to push the agent installation.
The SQLDM Management Pack import process loads into the SCOM database the SQLDM MP settings, classes, and rules necessary for monitoring SQL Diagnostic Manager. The import replicates the relevant rules and objects to all systems where SQL Diagnostic Manager is installed.
The following steps help you import the SQLDM Management Pack when it is downloaded to a hard drive local to the SCOM Console. For more information about other methods of importing the Management Pack, see How to Import a Management Pack in Operations Manager 2007.
To import the SQLDM Management Pack: