Legacy Update: Get back online, activate, and install updates on your legacy Windows PC

Microsoft System Center Management Pack for SQL Server 2016 enables the discovery and monitoring of SQL Server 2016 Database Engines, Databases, SQL Server Agents, and other related components.

• Microsoft System Center Management Pack for SQL Server 2016 enables the discovery and monitoring of SQL Server 2016 Database Engines, Databases, SQL Server Agents, and other related components. This Management Pack is designed to run by Operations Manager 2007 R2 (except dashboards), Operations Manager 2012 SP1, Operations Manager 2012 R2 or Operation Manager 2016.
  
  The monitoring provided by this management pack includes performance, availability, and configuration monitoring, as well as performance and events data collection. All monitoring workflows have predefined thresholds and complimentary knowledge base articles. You can integrate the monitoring of SQL Server 2016 components into your service-oriented monitoring scenarios.
  
  In addition to health monitoring capabilities, this management pack includes dashboards, diagram views, state views, performance views, alert views and diagnostic tasks that enable near real-time diagnostics and remediation of detected issues.
  
  Note: This management pack does not depend on Microsoft SQL Server Library management pack. You do not need to import it to enable the monitoring of SQL Server 2016.
  Note: If you are going to localize this management pack, keep in mind that localization installers on this page do not include files for localizing SQL Server Dashboards. Please use this link to download the required localization for Dashboards.
  
  Feature Summary
  The following list gives an overview of the features introduced by Microsoft System Center Operations Manager Management Pack for SQL Server 2016. Please refer to Microsoft SQL Server 2016 Management Pack Guide for more details.
  
  • Discovery and monitoring of SQL Server 2016 roles like DB Engine, Integrations Services.
  • Discovery of SQL Server 2016 components: Databases, SQL Agent and SQL jobs.
  • The management pack introduces 100+ monitors and 380+ rules to provide a deep monitoring of SQL Server 2016. Please refer to Microsoft SQL Server 2016 Management Pack Guide for the complete list of monitoring scenarios and workflow inventory.
  • Monitoring of SQL Server 2016 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 2016 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.
  • Monitoring of SQL Server Memory-Optimized Tables.
  • Low-privilege monitoring is supported for both stand-alone installations and clustered environments, except PBM.
  • Support for Mirroring Monitoring
  • 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.

Files

Status: Deleted This download is no longer available on microsoft.com. The downloads below are archives provided by the Internet Archive Wayback Machine from the Microsoft Download Center prior to August 2020.

File	Size
SQLServer2016MP.msi SHA1: 063417f4f75439518ae212c752d1c6c8364a99d2	2.80 MB
SQLServer2016MPGuide.pdf SHA1: be145cf91caeba8039396e74fb3690d850cea6ff	3.52 MB
SQLServerDashboardsGuide.pdf SHA1: 1685a6478be658feeb72269b9a522fd484ee5695	1.49 MB

• For detailed system requirements refer to the management pack guide.

• For detailed instructions on setup, configuration, and monitoring refer to the management pack guide.