Microsoft System Center Management Pack for SQL Server Replication

Microsoft System Center Management Pack for SQL Server Replication enables the discovery and monitoring of SQL Server Replication 2012, 2014, 2016, 2017, 2019 and upcoming versions of SQL Server as a set of technologies for copying and distributing data and database objects from one database to another and then synchronizing between the databases to maintain consistency. This management pack is designed to run by Operations Manager 2012 R2, Operations Manager 2016, Operations Manager 1801/1807, or Operations Manager 2019.

This management pack was thoroughly built from the ground up in accordance with Best Practices for SQL Server. The monitoring provided by the 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 Replication components into your service-oriented monitoring scenarios.

In addition to health monitoring capabilities, this management pack includes dashboards, diagram views, state views, performance views and alert views that enable near real-time diagnostics and remediation of detected issues.

The management pack automatically selects the monitoring type used by the management pack for SQL Server to monitor the appropriate SQL Server instance. Replication objects discovered and monitored by the management pack are as follows:

• Distributor
• Publisher
• Subscriber
• Publication
• Subscription

Feature Summary
The following list gives an overview of the features introduced by Microsoft System Center Operations Manager Management Pack for SQL Server Replication. Please refer to Microsoft SQL Server Replication Management Pack Guide for more details.

• Agentless monitoring is now available along with traditional agent monitoring.
• Usage of scripts is discontinued in favor of .Net Framework modules.
• SQL Server Dynamic Management Views and Functions are now used for getting information on health and performance. Previously some of these monitors were using WMI and other system data sources.

Supported Operating Systems

Windows Server 2012 Standard, Windows Server 2012 R2 Standard , Windows Server 2016, Windows Server 2019

For detailed system requirements refer to the management pack guide.

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