• Management Pack:  SQL Server Replication
  • MP Version:  6.6.2.0 for 2014
  • Released:  10/15/2015
  • Publisher:  Microsoft

Microsoft SQL Server Replication Monitoring Run As Profile Run As Profile

  • ID:  Microsoft.SQLServer.Replication.Monitoring.RunAs.Monitor
  • Accessibility:  Public
  • Context:  System.Entity
  • Comment:   
  • Description:  This profile is used for monitoring of SQL Server replication objects.

Usage

Unit Monitors

Name
All Subscriptions are Synchronizing for Publication
Availability of the Distribution database.
Distribution Agent State for Subscription
Distribution Agents state (aggregated for all Publications)
Load of Replication agents on Subscriber.
One or more of the Replication Agents are retrying on the Distributor.
Pending Commands on Distributor
Percent of Deactivated Subscriptions
Percent of Expired Subscriptions
Publication Snapshot Available Space
Replication Agents failed on the Distributor.
Replication Log Reader Agent State for Publication
Replication Log Reader Agent State for the Distributor (aggregated for all Publications)
Replication Merge Agent State for Subscription
Replication Merge Agent State for the Distributor (aggregated for all Subscriptions)
Replication Queue Reader Agent State for Distributor (aggregated for all Publications)
Replication Snapshot Agent State
Replication Snapshot Agent State for Distributor (aggregated for all Publications)
SQL Server Agent State for Distributor
SQL Server Agent State for Publisher
SQL Server Agent State for Subscriber
Subscriber Agent is Retrying
Subscription latency
Subscription Pending Commands
Subscriptions state for Publisher
Total daily execution time of the replication agent.
Unsynchronized Subscriptions on Distributor

Discoveries

This Management Pack version does not contain discoveries which run under this profile

Rules

Name
MSSQL 2014 Replication: Count of Failed Replication Agents Jobs on the Distributor
MSSQL 2014 Replication: Count of Pending Commands
MSSQL 2014 Replication: Count of Pending Commands in the Distribution Database
MSSQL 2014 Replication: Count of Publications for the Distributor
MSSQL 2014 Replication: Count of Publications for the Publisher
MSSQL 2014 Replication: Count of Subscriptions for the Distributor
MSSQL 2014 Replication: Count of Subscriptions for the Subscriber
MSSQL 2014 Replication: Count of the Failed Replication Jobs for the Subscriber
MSSQL 2014 Replication: Count of Unsynchronized Subscriptions for the Distributor
MSSQL 2014 Replication: Deactivated Subscriptions (%)
MSSQL 2014 Replication: Expired Subscriptions (%)
MSSQL 2014 Replication: Replication Snapshot Available Space (%)
MSSQL 2014 Replication: The Maintenance Job(s) Failed on Distributor Alert Rule

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