[OpsMgr 2007 R2][OpsMgr 2012] System Center Management Pack for SQL Server

The Management Pack for SQL Server provides the capabilities for Operations Manager 2007 R2 and Operations Manager 2012 to discover SQL Server 2005, 2008, 2008 R2, and SQL Server 2012. It monitors SQL Server components such as database engine instances, databases, and SQL Server agents.

 

Direct link to Microsoft page

The Management pack for SQL Server provides the capabilities for Operations Manager 2007 R2 and Operations Manager 2012 to discover SQL Server 2005, 2008, 2008 R2, and SQL Server 2012. It monitors SQL Server components such as database engine instances, databases, and SQL Server agents.

The monitoring provided by this management pack includes performance, availability, and configuration monitoring, performance data collection, and default thresholds. You can integrate the monitoring of SQL Server components into your service-oriented monitoring scenarios.
In addition to health monitoring capabilities, this management pack includes dashboard views, diagram views and extensive knowledge with embedded inline tasks, and views that enable near real-time diagnosis and resolution of detected issues.

Important Prerequisite Notes:
Clusters: In order to ensure that all monitoring works correctly for clustered instances of SQL Server ensure that your OpsMgr agents on the physical nodes of the cluster are running either OpsMgr 2007 R2 or OpsMgr 2007 SP1 with the most recent cumulative update for OpsMgr 2007 SP1 applied or OpsMgr 2012.

Supported Operating System

Windows Server 2003, Windows Server 2008 R2 SP1, Windows Server 2008 Service Pack 2, Windows Server 2012

System Requirements:

Other Software:

• System Center Operations Manager 2007 R2 and System Center Operations Manager 2012
• SQL Server 2005, 2008, 2008 R2 or 2012

Clusters: In order to ensure that all monitoring works correctly for clustered instances of SQL Server ensure that your OpsMgr agents on the physical nodes of the cluster are running either OpsMgr 2007 R2 with the most recent cumulative update for OpsMgr 2007 SP1 applied.

This MP is designed to monitor the SQL Server 2005, 2008, 2008 R2, and 2012 in the following configuration:

• 32-bit SQL Server on 32-bit operating system
• 64-bit SQL Server on 64-bit operating system. For SQL Server 2005, only SP2 or later is supported
• 32-bit SQL Server on 64-bit operating system

 

The SQL Server management packs also provide monitoring for clustered installations of all SQL roles that can be installed on a cluster. The following limitations apply to support for monitoring clustered installations:

• Installations of SQL Server on cluster quorum drives are not supported, and this configuration is not suggested, as documented in Knowledge Base article 280345.
• Support for SQL Server cluster resource groups, which contain more than one network name resource requires additional configuration and the agents must be running Operations Manager 2007 R2 or Operations Manager 2007 SP1 with the most recent cumulative update applied. Refer to Enabling multiple entries for network name resources in for instructions on the additional configuration.
• Low-privilege discovery and monitoring is not supported on clustered configurations in this release, except SQL 2012 Cluster.

This posting is provided "AS IS" with no warranties.