| | DisplayName | Description | ID | Target | Parent Monitor | Category | Enabled | Instance Name | Counter Name | Frequency | Alert Generate | Alert Severity | Alert Priority | Alert Auto Resolve | Monitor Type | Remotable | Accessibility | RunAs |
|---|
 | Distribution Agents state (aggregated for all Publications) | This monitor checks the state of the Distribution agents for all publications serviced by this Distributor. | Microsoft.SQLServer.Replication.Windows.Monitor.DistributionAgentState | Microsoft.SQLServer.Replication.Windows.Distributor | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.Replication.Windows.MonitorType.ReplicationAgentState | True | Public | Microsoft.SQLServer.Core.RunAs.Monitoring |
| Availability of the Distribution database | This monitor checks the availability of the Distribution database from the Distributor. | Microsoft.SQLServer.Replication.Windows.Monitor.DistributionDBAvailability | Microsoft.SQLServer.Replication.Windows.Distributor | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.Replication.Windows.MonitorType.DBConnectionMonitor | True | Public | Microsoft.SQLServer.Core.RunAs.Monitoring |
| Availability of the Distribution database from a Subscriber | This monitor checks availability of the Distribution database from the Subscriber. | Microsoft.SQLServer.Replication.Windows.Monitor.DistributionDBAvailabilityFromSubscriber | Microsoft.SQLServer.Replication.Windows.Distributor | System.Health.AvailabilityState | AvailabilityHealth | False | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.Replication.Windows.MonitorType.DistributorAvailabilityFromSubscriberMonitorType | True | Public | Microsoft.SQLServer.Core.RunAs.Monitoring |
| Pending Commands on Distributor | There are pending commands on the Distributor waiting for delivery. Note that this monitor is disabled for Merge Subscriptions. | Microsoft.SQLServer.Replication.Windows.Monitor.DistributionDBPendingCmds | Microsoft.SQLServer.Replication.Windows.Distributor | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.Replication.Windows.MonitorType.DistributorPendingCmds | True | Public | Microsoft.SQLServer.Core.RunAs.Monitoring |
| SQL Server Agent State for Distributor | This monitor checks if the SQL Server Agent is running on Distributor. | Microsoft.SQLServer.Replication.Windows.Monitor.Distributor.SQLServerAgentState | Microsoft.SQLServer.Replication.Windows.Distributor | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.Replication.Windows.MonitorType.SqlServiceStatus | True | Public | Microsoft.SQLServer.Core.RunAs.Monitoring |
| Distributor Securables Configuration Status | This monitor checks the status of Replication Distributor securables access configuration on Windows. | Microsoft.SQLServer.Replication.Windows.Monitor.DistributorSecurablesConfigMonitor | Microsoft.SQLServer.Replication.Windows.Distributor | System.Health.ConfigurationState | AvailabilityHealth | True | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.Replication.Windows.MonitorType.DistributorSecurablesConfig | True | Public | |
| Replication Log Reader Agent State for the Distributor (aggregated for all Publications) | This monitor checks the state of the Replication Log Reader for all Publications serviced by the Distributor. | Microsoft.SQLServer.Replication.Windows.Monitor.LogReaderAgentState | Microsoft.SQLServer.Replication.Windows.Distributor | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.Replication.Windows.MonitorType.ReplicationAgentState | True | Public | Microsoft.SQLServer.Core.RunAs.Monitoring |
| Replication Merge Agent State for the Distributor (aggregated for all Subscriptions) | This monitor checks the state of the Merge agents for all Subscriptions on the Distributor. | Microsoft.SQLServer.Replication.Windows.Monitor.MergeAgentState | Microsoft.SQLServer.Replication.Windows.Distributor | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.Replication.Windows.MonitorType.ReplicationAgentState | True | Public | Microsoft.SQLServer.Core.RunAs.Monitoring |
| Percent of Deactivated Subscriptions | Percent of Deactivated Subscriptions Monitor | Microsoft.SQLServer.Replication.Windows.Monitor.PercentOfDeactivatedSubscriptions | Microsoft.SQLServer.Replication.Windows.Distributor | System.Health.ConfigurationState | PerformanceHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.Replication.Windows.MonitorType.DistributorPercentOfDeactivatedSubscriptions | True | Public | Microsoft.SQLServer.Core.RunAs.Monitoring |
| Percent of Expired Subscriptions | Percent of Expired Subscriptions Monitor | Microsoft.SQLServer.Replication.Windows.Monitor.PercentOfExpiredSubscriptions | Microsoft.SQLServer.Replication.Windows.Distributor | System.Health.ConfigurationState | PerformanceHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.Replication.Windows.MonitorType.DistributorPercentOfExpiredSubscriptions | True | Public | Microsoft.SQLServer.Core.RunAs.Monitoring |
| Replication Log Reader Agent State for Publication | This monitor checks the status of the Replication Log Reader Agent service for Publications. | Microsoft.SQLServer.Replication.Windows.Monitor.PublicationLogReaderAgentState | Microsoft.SQLServer.Replication.Windows.Publication | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.Replication.Windows.MonitorType.ReplicationAgentState | True | Internal | Microsoft.SQLServer.Core.RunAs.Monitoring |
| Replication Snapshot Agent State | This monitor checks the status of the Replication Snapshot Agent service for Publications. | Microsoft.SQLServer.Replication.Windows.Monitor.PublicationSnapshotAgentState | Microsoft.SQLServer.Replication.Windows.Publication | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.Replication.Windows.MonitorType.ReplicationAgentState | True | Public | Microsoft.SQLServer.Core.RunAs.Monitoring |
| Publication Snapshot Available Space | 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. | Microsoft.SQLServer.Replication.Windows.Monitor.PublicationSnapshotFreeSpace | Microsoft.SQLServer.Replication.Windows.Distributor | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.Replication.Windows.MonitorType.DistributorSnapshotFreeSpace | True | Public | Microsoft.SQLServer.Core.RunAs.Monitoring |
| All Subscriptions are Synchronizing for Publication | All Subscriptions are Synchronizing | Microsoft.SQLServer.Replication.Windows.Monitor.PublicationSubscriptionSyncStatusMonitor | Microsoft.SQLServer.Replication.Windows.Publication | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.Replication.Windows.MonitorType.PublicationSubscriptionSyncStatus | True | Public | Microsoft.SQLServer.Core.RunAs.Monitoring |
| SQL Server Agent State for Publisher | This monitor checks if the SQL Server Agent is running on Publisher. | Microsoft.SQLServer.Replication.Windows.Monitor.Publisher.SQLServerAgentState | Microsoft.SQLServer.Replication.Windows.Publisher | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.Replication.Windows.MonitorType.SqlServiceStatus | True | Public | Microsoft.SQLServer.Core.RunAs.Monitoring |
| Publisher Securables Configuration Status | This monitor checks the status of Replication Publisher securables access configuration on Windows. | Microsoft.SQLServer.Replication.Windows.Monitor.PublisherSecurablesConfigMonitor | Microsoft.SQLServer.Replication.Windows.Publisher | System.Health.ConfigurationState | AvailabilityHealth | True | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.Replication.Windows.MonitorType.PublisherSecurablesConfig | True | Public | |
| Subscriptions state for Publisher | This monitor checks whether there are any inactive subscriptions for any publications. | Microsoft.SQLServer.Replication.Windows.Monitor.PublisherSubscriptionsMonitor | Microsoft.SQLServer.Replication.Windows.Publisher | System.Health.ConfigurationState | PerformanceHealth | True | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.Replication.Windows.MonitorType.PublisherSubscriptionsMonitor | True | Public | Microsoft.SQLServer.Core.RunAs.Monitoring |
| Replication Queue Reader Agent State for Distributor (aggregated for all Publications) | This monitor checks the status of the Queue Reader Agent services for all Publications on the Distributor. Note: This monitor is disabled by default. Please use overrides to enable it when necessary. | Microsoft.SQLServer.Replication.Windows.Monitor.QueueReaderAgentState | Microsoft.SQLServer.Replication.Windows.Distributor | System.Health.PerformanceState | PerformanceHealth | False | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.Replication.Windows.MonitorType.ReplicationAgentState | True | Public | Microsoft.SQLServer.Core.RunAs.Monitoring |
| Replication Agents failed on the Distributor | This monitor checks if the following Replication agent jobs are in a healthy state: Distribution agent, Merge agent, and Snapshot agent. If any of the agents are in a failed state, the monitor will be triggered. | Microsoft.SQLServer.Replication.Windows.Monitor.ReplicationAgentFailJobs | Microsoft.SQLServer.Replication.Windows.Distributor | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.Replication.Windows.MonitorType.DistributorFailJobs | True | Public | Microsoft.SQLServer.Core.RunAs.Monitoring |
| One or more of the Replication Agents are retrying on the Distributor | This monitor checks if any of the following Replication Agents are retrying an operation: Distribution Agent, Log Reader Agent, Merge Agent, Queue Reader Agent or Snapshot Agent. | Microsoft.SQLServer.Replication.Windows.Monitor.ReplicationAgentIsRetrying | Microsoft.SQLServer.Replication.Windows.Distributor | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.Replication.Windows.MonitorType.DistributorFailJobs | True | Public | Microsoft.SQLServer.Core.RunAs.Monitoring |
| Total daily execution time of the replication agent | This monitors the total daily execution time of the replication agents, Distribution, Log Reader, Merge, Queue Reader and Snapshot on the Distributor. | Microsoft.SQLServer.Replication.Windows.Monitor.ReplicationAgentsLoad | Microsoft.SQLServer.Replication.Windows.Distributor | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.Replication.Windows.MonitorType.DistributorAgentsLoad | True | Public | Microsoft.SQLServer.Core.RunAs.Monitoring |
| Replication Snapshot Agent State for Distributor (aggregated for all Publications) | This monitor checks the state of the Snapshot Agent services for all Publications on the Distributor. | Microsoft.SQLServer.Replication.Windows.Monitor.SnapshotAgentState | Microsoft.SQLServer.Replication.Windows.Distributor | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.Replication.Windows.MonitorType.ReplicationAgentState | True | Public | Microsoft.SQLServer.Core.RunAs.Monitoring |
| SQL Server Agent State for Subscriber | This monitor checks if the SQL Server Agent is running on Subscriber. Note that SQL Server Agent Windows Service is not supported by any edition of SQL Server Express. Therefore, this monitor is not applicable for SQL Server Express cases. | Microsoft.SQLServer.Replication.Windows.Monitor.Subscriber.SQLServerAgentState | Microsoft.SQLServer.Replication.Windows.Subscriber | System.Health.AvailabilityState | AvailabilityHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.Replication.Windows.MonitorType.SqlServiceStatus | True | Public | Microsoft.SQLServer.Core.RunAs.Monitoring |
| Subscriber Agent is Retrying | The Subscriber Agent (Distribution, Log Reader, Merge, Queue Reader and Snapshot) is Retrying Monitor. Note that SQL Server Agent Windows Service is not supported by any edition of SQL Server Express. Therefore, this monitor is not applicable for SQL Server Express cases. | Microsoft.SQLServer.Replication.Windows.Monitor.SubscriberAgentIsRetryingMonitor | Microsoft.SQLServer.Replication.Windows.Subscriber | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.Replication.Windows.MonitorType.DistributorFailJobs | True | Public | Microsoft.SQLServer.Core.RunAs.Monitoring |
| Load of Replication agents on Subscriber | Replication agents (Distribution and Merge) load on Subscriber. Note that SQL Server Agent is not available for SQL Server Express Editions; therefore, this monitor is disabled for instances of such editions. | Microsoft.SQLServer.Replication.Windows.Monitor.SubscriberAgentsLoad | Microsoft.SQLServer.Replication.Windows.Subscriber | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.Replication.Windows.MonitorType.DistributorAgentsLoad | True | Public | Microsoft.SQLServer.Core.RunAs.Monitoring |
| Subscriber Securables Configuration Status | This monitor checks the status of Replication Subscriber securables access configuration on Windows. | Microsoft.SQLServer.Replication.Windows.Monitor.SubscriberSecurablesConfigMonitor | Microsoft.SQLServer.Replication.Windows.Subscriber | System.Health.ConfigurationState | AvailabilityHealth | True | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.Replication.Windows.MonitorType.SubscriberSecurablesConfig | True | Public | |
| Distribution Agent State for Subscription | This monitor checks the status of the Replication Distribution Agent services for Subscription. Note that SQL Server Agent Windows Service is not supported by any edition of SQL Server Express. Therefore, this monitor is not applicable for SQL Server Express cases. | Microsoft.SQLServer.Replication.Windows.Monitor.SubscriptionDistributionAgentState | Microsoft.SQLServer.Replication.Windows.Subscription | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.Replication.Windows.MonitorType.ReplicationAgentState | True | Public | Microsoft.SQLServer.Core.RunAs.Monitoring |
| Subscription latency | This monitor checks the latency for commands in the Distribution database waiting to be delivered to the Subscribers. Note that this monitor is disabled for Merge Subscriptions. | Microsoft.SQLServer.Replication.Windows.Monitor.SubscriptionLongEstimatedTimeMonitor | Microsoft.SQLServer.Replication.Windows.Subscription | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.Replication.Windows.MonitorType.SubscriptionLongEstimatedTime | True | Public | Microsoft.SQLServer.Core.RunAs.Monitoring |
| Replication Merge Agent State for Subscription | This monitor checks the status of the Replication Merge Agent service for Subscription. Note that SQL Server Agent Windows Service is not supported by any edition of SQL Server Express. Therefore, this monitor is not applicable for SQL Server Express cases. | Microsoft.SQLServer.Replication.Windows.Monitor.SubscriptionMergeAgentState | Microsoft.SQLServer.Replication.Windows.Subscription | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Error | Normal | True | Microsoft.SQLServer.Replication.Windows.MonitorType.ReplicationAgentState | True | Public | Microsoft.SQLServer.Core.RunAs.Monitoring |
| Subscription Pending Commands | There are pending commands on the Distributor for specific Subscription waiting delivery. Note that this monitor is disabled for Merge Subscriptions. | Microsoft.SQLServer.Replication.Windows.Monitor.SubscriptionPendingCmdsMonitor | Microsoft.SQLServer.Replication.Windows.Subscription | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.Replication.Windows.MonitorType.SubscriptionPendingCmds | True | Public | Microsoft.SQLServer.Core.RunAs.Monitoring |
| Unsynchronized Subscriptions on Distributor | This monitor detects unsynchronized subscriptions for specific Distributors. Note that this monitor is disabled for Merge Subscriptions. | Microsoft.SQLServer.Replication.Windows.Monitor.UnsyncSubscriptions | Microsoft.SQLServer.Replication.Windows.Distributor | System.Health.PerformanceState | PerformanceHealth | True | | | 0 | True | Warning | Normal | True | Microsoft.SQLServer.Replication.Windows.MonitorType.DistributorUnsyncSubscriptions | True | Public | Microsoft.SQLServer.Core.RunAs.Monitoring |
Home