All Publishers Discovered for Distributor |
1
|
Virtual Distributor
|
MSSQL Replication: Incorrect count of discovered Publishers. |
This monitor checks that all Publishers are discovered for the Distributor. |
All Subscriptions are Synchronizing for Publication |
1
|
SQL Server 2008 Publication
|
MSSQL2008 Replication: Publication {0} on the Publisher {1} has subscriptions that are out of sync. |
All Subscriptions are Synchronizing |
Availability of the Distribution database from a Subscriber. |
0
|
SQL Server 2008 Distributor
|
MSSQL2008 Replication: The Distribution Database is not available from the Subscriber. |
This monitor checks availability of the Distribution database from the Subscriber. |
Availability of the Distribution database. |
1
|
SQL Server 2008 Distributor
|
MSSQL2008 Replication: The Distribution database is not available. |
This monitor checks the availability of the Distribution database from the Distributor. |
Distribution Agent State for Subscription |
1
|
SQL Server 2008 Subscription
|
MSSQL2008 Replication: Distribution Agent for Subscription has an error. |
This monitor checks the status of the Replication Distribution Agent services for Subscription. |
Distribution Agents state (aggregated for all Publications) |
1
|
SQL Server 2008 Distributor
|
MSSQL2008 Replication: Distribution Agent has errors. |
This monitor checks the state of the Distribution agents for all publications serviced by this Distributor. |
Load of Replication agents on Subscriber. |
1
|
SQL Server 2008 Subscriber
|
MSSQL2008 Replication: The replication agents on the Subscriber are running under heavy load. |
Replication agents (Distribution and Merge) load on Subscriber |
One or more of the Replication Agents are retrying on the Distributor. |
1
|
SQL Server 2008 Distributor
|
MSSQL2008 Replication: Replication Agent is retrying on the Distributor. |
This monitor checks if any of the following Replication Agents are retrying an operation: Distribution Agent, LogReader Agent, Merge Agent, QueueReader Agent or Snapshot Agent. |
Pending Commands on Distributor |
1
|
SQL Server 2008 Distributor
|
MSSQL2008 Replication: A high number of commands in the Distribution database are waiting to be applied. |
There are pending commands on the Distributor waiting for delivery. |
Percent of Deactivated Subscriptions |
1
|
SQL Server 2008 Distributor
|
MSSQL2008 Replication: High percentage of deactivated subscriptions detected on the Distributor. |
Percent of Deactivated Subscriptions Monitor |
Percent of Expired Subscriptions |
1
|
SQL Server 2008 Distributor
|
MSSQL2008 Replication: A high percentage of expired subscriptions has been detected on the Distributor. |
Percent of Expired Subscriptions Monitor |
Publication Snapshot Available Space |
1
|
SQL Server 2008 Distributor
|
MSSQL2008 Replication: Insufficient Free Space for Snapshot on the Distributor. |
The monitor reports a warning when the available disk space for the publication Snapshot drops below the Warning Threshold setting. This is indicated as a percentage of the snapshot files folder size. The monitor reports a critical alert when the available space drops below the Critical Threshold. |
Replication Agents failed on the Distributor. |
1
|
SQL Server 2008 Distributor
|
MSSQL2008 Replication: Failed jobs detected on the Distributor. |
This monitor checks if the following Replication agent jobs are in a healthy state: Distribution agent, Merge agent, QueueReader agent, Log reader agent or Snapshot agent. If any of the agents are in a failed state, the monitor will be triggered. |
Replication Log Reader Agent State for Publication |
1
|
SQL Server 2008 Publication
|
MSSQL2008 Replication: Replication Log Reader agent has an error for Publication. |
This monitor checks the status of the Replication Log Reader Agent service for Publications. |
Replication Log Reader Agent State for the Distributor (aggregated for all Publications) |
1
|
SQL Server 2008 Distributor
|
MSSQL2008 Replication: Replication Log Reader Agent has errors. |
This monitor checks the state of the Replication Log Reader for all Publications serviced by the Distributor. |
Replication Merge Agent State for Subscription |
1
|
SQL Server 2008 Subscription
|
MSSQL2008 Replication: The Merge agent for Subscription has an errors. |
This monitor checks the status of the Replication Merge Agent service for Subscription. |
Replication Merge Agent State for the Distributor (aggregated for all Subscriptions) |
1
|
SQL Server 2008 Distributor
|
MSSQL2008 Replication: The Merge Replication Agent has errors on the Distributor. |
This monitor checks the state of the Merge agents for all Subscriptions on the Distributor. |
Replication Queue Reader Agent State for Distributor (aggregated for all Publications) |
1
|
SQL Server 2008 Distributor
|
MSSQL2008 Replication: The Replication Queue Reader Agent has errors. |
This monitor checks the status of the Queue Reader Agent services for all Publications on the Distributor. |
Replication Snapshot Agent State |
1
|
SQL Server 2008 Publication
|
MSSQL2008 Replication: Replication Snapshot agent has an error. |
This monitor checks the status of the Replication Snapshot Agent service for Publications. |
Replication Snapshot Agent State for Distributor (aggregated for all Publications) |
1
|
SQL Server 2008 Distributor
|
MSSQL2008 Replication: Replication Snapshot Agent has errors. |
This monitor checks the state of the Snapshot Agent services for all Publications on the Distributor. |
SQL Server Agent State for Distributor |
1
|
SQL Server 2008 Distributor
|
MSSQL2008 Replication: Distributor: SQL Server Agent Windows service stopped. |
This monitor checks if the SQL Server Agent is running on Distributor. |
SQL Server Agent State for Publisher |
1
|
SQL Server 2008 Publisher
|
MSSQL2008 Replication: Publisher: SQL Server Agent Windows Service is stopped. |
This monitor checks if the SQL Server Agent is running on Publisher. |
SQL Server Agent State for Subscriber |
1
|
SQL Server 2008 Subscriber
|
MSSQL2008 Replication: SQL Server Agent Windows Service on Subscriber is stopped. |
This monitor checks if the SQL Server Agent is running on Subscriber. |
Subscriber Agent is Retrying |
1
|
SQL Server 2008 Subscriber
|
MSSQL2008 Replication: Subscriber Agent is retrying. |
The Subscriber Agent (Distribution, LogReader, Merge, QueueReader and Snapshot) is Retrying Monitor |
Subscription latency |
1
|
SQL Server 2008 Subscription
|
MSSQL2008 Replication: High Latency for Commands in the Distribution Database Detected for Subscription. |
This monitor checks the latency for commands in the Distribution database waiting to be delivered to the subscribers. |
Subscription Pending Commands |
1
|
SQL Server 2008 Subscription
|
MSSQL2008 Replication: High number of commands in the distribution database are waiting to be applied. |
There are pending commands on the Distributor for specific Subscription waiting delivery. |
Subscriptions state for Publisher |
1
|
SQL Server 2008 Publisher
|
MSSQL2008 Replication: Inactive subscription(s) detected for Publisher. |
This monitor checks whether there are any inactive subscriptions for any publications. |
Total daily execution time of the replication agent. |
1
|
SQL Server 2008 Distributor
|
MSSQL2008 Replication: Replication agents exceeded the total daily execution time threshold. |
This monitors the total daily execution time of the replication agents, Distribution, LogReader, Merge, QueueReader and Snapshot on the Distributor. |
Unsynchronized Subscriptions on Distributor |
1
|
SQL Server 2008 Distributor
|
MSSQL2008 Replication: Unsynchronized Subscriptions detected. |
This monitor detects unsynchronized subscriptions for specific Distributors. |