Servers

    System Center Management Pack for SQL Server

    Select Language:
    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.
    • Note:There are multiple files available for this download.Once you click on the "Download" button, you will be prompted to select the files you need.
      Version:

      6.5.4.0

      File Name:

      SQLServerMP.msi

      SQLServerMPGuide.doc

      Date Published:

      12/15/2014

      File Size:

      3.1 MB

      3.0 MB

        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.

        Feature Summary:
        The following list gives an overview of the features of the SQL Server management pack. Refer to the SQL Server management pack guide for more detail.

        New features and fixes:
        • Added Mirroring monitoring scenarios for SQL Server 2012 product
        • SPN monitor now has ‘search scope’ parameter which allows the end user to choose between LDAP and Global Catalog
        • Fixed the error with blocked discovering DBs on Windows 2003
        • Fixed Timeout error in CPU utilization monitoring scenario
        • Monitoring SQL Server Instances on the same server with their own network interfaces and default port is now available
        • SQL Server instances with underscores and other allowed special symbols in names can be monitored
        • Minor fixes.

        Features:
        • Monitors and Rules – only for SQL 2008 and SQL 2012
          • Collect DB Active Connections count
          • Collect DB Active Requests count
          • Collect DB Active Sessions count
          • Collect DB Active Transactions count
          • Collect DB Engine Thread count
          • Thread Count monitor
          • Transaction Log Free Space (%) monitor
          • Transaction Log Free Space (%) collection
          • Collect DB Engine CPU Utilization (%)
          • CPU Utilization (%) monitor for DB engine
          • Buffer Cache Hit Ratio monitor
          • Collect DB Engine Page Life Expectancy (s)
          • Page Life Expectancy monitor
          • Collect DB Disk Read Latency (ms)
          • Collect DB Disk Write Latency (ms)
          • Disk Read Latency monitor
          • Disk Write Latency monitor
          • Collect DB Transactions per second count
          • Collect DB Engine Average Wait Time (ms)
          • Average Wait Time monitor
          • Collect DB Engine Stolen Server Memory (MB)
          • Stolen Server Memory monitor
          • Collect DB Allocated Free Space (MB)
          • Collect DB Used Space (MB)
          • Collect DB Disk Free Space (MB)
          • SQL Re-Compilation monitor
        • Run As configuration changes to support Low privilege for SQL Server 2012 Cluster
        • AlwaysOn Monitoring
          • Automatically discover and monitor availability groups, availability replicas, and availability databases for hundreds of computers.
          • Health roll-up from availability database to availability replicas.
          • Detailed knowledge with every critical health state to enable faster resolution to a problem.
        • Seamless integration with Policy based management (PBM)
          • Auto-discover custom PBM polices targeting AlwaysOn and database components.
          • Rollup of health of policy execution within the SQL monitoring pack under extended health.
        • Support for Replication Monitoring (only applicable to SQL Server 2008 version of management pack)
          • Approximately twenty rules to detect replication events.
        • Support for Mirroring Monitoring (only applicable to SQL Server 2008 and 2012 versions of management pack)
          • Discover mirroring databases, witness, and mirroring group.
          • Monitor database mirror state, database mirror witness state, and mirroring partners’ state.
          • Custom diagram view to visually represent the primary and the mirrored databases.
        • Improved Freespace monitoring with mount point support
        • Support for Enterprise, Standard and Express editions of SQL Server 2005, 2008, 2008 R2, and 2012 and 32bit, 64bit and ia64 architectures.
        • Support for both simple and complex SQL Server configurations such as clustered installations, multiple instances and 32bit roles running on a 64bit OS. For full details on supported configurations refer to the guide included with the management pack.
        • Discovery and monitoring of SQL Server roles such as DB Engine, Reporting Services, Analysis Services, Integrations Services.
        • Discovery of SQL Server components such as databases, the SQL Agent and SQL jobs.
        • Views covering areas such as database free space, SQL Server related performance, SQL Server related alerts, and lists of the various SQL Server roles and components which are discovered and their related state.
        • Discovery and basic monitoring for SQL Server Reporting Services and Integration Services.
        • Reports for longer-term analysis of common problem areas related to SQL Server such as SQL Server lock analysis and top deadlocked databases, SQL Server service pack levels across discovered roles, user connection activity. Likewise the generic reports from the Microsoft Generic Report Library can be used against the roles and components discovered by the SQL MPs to review availability and performance across many systems and over longer periods of time.
        • Role and component specific tasks which provide access to common tools, triage information, or corrective actions without needing to leave the Operations Console in most cases.
        • Monitoring of databases covers database status, database free space, log shipping monitoring for both the source and destination, and transaction log free space.
        • Monitoring of key SQL Server related services.
        • Monitoring for persistent SPID blocking.
        • Monitoring of numerous SQL Server events and performance data points. Alerts bring the issue to your attention and provide knowledge on the impact and possible resolutions.
        • A low-privilege configuration for discovery and monitoring that eliminates the need for SQL Server sysadmin, dbo, db_owner, and box admin privileges
    • 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.

          In general, the supported configurations are outlined in the following locations:
          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.
      • For detailed instructions on setup, configuration and monitoring of clustered SQL Server resources, see “Configuration for Monitoring Clustered Resources” in the management pack guide

    Popular downloads

    Loading your results, please wait...

    Free PC updates

    • Security patches
    • Software updates
    • Service packs
    • Hardware drivers

    Microsoft suggests

    Download a free trial of Windows Server 2012 R2.
    Windows Server 2012 R2 free trial
    Experience the new and enhanced capabilities.
    Free trial