• Management Pack:  SQL Server Replication
  • MP Version:  7.0.0.0 for 2017+
  • Released:  11/13/2017
  • Publisher:  Microsoft

Overview

Microsoft System Center Management Pack for SQL Server 2017+ Replication enables the discovery and monitoring of SQL Server Replication 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. The management pack is designed to run by Operations Manager 2012 R2 or Operations Manager 2016. This management pack was thoroughly built from the ground up in accordance with Best Practices for SQL Server; it is intended to monitor SQL Server Replication in SQL Server 2017 and all upcoming SQL Server versions. 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 2017+ 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 2017+ 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 2017+ Replication. Please refer to Microsoft SQL Server 2017+ 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.
Login
SQL Server on Windows Replication Alerts Scope Group A group containing all SQL Server on Windows Replication components Microsoft SQL Server Merge Subscription Group. The Generic Replication Alerts Scope Group contains SQL Server objects which can raise alerts. SQL Server Replication Alerts Scope Group contains SQL Server objects which can throw alerts. Replication Library Database Health Group is a group of Replication Database Health objects. Subscriber Group is a group that contain all Express Subscribers The Virtual Replication Alerts Scope Group contains Virtual Replication objects which can raise alerts. An installation of Microsoft SQL Server Replication Seed. MSSQL Replication Monitoring Pool Alert Collection on Windows. This object is used to collect Windows module errors and warnings from event log of nodes that are the members of the SQL Server Monitoring Pool. This class is a dynamic application used to group Publishers, distributors and Subscribers which are linked with a single Publisher database. A Distributor Group is a group of Distributors. Distributor Instances Group is a group that contains all SQL Server instances with a Distributor. A Publisher Group is a group of Publishers. A Publisher Instances Group is a group that contains all SQL Server Instances with Publishers. This group is a collection of Publishers, distributors and Subscribers. It contains all objects related to the replication which can be found in the System Center Operations Manager database. Subscriber Group is a group that contain all Subscribers. Subscriber Instances Group is a group that contains all SQL Server Instances with Subscribers. Virtual Distributor. Virtual Publication host. Virtual Publisher. Virtual Subscriber. Virtual Subscriber host. Virtual Subscription. SQL Server on Windows Distributor is a SQL Server instance that acts as a store for replication specific data associated with one or more Publishers A publication is a collection of one or more articles from one database. The grouping of multiple articles into a publication makes it easier to specify a logically related set of database data and objects that are replicated as a unit. SQL Server on Windows Publisher is a SQL on Windows instance that makes data available to other locations through replication. SQL Server on Windows Subscriber is a SQL on Windows instance that receives replicated data. SQL Server on Windows Subscription is a request for a copy of a publication to be delivered to a Subscriber.

Download diagram as a Visio file

Compare with Other Versions of This Management Pack

There are no compatible versions available

See Also for SQL Server Replication Management Pack


Downloads for SQL Server Replication Management Pack

AZURE OPTIMIZATION ASSESSMENT GET STARTED
MIGRATION TO AZURE GET STARTED
SYSTEM CENTER MIGRATION TO AZURE GET STARTED
MIGRATION TO AZURE FOR SQL AND WINDOWS 2008 GET STARTED