Import the Management Pack
For more information about importing a management pack, see How to Import a Management Pack in Operations Manager 2007.
To start monitoring, import three management pack files for your version of SQL Server: library, discovery and monitoring.
| SQL Server 2005 | SQL Server 2008 and SQL Server 2008 R2 | |
|---|---|---|
Library |
Microsoft.SQLServer.Library.mp |
Microsoft.SQLServer.Library.mp |
Discovery |
Microsoft.SQLServer.2005.Discovery.mp |
Microsoft.SQLServer.2008.Discovery.mp |
Monitoring |
Microsoft.SQLServer.2005.Monitoring.mp |
Microsoft.SQLServer.2008.Monitoring.mp |
To avoid monitoring noise
If you are upgrading from a previous version, export and save your current management pack with any customizations so that you can roll back the installation if needed.
Import the library file.
Define Run-As accounts.
Import the discovery file.
Make sure that the required objects are discovered. In case of security alerts, adjust Run As accounts. If the list of discovered objects is not as expected, enable or disable discovery for management groups.
Import the monitoring file.
Customize the management pack.