This Management Pack enables the monitoring of Microsoft SQL Server 2017+ on Windows Replication and depends on the Microsoft SQL Server 2017+ on Windows Replication (Discovery) Management Pack.
Microsoft SQL Server 2017+ on Windows Replication (Monitoring) Management Pack will monitor Microsoft SQL Server 2017+ on Windows Replication specific objects.
| DisplayName | ID | Isolation | Accessibility | |
|---|---|---|---|---|
 | MSSQL on Windows Replication: Database Availability Data Source | Microsoft.SQLServer.Replication.Windows.DataSource.DbAvailabilityMonitor | Any | Internal |
| MSSQL on Windows Replication: Distributor: Load Monitor Data Source | Microsoft.SQLServer.Replication.Windows.DataSource.DistributorAgentsLoad | Any | Internal |
| MSSQL on Windows Replication: Distribution Database Availability Data Source | Microsoft.SQLServer.Replication.Windows.DataSource.DistributorAvailabilityFromSubscriber | Any | Internal |
| MSSQL on Windows Replication: Distributor: Fail Jobs Monitor Data Source | Microsoft.SQLServer.Replication.Windows.DataSource.DistributorFailJobsMonitor | Any | Internal |
| MSSQL on Windows Replication: Distributor: Pending Commands Data Source | Microsoft.SQLServer.Replication.Windows.DataSource.DistributorPendingCmdsMonitor | Any | Internal |
| MSSQL on Windows Replication: Distributor: Percentage of Deactivated Subscriptions Data Source | Microsoft.SQLServer.Replication.Windows.DataSource.DistributorPercentOfDeactivatedSubscriptionsMonitor | Any | Internal |
| MSSQL on Windows Replication: Distributor: Percentage of Expired Subscriptions Data Source | Microsoft.SQLServer.Replication.Windows.DataSource.DistributorPercentOfExpiredSubscriptionsMonitor | Any | Internal |
| MSSQL on Windows Replication: Distributor: Publications Performance Counter Data Source | Microsoft.SQLServer.Replication.Windows.DataSource.DistributorPublicationsPerformanceCounter | Any | Internal |
| MSSQL on Windows Replication: Distributor Securables Config | Microsoft.SQLServer.Replication.Windows.DataSource.DistributorSecurablesConfig | Any | Internal |
| MSSQL on Windows Replication: Distributor: Snapshot Free Space Data Source | Microsoft.SQLServer.Replication.Windows.DataSource.DistributorSnapshotFreeSpace | Any | Internal |
| MSSQL on Windows Replication: Distributor: Subscriptions Performance Counter Data Source | Microsoft.SQLServer.Replication.Windows.DataSource.DistributorSubscriptionsPerformanceCounter | Any | Internal |
| MSSQL on Windows Replication: Distributor: Unsynchronized Subscriptions Data Source | Microsoft.SQLServer.Replication.Windows.DataSource.DistributorUnsyncSubscriptionsMonitor | Any | Internal |
| MSSQL on Windows Replication: All Subscriptions are Synchronizing for Publication Data Source | Microsoft.SQLServer.Replication.Windows.DataSource.PublicationSubscriptionSyncStatus | Any | Internal |
| MSSQL on Windows Replication: Subscription Synchronization Status for Publication Cookdown Data Source | Microsoft.SQLServer.Replication.Windows.DataSource.PublicationSubscriptionSyncStatusCookdown | Any | Internal |
| MSSQL on Windows Replication: Publisher Publications Performance Counter Data Source | Microsoft.SQLServer.Replication.Windows.DataSource.PublisherPublicationsPerformanceCounter | Any | Internal |
| MSSQL on Windows Replication: Publisher Securables Config | Microsoft.SQLServer.Replication.Windows.DataSource.PublisherSecurablesConfig | Any | Internal |
| MSSQL on Windows Replication: the Subscriptions for Publisher Data Source | Microsoft.SQLServer.Replication.Windows.DataSource.PublisherSubscriptionsMonitor | Any | Internal |
| MSSQL on Windows Replication: Replication Agent State Data Source | Microsoft.SQLServer.Replication.Windows.DataSource.ReplicationAgentState | Any | Internal |
| MSSQL on Windows Replication: Replication Agent State Universal Data Source | Microsoft.SQLServer.Replication.Windows.DataSource.ReplicationAgentStateUniversal | Any | Internal |
| MSSQL on Windows Replication: SQL Server OS Performance Data Source | Microsoft.SQLServer.Replication.Windows.DataSource.SqlOsPerformanceReader | Any | Internal |
| MSSQL on Windows Replication: Sql Service Status Data Source | Microsoft.SQLServer.Replication.Windows.DataSource.SqlServiceStatus | Any | Internal |
| MSSQL on Windows Replication: Subscriber Securables Config | Microsoft.SQLServer.Replication.Windows.DataSource.SubscriberSecurablesConfig | Any | Internal |
| MSSQL on Windows Replication: the Subscriptions Performance Counter for Subscriber Data Source | Microsoft.SQLServer.Replication.Windows.DataSource.SubscriberSubscriptionsPerformanceCounter | Any | Internal |
| MSSQL on Windows Replication: Subscription Long Estimated Time Data Source | Microsoft.SQLServer.Replication.Windows.DataSource.SubscriptionLongEstimatedTime | Any | Internal |
| MSSQL on Windows Replication: Subscription Long Estimated Time Cookdown Data Source | Microsoft.SQLServer.Replication.Windows.DataSource.SubscriptionLongEstimatedTimeCookdownDataSource | Any | Internal |
| MSSQL on Windows Replication: Subscription Pending Commands Data Source | Microsoft.SQLServer.Replication.Windows.DataSource.SubscriptionPendingCmdsMonitor | Any | Internal |
| MSSQL on Windows Replication: Pending Commands in Distribution Database for Subscription Cookdown Data Source | Microsoft.SQLServer.Replication.Windows.DataSource.SubscriptionPendingCmdsMonitorCookdownDataSource | Any | Internal |
| MSSQL on Windows Replication: Replication SqlOsPerfCounterReaderHelper ProbeAction | Microsoft.SQLServer.Replication.Windows.ProbeAction.SqlOsPerfCounterReaderHelper | Any | Internal |
| DisplayName | ID | Isolation | Accessibility | |
|---|---|---|---|---|
 | MSSQL on Windows Replication: Database Availability Probe Action | Microsoft.SQLServer.Replication.Windows.ProbeAction.DbAvailabilityMonitor | Any | Internal |
| MSSQL on Windows Replication: Distributor Load Probe Action | Microsoft.SQLServer.Replication.Windows.ProbeAction.DistributorAgentsLoad | Any | Internal |
| MSSQL on Windows Replication: Distributor Availability from Subscriber Probe Action | Microsoft.SQLServer.Replication.Windows.ProbeAction.DistributorAvailabilityFromSubscriber | Any | Internal |
| MSSQL on Windows Replication: Distributor Failed Jobs Probe Action | Microsoft.SQLServer.Replication.Windows.ProbeAction.DistributorFailJobsMonitor | Any | Internal |
| MSSQL on Windows Replication: Distributor Pending Commands Probe Action | Microsoft.SQLServer.Replication.Windows.ProbeAction.DistributorPendingCmdsMonitor | Any | Internal |
| MSSQL on Windows Replication: Distributor Percent of Deactivated Subscriptions Probe Action | Microsoft.SQLServer.Replication.Windows.ProbeAction.DistributorPercentOfDeactivatedSubscriptionsMonitor | Any | Internal |
| MSSQL on Windows Replication: Distributor Percent of Expired Subscriptions Probe Action | Microsoft.SQLServer.Replication.Windows.ProbeAction.DistributorPercentOfExpiredSubscriptionsMonitor | Any | Internal |
| MSSQL on Windows Replication: Distributor Performance Counter Probe Action | Microsoft.SQLServer.Replication.Windows.ProbeAction.DistributorPublicationsPerformanceCounter | Any | Internal |
| MSSQL on Windows Replication: Distributor SecurablesConfigMonitor Probe Action | Microsoft.SQLServer.Replication.Windows.ProbeAction.DistributorSecurablesConfig | Any | Internal |
| MSSQL on Windows Replication: Distributor Snapshot Free Space | Microsoft.SQLServer.Replication.Windows.ProbeAction.DistributorSnapshotFreeSpace | Any | Internal |
| MSSQL on Windows Replication: Distributor Performance Counter Probe Action | Microsoft.SQLServer.Replication.Windows.ProbeAction.DistributorSubscriptionsPerformanceCounter | Any | Internal |
| MSSQL on Windows Replication: Distributor Pending Unsynchronized Subscriptions Action | Microsoft.SQLServer.Replication.Windows.ProbeAction.DistributorUnsyncSubscriptionsMonitor | Any | Internal |
| MSSQL on Windows Replication: Property Bag Mapper Probe Action | Microsoft.SQLServer.Replication.Windows.ProbeAction.PropertyBagMapperProbeAction | Any | Internal |
| MSSQL on Windows Replication: All subscriptions are synchronizing Probe Action | Microsoft.SQLServer.Replication.Windows.ProbeAction.PublicationSubscriptionSyncStatus | Any | Internal |
| MSSQL on Windows Replication: Publisher Publications Performance Counter Probe Action | Microsoft.SQLServer.Replication.Windows.ProbeAction.PublisherPublicationsPerformanceCounter | Any | Internal |
| MSSQL on Windows Replication: Publisher SecurablesConfigMonitor Probe Action | Microsoft.SQLServer.Replication.Windows.ProbeAction.PublisherSecurablesConfig | Any | Internal |
| MSSQL on Windows Replication: Publisher Subscriptions Performance Counter Probe Action | Microsoft.SQLServer.Replication.Windows.ProbeAction.PublisherSubscriptionsMonitorProbeAction | Any | Internal |
| MSSQL on Windows Replication: MSSQL on Windows Replication: Replication Agent State Probe Action | Microsoft.SQLServer.Replication.Windows.ProbeAction.ReplicationAgentStateUniversal | Any | Internal |
| MSSQL on Windows Replication: SQL Service Status Probe Action | Microsoft.SQLServer.Replication.Windows.ProbeAction.SqlServiceStatus | Any | Internal |
| MSSQL on Windows Replication: Subscriber SecurablesConfigMonitor Probe Action | Microsoft.SQLServer.Replication.Windows.ProbeAction.SubscriberSecurablesConfig | Any | Internal |
| MSSQL on Windows Replication: Subscriber Subscriptions Performance Counter Probe Action | Microsoft.SQLServer.Replication.Windows.ProbeAction.SubscriberSubscriptionsPerformanceCounter | Any | Internal |
| MSSQL on Windows Replication: Subscription Long Estimated Time | Microsoft.SQLServer.Replication.Windows.ProbeAction.SubscriptionLongEstimatedTime | Any | Internal |
| MSSQL on Windows Replication: Subscription Pending Commands Probe Action | Microsoft.SQLServer.Replication.Windows.ProbeAction.SubscriptionPendingCmdsMonitor | Any | Internal |
| DisplayName | ID | Accessibility | Support Monitor Recalculate | |
|---|---|---|---|---|
 | MSSQL on Windows Replication: Database Connection Monitor Type | Microsoft.SQLServer.Replication.Windows.MonitorType.DBConnectionMonitor | Internal | False |
| MSSQL on Windows Replication: Fail Jobs for Distributor Monitor Type | Microsoft.SQLServer.Replication.Windows.MonitorType.DistributorAgentsLoad | Public | False |
| MSSQL on Windows Replication: The Distribution Database Availability from Subscriber Monitor Type | Microsoft.SQLServer.Replication.Windows.MonitorType.DistributorAvailabilityFromSubscriberMonitorType | Internal | False |
| MSSQL on Windows Replication: Fail Jobs for Distributor Monitor Type | Microsoft.SQLServer.Replication.Windows.MonitorType.DistributorFailJobs | Public | False |
| MSSQL on Windows Replication: Pending Commands for Distributor Monitor Type | Microsoft.SQLServer.Replication.Windows.MonitorType.DistributorPendingCmds | Internal | False |
| MSSQL on Windows Replication: Percentage of Deactivated Subscriptions for Distributor Monitor Type | Microsoft.SQLServer.Replication.Windows.MonitorType.DistributorPercentOfDeactivatedSubscriptions | Internal | False |
| MSSQL on Windows Replication: Percentage of Expired Subscriptions for Distributor Monitor Type | Microsoft.SQLServer.Replication.Windows.MonitorType.DistributorPercentOfExpiredSubscriptions | Internal | False |
| MSSQL on Windows: Securables Configuration Status | Microsoft.SQLServer.Replication.Windows.MonitorType.DistributorSecurablesConfig | Internal | False |
| MSSQL on Windows Replication: Snapshot Free Space for Distributor Monitor Type | Microsoft.SQLServer.Replication.Windows.MonitorType.DistributorSnapshotFreeSpace | Public | False |
| MSSQL on Windows Replication: Unsynchronized Subscriptions for Distributor Monitor Type | Microsoft.SQLServer.Replication.Windows.MonitorType.DistributorUnsyncSubscriptions | Public | False |
| MSSQL on Windows Replication: Subscription Synchronization Status for Publication Monitor Type | Microsoft.SQLServer.Replication.Windows.MonitorType.PublicationSubscriptionSyncStatus | Internal | False |
| MSSQL on Windows: Securables Configuration Status | Microsoft.SQLServer.Replication.Windows.MonitorType.PublisherSecurablesConfig | Internal | False |
| MSSQL on Windows Replication: Publisher Subscriptions Monitor Type | Microsoft.SQLServer.Replication.Windows.MonitorType.PublisherSubscriptionsMonitor | Public | False |
| MSSQL on Windows Replication: Replication Agent State Monitor Type | Microsoft.SQLServer.Replication.Windows.MonitorType.ReplicationAgentState | Internal | False |
| MSSQL on Windows Replication: SQL Service Status | Microsoft.SQLServer.Replication.Windows.MonitorType.SqlServiceStatus | Internal | False |
| MSSQL on Windows: Securables Configuration Status | Microsoft.SQLServer.Replication.Windows.MonitorType.SubscriberSecurablesConfig | Internal | False |
| MSSQL on Windows Replication: Subscription Long Estimated Time Monitor Type | Microsoft.SQLServer.Replication.Windows.MonitorType.SubscriptionLongEstimatedTime | Public | False |
| MSSQL on Windows Replication: Subscription Pending Commands Monitor Type | Microsoft.SQLServer.Replication.Windows.MonitorType.SubscriptionPendingCmds | Public | False |
| ID | Accessibility | |
|---|---|---|
 | Microsoft.SQLServer.Replication.Windows.DataSource.SqlOsPerfReaderSchema | Internal |
| DisplayName | ID | Target | Category | Enabled | Alert Generate | Accessibility | |
|---|---|---|---|---|---|---|---|
 | Distribution Agents state (aggregated for all Publications) | Microsoft.SQLServer.Replication.Windows.Monitor.DistributionAgentState | Microsoft.SQLServer.Replication.Windows.Distributor | PerformanceHealth | True | True | Public |
| Availability of the Distribution database | Microsoft.SQLServer.Replication.Windows.Monitor.DistributionDBAvailability | Microsoft.SQLServer.Replication.Windows.Distributor | AvailabilityHealth | True | True | Public |
| Availability of the Distribution database from a Subscriber | Microsoft.SQLServer.Replication.Windows.Monitor.DistributionDBAvailabilityFromSubscriber | Microsoft.SQLServer.Replication.Windows.Distributor | AvailabilityHealth | False | True | Public |
| Pending Commands on Distributor | Microsoft.SQLServer.Replication.Windows.Monitor.DistributionDBPendingCmds | Microsoft.SQLServer.Replication.Windows.Distributor | PerformanceHealth | True | True | Public |
| SQL Server Agent State for Distributor | Microsoft.SQLServer.Replication.Windows.Monitor.Distributor.SQLServerAgentState | Microsoft.SQLServer.Replication.Windows.Distributor | AvailabilityHealth | True | True | Public |
| Distributor Securables Configuration Status | Microsoft.SQLServer.Replication.Windows.Monitor.DistributorSecurablesConfigMonitor | Microsoft.SQLServer.Replication.Windows.Distributor | AvailabilityHealth | True | True | Public |
| Replication Log Reader Agent State for the Distributor (aggregated for all Publications) | Microsoft.SQLServer.Replication.Windows.Monitor.LogReaderAgentState | Microsoft.SQLServer.Replication.Windows.Distributor | PerformanceHealth | True | True | Public |
| Replication Merge Agent State for the Distributor (aggregated for all Subscriptions) | Microsoft.SQLServer.Replication.Windows.Monitor.MergeAgentState | Microsoft.SQLServer.Replication.Windows.Distributor | PerformanceHealth | True | True | Public |
| Percent of Deactivated Subscriptions | Microsoft.SQLServer.Replication.Windows.Monitor.PercentOfDeactivatedSubscriptions | Microsoft.SQLServer.Replication.Windows.Distributor | PerformanceHealth | True | True | Public |
| Percent of Expired Subscriptions | Microsoft.SQLServer.Replication.Windows.Monitor.PercentOfExpiredSubscriptions | Microsoft.SQLServer.Replication.Windows.Distributor | PerformanceHealth | True | True | Public |
| Replication Log Reader Agent State for Publication | Microsoft.SQLServer.Replication.Windows.Monitor.PublicationLogReaderAgentState | Microsoft.SQLServer.Replication.Windows.Publication | PerformanceHealth | True | True | Internal |
| Replication Snapshot Agent State | Microsoft.SQLServer.Replication.Windows.Monitor.PublicationSnapshotAgentState | Microsoft.SQLServer.Replication.Windows.Publication | PerformanceHealth | True | True | Public |
| Publication Snapshot Available Space | Microsoft.SQLServer.Replication.Windows.Monitor.PublicationSnapshotFreeSpace | Microsoft.SQLServer.Replication.Windows.Distributor | PerformanceHealth | True | True | Public |
| All Subscriptions are Synchronizing for Publication | Microsoft.SQLServer.Replication.Windows.Monitor.PublicationSubscriptionSyncStatusMonitor | Microsoft.SQLServer.Replication.Windows.Publication | PerformanceHealth | True | True | Public |
| SQL Server Agent State for Publisher | Microsoft.SQLServer.Replication.Windows.Monitor.Publisher.SQLServerAgentState | Microsoft.SQLServer.Replication.Windows.Publisher | AvailabilityHealth | True | True | Public |
| Publisher Securables Configuration Status | Microsoft.SQLServer.Replication.Windows.Monitor.PublisherSecurablesConfigMonitor | Microsoft.SQLServer.Replication.Windows.Publisher | AvailabilityHealth | True | True | Public |
| Subscriptions state for Publisher | Microsoft.SQLServer.Replication.Windows.Monitor.PublisherSubscriptionsMonitor | Microsoft.SQLServer.Replication.Windows.Publisher | PerformanceHealth | True | True | Public |
| Replication Queue Reader Agent State for Distributor (aggregated for all Publications) | Microsoft.SQLServer.Replication.Windows.Monitor.QueueReaderAgentState | Microsoft.SQLServer.Replication.Windows.Distributor | PerformanceHealth | False | True | Public |
| Replication Agents failed on the Distributor | Microsoft.SQLServer.Replication.Windows.Monitor.ReplicationAgentFailJobs | Microsoft.SQLServer.Replication.Windows.Distributor | PerformanceHealth | True | True | Public |
| One or more of the Replication Agents are retrying on the Distributor | Microsoft.SQLServer.Replication.Windows.Monitor.ReplicationAgentIsRetrying | Microsoft.SQLServer.Replication.Windows.Distributor | PerformanceHealth | True | True | Public |
| Total daily execution time of the replication agent | Microsoft.SQLServer.Replication.Windows.Monitor.ReplicationAgentsLoad | Microsoft.SQLServer.Replication.Windows.Distributor | PerformanceHealth | True | True | Public |
| Replication Snapshot Agent State for Distributor (aggregated for all Publications) | Microsoft.SQLServer.Replication.Windows.Monitor.SnapshotAgentState | Microsoft.SQLServer.Replication.Windows.Distributor | PerformanceHealth | True | True | Public |
| SQL Server Agent State for Subscriber | Microsoft.SQLServer.Replication.Windows.Monitor.Subscriber.SQLServerAgentState | Microsoft.SQLServer.Replication.Windows.Subscriber | AvailabilityHealth | True | True | Public |
| Subscriber Agent is Retrying | Microsoft.SQLServer.Replication.Windows.Monitor.SubscriberAgentIsRetryingMonitor | Microsoft.SQLServer.Replication.Windows.Subscriber | PerformanceHealth | True | True | Public |
| Load of Replication agents on Subscriber | Microsoft.SQLServer.Replication.Windows.Monitor.SubscriberAgentsLoad | Microsoft.SQLServer.Replication.Windows.Subscriber | PerformanceHealth | True | True | Public |
| Subscriber Securables Configuration Status | Microsoft.SQLServer.Replication.Windows.Monitor.SubscriberSecurablesConfigMonitor | Microsoft.SQLServer.Replication.Windows.Subscriber | AvailabilityHealth | True | True | Public |
| Distribution Agent State for Subscription | Microsoft.SQLServer.Replication.Windows.Monitor.SubscriptionDistributionAgentState | Microsoft.SQLServer.Replication.Windows.Subscription | PerformanceHealth | True | True | Public |
| Subscription latency | Microsoft.SQLServer.Replication.Windows.Monitor.SubscriptionLongEstimatedTimeMonitor | Microsoft.SQLServer.Replication.Windows.Subscription | PerformanceHealth | True | True | Public |
| Replication Merge Agent State for Subscription | Microsoft.SQLServer.Replication.Windows.Monitor.SubscriptionMergeAgentState | Microsoft.SQLServer.Replication.Windows.Subscription | PerformanceHealth | True | True | Public |
| Subscription Pending Commands | Microsoft.SQLServer.Replication.Windows.Monitor.SubscriptionPendingCmdsMonitor | Microsoft.SQLServer.Replication.Windows.Subscription | PerformanceHealth | True | True | Public |
| Unsynchronized Subscriptions on Distributor | Microsoft.SQLServer.Replication.Windows.Monitor.UnsyncSubscriptions | Microsoft.SQLServer.Replication.Windows.Distributor | PerformanceHealth | True | True | Public |
| DisplayName | ID | Target | Category | Enabled | Alert Generate | |
|---|---|---|---|---|---|---|
 | MSSQL on Windows Replication: Merge Agent: Conflicts per Second | Microsoft.SQLServer.Replication.Windows.CollectionRule.Distributor.ConflictsPerSec | Microsoft.SQLServer.Replication.Windows.Distributor | PerformanceCollection | True | False |
| MSSQL on Windows Replication: Count of Publications for the Distributor | Microsoft.SQLServer.Replication.Windows.CollectionRule.Distributor.CountOfPublicationsPerformanceCounter | Microsoft.SQLServer.Replication.Windows.Distributor | PerformanceCollection | True | False |
| MSSQL on Windows Replication: Count of Subscriptions for the Distributor | Microsoft.SQLServer.Replication.Windows.CollectionRule.Distributor.CountOfSubscriptionsPerformanceCounter | Microsoft.SQLServer.Replication.Windows.Distributor | PerformanceCollection | True | False |
| MSSQL on Windows Replication: Count of Unsynchronized Subscriptions for the Distributor | Microsoft.SQLServer.Replication.Windows.CollectionRule.Distributor.CountOfUnsyncSubscriptionsPerformanceCounter | Microsoft.SQLServer.Replication.Windows.Distributor | PerformanceCollection | True | False |
| MSSQL on Windows Replication: Distribution Agent: Delivered Commands per Second | Microsoft.SQLServer.Replication.Windows.CollectionRule.Distributor.DeliveredCmdsPerSec | Microsoft.SQLServer.Replication.Windows.Distributor | PerformanceCollection | True | False |
| MSSQL on Windows Replication: Distribution Agent: Delivery Latency | Microsoft.SQLServer.Replication.Windows.CollectionRule.Distributor.DeliveredLatency | Microsoft.SQLServer.Replication.Windows.Distributor | PerformanceCollection | True | False |
| MSSQL on Windows Replication: Distribution Agent: Delivered Transactions per Second | Microsoft.SQLServer.Replication.Windows.CollectionRule.Distributor.DeliveredTransPerSec | Microsoft.SQLServer.Replication.Windows.Distributor | PerformanceCollection | True | False |
| MSSQL on Windows Replication: Count of the Distribution Agent Instances for the Distributor | Microsoft.SQLServer.Replication.Windows.CollectionRule.Distributor.Distribution | Microsoft.SQLServer.Replication.Windows.Distributor | PerformanceCollection | True | False |
| MSSQL on Windows Replication: Count of Pending Commands in the Distribution Database | Microsoft.SQLServer.Replication.Windows.CollectionRule.Distributor.DistributionDBPendingCmdsPerformanceCounter | Microsoft.SQLServer.Replication.Windows.Distributor | PerformanceCollection | True | False |
| MSSQL on Windows Replication: Merge Agent: Download Changes per Second | Microsoft.SQLServer.Replication.Windows.CollectionRule.Distributor.DownloadChangesPerSec | Microsoft.SQLServer.Replication.Windows.Distributor | PerformanceCollection | True | False |
| MSSQL on Windows Replication: Count of the Log Reader Agent Instances for the Distributor | Microsoft.SQLServer.Replication.Windows.CollectionRule.Distributor.Logreader | Microsoft.SQLServer.Replication.Windows.Distributor | PerformanceCollection | True | False |
| MSSQL on Windows Replication: Log Reader Agent: Delivered Commands per Second | Microsoft.SQLServer.Replication.Windows.CollectionRule.Distributor.LogreaderDeliveredCmdsPerSec | Microsoft.SQLServer.Replication.Windows.Distributor | PerformanceCollection | True | False |
| MSSQL on Windows Replication: Log Reader Agent: Delivery Latency | Microsoft.SQLServer.Replication.Windows.CollectionRule.Distributor.LogreaderDeliveredLatency | Microsoft.SQLServer.Replication.Windows.Distributor | PerformanceCollection | True | False |
| MSSQL on Windows Replication: Log Reader Agent: Delivered Transactions per Second | Microsoft.SQLServer.Replication.Windows.CollectionRule.Distributor.LogreaderDeliveredTransPerSec | Microsoft.SQLServer.Replication.Windows.Distributor | PerformanceCollection | True | False |
| MSSQL on Windows Replication: Count of the Merge Agent Instances for the Distributor | Microsoft.SQLServer.Replication.Windows.CollectionRule.Distributor.Merge | Microsoft.SQLServer.Replication.Windows.Distributor | PerformanceCollection | True | False |
| MSSQL on Windows Replication: Deactivated Subscriptions (\%) | Microsoft.SQLServer.Replication.Windows.CollectionRule.Distributor.PercentOfDeactivatedSubscriptionsPerformanceCounter | Microsoft.SQLServer.Replication.Windows.Distributor | PerformanceCollection | True | False |
| MSSQL on Windows Replication: Expired Subscriptions (\%) | Microsoft.SQLServer.Replication.Windows.CollectionRule.Distributor.PercentOfExpiredSubscriptionsPerformanceCounter | Microsoft.SQLServer.Replication.Windows.Distributor | PerformanceCollection | True | False |
| MSSQL on Windows Replication: Replication Snapshot Available Space (\%) | Microsoft.SQLServer.Replication.Windows.CollectionRule.Distributor.PublicationSnapshotFreeSpacePerformanceCounter | Microsoft.SQLServer.Replication.Windows.Distributor | PerformanceCollection | True | False |
| MSSQL on Windows Replication: Count of the Queue Reader Instances for the Distributor | Microsoft.SQLServer.Replication.Windows.CollectionRule.Distributor.Queuereader | Microsoft.SQLServer.Replication.Windows.Distributor | PerformanceCollection | True | False |
| MSSQL on Windows Replication: Count of Failed Replication Agents Jobs on the Distributor | Microsoft.SQLServer.Replication.Windows.CollectionRule.Distributor.ReplicationAgentFailJobsPerformanceCounter | Microsoft.SQLServer.Replication.Windows.Distributor | PerformanceCollection | True | False |
| MSSQL on Windows Replication: Count of the Snapshot Agents Instances for the Distributor | Microsoft.SQLServer.Replication.Windows.CollectionRule.Distributor.Snapshot | Microsoft.SQLServer.Replication.Windows.Distributor | PerformanceCollection | True | False |
| MSSQL on Windows Replication: Snapshot Agent: Delivered Commands per Second | Microsoft.SQLServer.Replication.Windows.CollectionRule.Distributor.SnapshotDeliveredCmdsPerSec | Microsoft.SQLServer.Replication.Windows.Distributor | PerformanceCollection | True | False |
| MSSQL on Windows Replication: Snapshot Agent: Delivered Transactions per Second | Microsoft.SQLServer.Replication.Windows.CollectionRule.Distributor.SnapshotDeliveredTransPerSec | Microsoft.SQLServer.Replication.Windows.Distributor | PerformanceCollection | True | False |
| MSSQL on Windows Replication: Merge Agent: Uploaded Changes per Second | Microsoft.SQLServer.Replication.Windows.CollectionRule.Distributor.UnloadedChangesPerSec | Microsoft.SQLServer.Replication.Windows.Distributor | PerformanceCollection | True | False |
| MSSQL on Windows Replication: Count of Publications for the Publisher | Microsoft.SQLServer.Replication.Windows.CollectionRule.Publisher.PublisherPublicationsPerformanceCounter | Microsoft.SQLServer.Replication.Windows.Publisher | PerformanceCollection | True | False |
| MSSQL on Windows Replication: Count of the Failed Replication Jobs for the Subscriber | Microsoft.SQLServer.Replication.Windows.CollectionRule.Subscriber.SubscriberFailJobsPerformanceCounter | Microsoft.SQLServer.Replication.Windows.Subscriber | PerformanceCollection | True | False |
| MSSQL on Windows Replication: Count of Subscriptions for the Subscriber | Microsoft.SQLServer.Replication.Windows.CollectionRule.Subscriber.SubscriberSubscriptionsPerformanceCounter | Microsoft.SQLServer.Replication.Windows.Subscriber | PerformanceCollection | True | False |
| MSSQL on Windows Replication: Count of Pending Commands | Microsoft.SQLServer.Replication.Windows.CollectionRule.Subscription.SubscriptionPendingCmdsPerformanceCounter | Microsoft.SQLServer.Replication.Windows.Subscription | PerformanceCollection | True | False |
| MSSQL on Windows Replication: The Maintenance Job(s) Failed on Distributor Alert Rule | Microsoft.SQLServer.Replication.Windows.DistributorFailedMaintenanceJobsAlertRule | Microsoft.SQLServer.Replication.Windows.Distributor | Alert | True | True |
| MSSQL on Windows Replication: Monitoring Error | Microsoft.SQLServer.Replication.Windows.Rule.MonitoringPoolAlertCollection.MonitoringError | Microsoft.SQLServer.Replication.Windows.MonitoringPoolAlertCollection | Alert | True | True |
| MSSQL on Windows Replication: Monitoring Warning | Microsoft.SQLServer.Replication.Windows.Rule.MonitoringPoolAlertCollection.MonitoringWarning | Microsoft.SQLServer.Replication.Windows.MonitoringPoolAlertCollection | Alert | True | True |
| ID | Context | Target | |
|---|---|---|---|
 | Microsoft.SQLServer.Replication.Monitor.SubscriptionLongEstimatedTimeMonitor.Enabled.Override | Microsoft.SQLServer.Replication.Core.MergeSubscriptionGroup | Microsoft.SQLServer.Replication.Windows.Monitor.SubscriptionLongEstimatedTimeMonitor |
| Microsoft.SQLServer.Replication.Monitor.SubscriptionPendingCmdsMonitor.Enabled.Override | Microsoft.SQLServer.Replication.Core.MergeSubscriptionGroup | Microsoft.SQLServer.Replication.Windows.Monitor.SubscriptionPendingCmdsMonitor |
| Microsoft.SQLServer.Replication.Windows.Monitor.Subscriber.SQLServerAgentState.Enabled.Override | Microsoft.SQLServer.Replication.Core.SubscriberExpressGroup | Microsoft.SQLServer.Replication.Windows.Monitor.Subscriber.SQLServerAgentState |
| Microsoft.SQLServer.Replication.Windows.Monitor.SubscriberAgentIsRetryingMonitor.Enabled.Override | Microsoft.SQLServer.Replication.Core.SubscriberExpressGroup | Microsoft.SQLServer.Replication.Windows.Monitor.SubscriberAgentIsRetryingMonitor |
| Microsoft.SQLServer.Replication.Windows.Monitor.SubscriberAgentsLoad.Enabled.Override | Microsoft.SQLServer.Replication.Core.SubscriberExpressGroup | Microsoft.SQLServer.Replication.Windows.Monitor.SubscriberAgentsLoad |
| Microsoft.SQLServer.Replication.Windows.Monitor.SubscriptionDistributionAgentState.Enabled.Override | Microsoft.SQLServer.Replication.Core.SubscriberExpressGroup | Microsoft.SQLServer.Replication.Windows.Monitor.SubscriptionDistributionAgentState |
| Microsoft.SQLServer.Replication.Windows.Monitor.SubscriptionMergeAgentState.Enabled.Override | Microsoft.SQLServer.Replication.Core.SubscriberExpressGroup | Microsoft.SQLServer.Replication.Windows.Monitor.SubscriptionMergeAgentState |
| ID | File Name | Accessibility | |
|---|---|---|---|
 | Microsoft.SQLServer.Replication.Windows.Module.Monitoring.Assembly | Microsoft.SQLServer.Replication.Windows.Module.Monitoring.dll | Public |
Home
Show Management Pack References