| | 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 2016 Replication: Merge Agent: Conflicts per Second | The number of conflicts per second occurring during the merge process. | Microsoft.SQLServer.2016.Replication.CollectionRule.Distributor.ConflictsPerSec | Microsoft.SQLServer.2016.Replication.Distributor | PerformanceCollection | True | $Target/Property[Type="MSRL!Microsoft.SQLServer.Replication.Library.GenericDistributor"]/PerformanceCounterObject$:Replication Merge | Conflicts/sec | 900 | 0 | | False | | | True | |
| MSSQL 2016 Replication: Count of Publications for the Distributor | Count of Publications for the Distributor. | Microsoft.SQLServer.2016.Replication.CollectionRule.Distributor.CountOfPublicationsPerformanceCounter | Microsoft.SQLServer.2016.Replication.Distributor | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL 2016 Replication: Count of Subscriptions for the Distributor | Count of Subscriptions for the Distributor. | Microsoft.SQLServer.2016.Replication.CollectionRule.Distributor.CountOfSubscriptionsPerformanceCounter | Microsoft.SQLServer.2016.Replication.Distributor | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL 2016 Replication: Count of Unsynchronized Subscriptions for the Distributor | Count of unsynchronized subscriptions for the Distributor | Microsoft.SQLServer.2016.Replication.CollectionRule.Distributor.CountOfUnsyncSubscriptionsPerformanceCounter | Microsoft.SQLServer.2016.Replication.Distributor | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL 2016 Replication: Distribution Agent: Delivered Commands per Second | The number of commands per second delivered to the Subscriber. | Microsoft.SQLServer.2016.Replication.CollectionRule.Distributor.DeliveredCmdsPerSec | Microsoft.SQLServer.2016.Replication.Distributor | PerformanceCollection | True | $Target/Property[Type="MSRL!Microsoft.SQLServer.Replication.Library.GenericDistributor"]/PerformanceCounterObject$:Replication Dist. | Dist:Delivered Cmds/sec | 900 | 0 | | False | | | True | |
| MSSQL 2016 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.2016.Replication.CollectionRule.Distributor.DeliveredLatency | Microsoft.SQLServer.2016.Replication.Distributor | PerformanceCollection | True | $Target/Property[Type="MSRL!Microsoft.SQLServer.Replication.Library.GenericDistributor"]/PerformanceCounterObject$:Replication Dist. | Dist:Delivery Latency | 900 | 0 | | False | | | True | |
| MSSQL 2016 Replication: Distribution Agent: Delivered Transactions per Second | The number of transactions per second delivered to the Subscriber. | Microsoft.SQLServer.2016.Replication.CollectionRule.Distributor.DeliveredTransPerSec | Microsoft.SQLServer.2016.Replication.Distributor | PerformanceCollection | True | $Target/Property[Type="MSRL!Microsoft.SQLServer.Replication.Library.GenericDistributor"]/PerformanceCounterObject$:Replication Dist. | Dist:Delivered Trans/sec | 900 | 0 | | False | | | True | |
| MSSQL 2016 Replication: Count of the Distribution Agent Instances for the Distributor | Count of the Distribution Agent Instances for the Distributor | Microsoft.SQLServer.2016.Replication.CollectionRule.Distributor.Distribution | Microsoft.SQLServer.2016.Replication.Distributor | PerformanceCollection | True | $Target/Property[Type="MSRL!Microsoft.SQLServer.Replication.Library.GenericDistributor"]/PerformanceCounterObject$:Replication Agents | Running | 900 | 0 | | False | | | True | |
| MSSQL 2016 Replication: Count of Pending Commands in the Distribution Database | Count of commands in the Distribution database pending replication. | Microsoft.SQLServer.2016.Replication.CollectionRule.Distributor.DistributionDBPendingCmdsPerformanceCounter | Microsoft.SQLServer.2016.Replication.Distributor | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL 2016 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.2016.Replication.CollectionRule.Distributor.DownloadChangesPerSec | Microsoft.SQLServer.2016.Replication.Distributor | PerformanceCollection | True | $Target/Property[Type="MSRL!Microsoft.SQLServer.Replication.Library.GenericDistributor"]/PerformanceCounterObject$:Replication Merge | Downloaded Changes/sec | 900 | 0 | | False | | | True | |
| MSSQL 2016 Replication: Count of the Log Reader Agent Instances for the Distributor | Count of the Log Reader Agent Instances for the Distributor. | Microsoft.SQLServer.2016.Replication.CollectionRule.Distributor.Logreader | Microsoft.SQLServer.2016.Replication.Distributor | PerformanceCollection | True | $Target/Property[Type="MSRL!Microsoft.SQLServer.Replication.Library.GenericDistributor"]/PerformanceCounterObject$:Replication Agents | Running | 900 | 0 | | False | | | True | |
| MSSQL 2016 Replication: Log Reader Agent: Delivered Commands per Second | The number of commands per second delivered to the Distributor. | Microsoft.SQLServer.2016.Replication.CollectionRule.Distributor.LogreaderDeliveredCmdsPerSec | Microsoft.SQLServer.2016.Replication.Distributor | PerformanceCollection | True | $Target/Property[Type="MSRL!Microsoft.SQLServer.Replication.Library.GenericDistributor"]/PerformanceCounterObject$:Replication Logreader | Logreader:Delivered Cmds/sec | 900 | 0 | | False | | | True | |
| MSSQL 2016 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.2016.Replication.CollectionRule.Distributor.LogreaderDeliveredLatency | Microsoft.SQLServer.2016.Replication.Distributor | PerformanceCollection | True | $Target/Property[Type="MSRL!Microsoft.SQLServer.Replication.Library.GenericDistributor"]/PerformanceCounterObject$:Replication Logreader | Logreader:Delivery Latency | 900 | 0 | | False | | | True | |
| MSSQL 2016 Replication: Log Reader Agent: Delivered Transactions per Second | The number of transactions per second delivered to the Distributor. | Microsoft.SQLServer.2016.Replication.CollectionRule.Distributor.LogreaderDeliveredTransPerSec | Microsoft.SQLServer.2016.Replication.Distributor | PerformanceCollection | True | $Target/Property[Type="MSRL!Microsoft.SQLServer.Replication.Library.GenericDistributor"]/PerformanceCounterObject$:Replication Logreader | Logreader:Delivered Trans/sec | 900 | 0 | | False | | | True | |
| MSSQL 2016 Replication: Count of the Merge Agent Instances for the Distributor | Count of the Merge Agent Instances for the Distributor. | Microsoft.SQLServer.2016.Replication.CollectionRule.Distributor.Merge | Microsoft.SQLServer.2016.Replication.Distributor | PerformanceCollection | True | $Target/Property[Type="MSRL!Microsoft.SQLServer.Replication.Library.GenericDistributor"]/PerformanceCounterObject$:Replication Agents | Running | 900 | 0 | | False | | | True | |
| MSSQL 2016 Replication: Deactivated Subscriptions (\%) | The percentage of Deactivated Subscriptions for the Distributor | Microsoft.SQLServer.2016.Replication.CollectionRule.Distributor.PercentOfDeactivatedSubscriptionsPerformanceCounter | Microsoft.SQLServer.2016.Replication.Distributor | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL 2016 Replication: Expired Subscriptions (\%) | The Percentage of Expired Subscriptions for the Distributor | Microsoft.SQLServer.2016.Replication.CollectionRule.Distributor.PercentOfExpiredSubscriptionsPerformanceCounter | Microsoft.SQLServer.2016.Replication.Distributor | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL 2016 Replication: Replication Snapshot Available Space (\%) | The amount of space left on media hosting a Replication Snapshot. | Microsoft.SQLServer.2016.Replication.CollectionRule.Distributor.PublicationSnapshotFreeSpacePerformanceCounter | Microsoft.SQLServer.2016.Replication.Distributor | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL 2016 Replication: Count of the Queue Reader Instances for the Distributor | Count of the Queue Reader Instances for the Distributor. | Microsoft.SQLServer.2016.Replication.CollectionRule.Distributor.Queuereader | Microsoft.SQLServer.2016.Replication.Distributor | PerformanceCollection | True | $Target/Property[Type="MSRL!Microsoft.SQLServer.Replication.Library.GenericDistributor"]/PerformanceCounterObject$:Replication Agents | Running | 900 | 0 | | False | | | True | |
| MSSQL 2016 Replication: Count of Failed Replication Agents Jobs on the Distributor | Count of Failed Replication Agents Jobs on the Distributor | Microsoft.SQLServer.2016.Replication.CollectionRule.Distributor.ReplicationAgentFailJobsPerformanceCounter | Microsoft.SQLServer.2016.Replication.Distributor | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL 2016 Replication: Count of the Snapshot Agents Instances for the Distributor | Count of the Snapshot Agent Instances for the Distributor. | Microsoft.SQLServer.2016.Replication.CollectionRule.Distributor.Snapshot | Microsoft.SQLServer.2016.Replication.Distributor | PerformanceCollection | True | $Target/Property[Type="MSRL!Microsoft.SQLServer.Replication.Library.GenericDistributor"]/PerformanceCounterObject$:Replication Agents | Running | 900 | 0 | | False | | | True | |
| MSSQL 2016 Replication: Snapshot Agent: Delivered Commands per Second | The number of commands per second delivered to the Distributor. | Microsoft.SQLServer.2016.Replication.CollectionRule.Distributor.SnapshotDeliveredCmdsPerSec | Microsoft.SQLServer.2016.Replication.Distributor | PerformanceCollection | True | $Target/Property[Type="MSRL!Microsoft.SQLServer.Replication.Library.GenericDistributor"]/PerformanceCounterObject$:Replication Snapshot | Snapshot:Delivered Cmds/sec | 900 | 0 | | False | | | True | |
| MSSQL 2016 Replication: Snapshot Agent: Delivered Transactions per Second | The number of transactions per second delivered to the Distributor. | Microsoft.SQLServer.2016.Replication.CollectionRule.Distributor.SnapshotDeliveredTransPerSec | Microsoft.SQLServer.2016.Replication.Distributor | PerformanceCollection | True | $Target/Property[Type="MSRL!Microsoft.SQLServer.Replication.Library.GenericDistributor"]/PerformanceCounterObject$:Replication Snapshot | Snapshot:Delivered Trans/sec | 900 | 0 | | False | | | True | |
| MSSQL 2016 Replication: Merge Agent: Uploaded Changes per Second | The number of rows per second replicated from the Subscriber to the Publisher. | Microsoft.SQLServer.2016.Replication.CollectionRule.Distributor.UnloadedChangesPerSec | Microsoft.SQLServer.2016.Replication.Distributor | PerformanceCollection | True | $Target/Property[Type="MSRL!Microsoft.SQLServer.Replication.Library.GenericDistributor"]/PerformanceCounterObject$:Replication Merge | Uploaded Changes/sec | 900 | 0 | | False | | | True | |
| MSSQL 2016 Replication: Count of Publications for the Publisher | Count of Publications for the Publisher. | Microsoft.SQLServer.2016.Replication.CollectionRule.Publisher.PublisherPublicationsPerformanceCounter | Microsoft.SQLServer.2016.Replication.Publisher | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL 2016 Replication: Count of the Failed Replication Jobs for the Subscriber | Count of the Failed Replication Jobs for the Subscriber | Microsoft.SQLServer.2016.Replication.CollectionRule.Subscriber.SubscriberFailJobsPerformanceCounter | Microsoft.SQLServer.2016.Replication.Subscriber | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL 2016 Replication: Count of Subscriptions for the Subscriber | Count of Subscriptions for the Subscriber. | Microsoft.SQLServer.2016.Replication.CollectionRule.Subscriber.SubscriberSubscriptionsPerformanceCounter | Microsoft.SQLServer.2016.Replication.Subscriber | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL 2016 Replication: Count of Pending Commands | Count of commands pending replication in distribution database for the Subscription. | Microsoft.SQLServer.2016.Replication.CollectionRule.Subscription.SubscriptionPendingCmdsPerformanceCounter | Microsoft.SQLServer.2016.Replication.Subscription | PerformanceCollection | True | | | 0 | 0 | | False | | | True | |
| MSSQL 2016 Replication: The Maintenance Job(s) Failed on Distributor Alert Rule | The Maintenance Job(s) Failed on Distributor Alert Rule | Microsoft.SQLServer.2016.Replication.DistributorFailedMaintenanceJobsAlertRule | Microsoft.SQLServer.2016.Replication.Distributor | Alert | True | | | 0 | 0 | | True | Error | High | True | |
| MSSQL 2016 Replication: Replication Management Pack Module Error Event Alert Rule | Microsoft SQL Server 2016 Replication Management Pack Module Error Event Alert Rule | Microsoft.SQLServer.2016.Replication.ModuleErrorEvent | Microsoft.SQLServer.2016.Replication.EventLogCollectionTarget | Alert | True | | | 0 | 6202 | SQL Server 2016 Replication MP | True | Error | High | True | Operations Manager |
Home