Microsoft System Center Management Pack for SQL Server

Select Language:
Management Pack for SQL Server provides the capabilities for Operations Manager 2007 R2, Operations Manager 2012, and Operations Manager 2012 R2 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.7.2.0

    File Name:

    SQLServerDashboards.docx

    SQLServerMP.msi

    SQLServerMPGuide.doc

    Date Published:

    6/29/2016

    File Size:

    2.9 MB

    4.7 MB

    3.6 MB

      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, along with 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 SQL Server management pack features. Refer to SQL Server management pack guide for more details.
      • Discovery and monitoring of SQL Server 2005, 2008, 2012 roles like DB Engine, Integrations Services.
      • Discovery of SQL Server 2005, 2008, 2012 components: Databases, SQL Agent and SQL jobs.
      • Monitoring of SQL Server 2012 Always On:
        • Automatic discovery and monitoring of availability groups, availability replicas, and availability databases.
        • Health roll-up from availability database to availability replicas.
        • Detailed knowledge for each related monitoring workflow.
      • Seamless integration with SQL Server policy based management (PBM):
        • Automatic discovery and monitoring of custom PBM polices targeted to Database or Database components.
        • Rollup of policy execution health to the health of related SCOM entity.
      • Reports for long-term analysis of different problematic areas related to SQL Server, such as SQL Server lock analysis, top deadlocked databases, SQL Server service pack levels, user connection activity. In addition, generic reports from the Microsoft Generic Report Library can be used to review availability and performance of objects discovered by Microsoft System Center Operations Manager Management Pack for SQL Server.
      • Low-privilege monitoring is supported for both stand-alone installations and clustered environments, except PBM.
      • Support for Mirroring Monitoring for SQL Server 2008, 2008 R2 and 2012
        • Discover mirroring databases, witness, and mirroring group.
        • Monitor database mirror state, database mirror witness state, and mirroring partners’ state.
        • Custom diagram view to represent the primary and the mirrored databases visually.
      New features and fixes:
      • Added rules for alerting when an Availability Replica changed its role and/or a Database Replica changed its role
      • Created a group for WOW64 SQL Server instances and disabled launching some workflows for these instances
      • Added MP version line into MP's events generated by scripts
      • Fixed display strings and Knowledge Base articles
      • Fixed: some scripts do not return data when one of few installed instances is stopped
      • Fixed: SPN configuration monitor uses stale data
      • Fixed: Mirroring monitoring scripts fail when instance is stopped
      • Fixed Always On Database replica discovery incorrect behavior; fixed Always On policies discovery and monitoring
      • Fixed Database policies discovery and monitoring
      • Fixed and optimized CPU Usage monitoring scripts (the issue appeared when only one core was assigned)
      • Added support for more than 32 processors count in CPU Usage monitoring.
      • SQLPS module is now used for the tasks instead of deprecated SQLPS.EXE
      • Implemented FILESTREAM filegroup monitoring
      • Multiple Ports are now supported in SQL Server TCP/IP parameters
      • Fixed error occurring when no port is specified in SQL Server TCP/IP parameters
      • Fixed filegroup read-only state discovery
      • Fixed RunAs profiles mapping for some workflows
      • Implemented support for TLS 1.2 in connection logic
      • Implemented support for different client drivers in connection logic
      • Updated connection logic error logging
      • Added RunAs profiles for mirroring monitors, fixed mirroring discovery issues
      • Fixed issue: CPU usage monitor ignored SQL server limitations on CPU core count
      • Fixed display strings and Knowledge Base articles
      • Fixed error reporting in the scripts
      • Fixed intermittent "Cannot login to database" alert with some rules
      • Added support for SQL Express Instances
      • Updated Knowledge Base articles
      • Microsoft SQL Server 2012 x86 on Windows 2008 R2: fixed the issue when DB filegroups cannot be discovered
      • Win10 support: fixed "Cannot bind argument to parameter 'Path' because it is an empty string." issue
      • Fixed issue when SQL Configuration Manager starts snap-in of wrong version
      • Fixed invalid Always On non-readable replica detection
  • Supported Operating System

    Windows Server 2008 R2 SP1, Windows Server 2012, Windows Server 2012 R2

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

      Supported Configurations

      This MP is designed to monitor the SQL Server 2005, 2008, 2008 R2, and 2012 in the following configurations:
      • 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
      Clustered configurations are supported. The following limitations apply to support for clustered installations monitoring:
      • 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 at least Operations Manager 2007 R2 with the most recent cumulative update applied. Refer to "Enabling multiple entries for network name resources" 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 refer to the management pack guide.
Site feedback
Microsoft

What category would you like to give web site feedback on?



Rate your level of satisfaction with this web page today:

Comments:

Submit