| | DisplayName | Description | ID | Target | Category | Enabled | Instance Name | Counter Name | Frequency | Event_ID | Event Source | Alert Generate | Alert Severity | Alert Priority | Remotable | Event Log |
|---|
 | MSSQL on Windows Replication: Merge Agent: Conflicts per Second | The number of conflicts per second occurring during the merge process. | Microsoft.SQLServer.Replication.Windows.CollectionRule.Distributor.ConflictsPerSec | Microsoft.SQLServer.Replication.Windows.Distributor | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL on Windows Replication: Count of Publications for the Distributor | Count of Publications for the Distributor. | Microsoft.SQLServer.Replication.Windows.CollectionRule.Distributor.CountOfPublicationsPerformanceCounter | Microsoft.SQLServer.Replication.Windows.Distributor | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL on Windows Replication: Count of Subscriptions for the Distributor | Count of Subscriptions for the Distributor. | Microsoft.SQLServer.Replication.Windows.CollectionRule.Distributor.CountOfSubscriptionsPerformanceCounter | Microsoft.SQLServer.Replication.Windows.Distributor | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL on Windows Replication: Count of Unsynchronized Subscriptions for the Distributor | Count of unsynchronized subscriptions for the Distributor | Microsoft.SQLServer.Replication.Windows.CollectionRule.Distributor.CountOfUnsyncSubscriptionsPerformanceCounter | Microsoft.SQLServer.Replication.Windows.Distributor | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL on Windows Replication: Distribution Agent: Delivered Commands per Second | The number of commands per second delivered to the Subscriber. | Microsoft.SQLServer.Replication.Windows.CollectionRule.Distributor.DeliveredCmdsPerSec | Microsoft.SQLServer.Replication.Windows.Distributor | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL on Windows Replication: Distribution Agent: Delivery Latency | The current amount of time (in milliseconds) elapsed from when transactions are delivered to the Distributor to when they are applied at the Subscriber. | Microsoft.SQLServer.Replication.Windows.CollectionRule.Distributor.DeliveredLatency | Microsoft.SQLServer.Replication.Windows.Distributor | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL on Windows Replication: Distribution Agent: Delivered Transactions per Second | The number of transactions per second delivered to the Subscriber. | Microsoft.SQLServer.Replication.Windows.CollectionRule.Distributor.DeliveredTransPerSec | Microsoft.SQLServer.Replication.Windows.Distributor | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL on Windows Replication: Count of the Distribution Agent Instances for the Distributor | Count of the Distribution Agent Instances for the Distributor | Microsoft.SQLServer.Replication.Windows.CollectionRule.Distributor.Distribution | Microsoft.SQLServer.Replication.Windows.Distributor | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL on Windows Replication: Count of Pending Commands in the Distribution Database | Count of commands in the Distribution database pending replication. | Microsoft.SQLServer.Replication.Windows.CollectionRule.Distributor.DistributionDBPendingCmdsPerformanceCounter | Microsoft.SQLServer.Replication.Windows.Distributor | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL on Windows Replication: Merge Agent: Download Changes per Second | The number of rows per second replicated from the Publisher to the Subscriber (aggregated for Distributor). | Microsoft.SQLServer.Replication.Windows.CollectionRule.Distributor.DownloadChangesPerSec | Microsoft.SQLServer.Replication.Windows.Distributor | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL on Windows Replication: Count of the Log Reader Agent Instances for the Distributor | Count of the Log Reader Agent Instances for the Distributor. | Microsoft.SQLServer.Replication.Windows.CollectionRule.Distributor.Logreader | Microsoft.SQLServer.Replication.Windows.Distributor | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL on Windows Replication: Log Reader Agent: Delivered Commands per Second | The number of commands per second delivered to the Distributor. | Microsoft.SQLServer.Replication.Windows.CollectionRule.Distributor.LogreaderDeliveredCmdsPerSec | Microsoft.SQLServer.Replication.Windows.Distributor | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL on Windows Replication: Log Reader Agent: Delivery Latency | The current amount of time (in milliseconds) elapsed from when transactions are applied at the Publisher to when they are delivered to the Distributor. | Microsoft.SQLServer.Replication.Windows.CollectionRule.Distributor.LogreaderDeliveredLatency | Microsoft.SQLServer.Replication.Windows.Distributor | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL on Windows Replication: Log Reader Agent: Delivered Transactions per Second | The number of transactions per second delivered to the Distributor. | Microsoft.SQLServer.Replication.Windows.CollectionRule.Distributor.LogreaderDeliveredTransPerSec | Microsoft.SQLServer.Replication.Windows.Distributor | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL on Windows Replication: Count of the Merge Agent Instances for the Distributor | Count of the Merge Agent Instances for the Distributor. | Microsoft.SQLServer.Replication.Windows.CollectionRule.Distributor.Merge | Microsoft.SQLServer.Replication.Windows.Distributor | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL on Windows Replication: Deactivated Subscriptions (\%) | The percentage of Deactivated Subscriptions for the Distributor | Microsoft.SQLServer.Replication.Windows.CollectionRule.Distributor.PercentOfDeactivatedSubscriptionsPerformanceCounter | Microsoft.SQLServer.Replication.Windows.Distributor | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL on Windows Replication: Expired Subscriptions (\%) | The Percentage of Expired Subscriptions for the Distributor | Microsoft.SQLServer.Replication.Windows.CollectionRule.Distributor.PercentOfExpiredSubscriptionsPerformanceCounter | Microsoft.SQLServer.Replication.Windows.Distributor | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL on Windows Replication: Replication Snapshot Available Space (\%) | The amount of space left on media hosting a Replication Snapshot. | Microsoft.SQLServer.Replication.Windows.CollectionRule.Distributor.PublicationSnapshotFreeSpacePerformanceCounter | Microsoft.SQLServer.Replication.Windows.Distributor | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL on Windows Replication: Count of the Queue Reader Instances for the Distributor | Count of the Queue Reader Instances for the Distributor. | Microsoft.SQLServer.Replication.Windows.CollectionRule.Distributor.Queuereader | Microsoft.SQLServer.Replication.Windows.Distributor | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL on Windows Replication: Count of Failed Replication Agents Jobs on the Distributor | This rule collects the following failed Replication agent jobs: Merge, Distribution and Snapshot agents. | Microsoft.SQLServer.Replication.Windows.CollectionRule.Distributor.ReplicationAgentFailJobsPerformanceCounter | Microsoft.SQLServer.Replication.Windows.Distributor | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL on Windows Replication: Count of the Snapshot Agents Instances for the Distributor | Count of the Snapshot Agent Instances for the Distributor. | Microsoft.SQLServer.Replication.Windows.CollectionRule.Distributor.Snapshot | Microsoft.SQLServer.Replication.Windows.Distributor | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL on Windows Replication: Snapshot Agent: Delivered Commands per Second | The number of commands per second delivered to the Distributor. | Microsoft.SQLServer.Replication.Windows.CollectionRule.Distributor.SnapshotDeliveredCmdsPerSec | Microsoft.SQLServer.Replication.Windows.Distributor | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL on Windows Replication: Snapshot Agent: Delivered Transactions per Second | The number of transactions per second delivered to the Distributor. | Microsoft.SQLServer.Replication.Windows.CollectionRule.Distributor.SnapshotDeliveredTransPerSec | Microsoft.SQLServer.Replication.Windows.Distributor | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL on Windows Replication: Merge Agent: Uploaded Changes per Second | The number of rows per second replicated from the Subscriber to the Publisher. | Microsoft.SQLServer.Replication.Windows.CollectionRule.Distributor.UnloadedChangesPerSec | Microsoft.SQLServer.Replication.Windows.Distributor | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL on Windows Replication: Count of Publications for the Publisher | Count of Publications for the Publisher. | Microsoft.SQLServer.Replication.Windows.CollectionRule.Publisher.PublisherPublicationsPerformanceCounter | Microsoft.SQLServer.Replication.Windows.Publisher | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL on Windows Replication: Count of the Failed Replication Jobs for the Subscriber | Count of the Failed Replication Jobs for the Subscriber | Microsoft.SQLServer.Replication.Windows.CollectionRule.Subscriber.SubscriberFailJobsPerformanceCounter | Microsoft.SQLServer.Replication.Windows.Subscriber | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL on Windows Replication: Count of Subscriptions for the Subscriber | Count of Subscriptions for the Subscriber. | Microsoft.SQLServer.Replication.Windows.CollectionRule.Subscriber.SubscriberSubscriptionsPerformanceCounter | Microsoft.SQLServer.Replication.Windows.Subscriber | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL on Windows Replication: Count of Pending Commands | Count of commands pending replication in distribution database for the Subscription. Note that this rule is disabled for Merge Subscriptions. | Microsoft.SQLServer.Replication.Windows.CollectionRule.Subscription.SubscriptionPendingCmdsPerformanceCounter | Microsoft.SQLServer.Replication.Windows.Subscription | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL on Windows Replication: The Maintenance Job(s) Failed on Distributor Alert Rule | The Maintenance Job(s) Failed on Distributor Alert Rule | Microsoft.SQLServer.Replication.Windows.DistributorFailedMaintenanceJobsAlertRule | Microsoft.SQLServer.Replication.Windows.Distributor | Alert | True | | | 0 | 0 | | True | Error | High | True | |
| MSSQL on Windows Replication: Monitoring Error | The rule traces monitoring workflows errors and generates error alerts. | Microsoft.SQLServer.Replication.Windows.Rule.MonitoringPoolAlertCollection.MonitoringError | Microsoft.SQLServer.Replication.Windows.MonitoringPoolAlertCollection | Alert | True | | | 0 | 0 | | True | Error | Normal | True | Operations Manager |
| MSSQL on Windows Replication: Monitoring Warning | The rule traces monitoring workflows warnings and generates error alerts. | Microsoft.SQLServer.Replication.Windows.Rule.MonitoringPoolAlertCollection.MonitoringWarning | Microsoft.SQLServer.Replication.Windows.MonitoringPoolAlertCollection | Alert | True | | | 0 | 0 | | True | Warning | Normal | True | Operations Manager |
Home