MSSQL on Windows Replication: Count of Pending Commands

Microsoft.SQLServer.Replication.Windows.CollectionRule.Subscription.SubscriptionPendingCmdsPerformanceCounter (Rule)

Count of commands pending replication in Distribution database for the Subscription. Note that this rule is disabled for Merge Subscriptions.

Knowledge Base article:

Summary

Count of commands pending replication in Distribution database for the Subscription. Note that this rule is disabled for Merge Subscriptions.

Overrideable Parameters

Name	Description	Default Value
Enabled	Enables or disables the workflow.	Yes
Interval (seconds)	The recurring interval of time in seconds in which to run the workflow.	300
Synchronization Time	Synchronization Time
Timeout (seconds)	Specifies the time the workflow is allowed to run before being closed and marked as failed.	200
Timeout for database connection (seconds)	The workflow will fail and register an event if it cannot access the database during the specified period.	15

Element properties:

Target	Microsoft.SQLServer.Replication.Windows.Subscription
Category	PerformanceCollection
Enabled	True
Alert Generate	False
Remotable	True

Member Modules:

ID	Module Type	TypeId	RunAs
DS	DataSource	Microsoft.SQLServer.Replication.Windows.DataSource.SubscriptionPendingCmdsMonitor	Microsoft.SQLServer.Core.RunAs.Monitoring
Mapper	ConditionDetection	System.Performance.DataGenericMapper	Default
WriteToDatabase	WriteAction	Microsoft.SystemCenter.CollectPerformanceData	Default
WriteToDW	WriteAction	Microsoft.SystemCenter.DataWarehouse.PublishPerformanceData	Default

Source Code:

<Rule ID="Microsoft.SQLServer.Replication.Windows.CollectionRule.Subscription.SubscriptionPendingCmdsPerformanceCounter" Enabled="true" Target="SQLReplWD!Microsoft.SQLServer.Replication.Windows.Subscription" ConfirmDelivery="false" Remotable="true" Priority="Normal" DiscardLevel="100">

  <Category>PerformanceCollection</Category>

  <DataSources>

    <DataSource ID="DS" TypeID="Microsoft.SQLServer.Replication.Windows.DataSource.SubscriptionPendingCmdsMonitor" RunAs="SqlCoreLib!Microsoft.SQLServer.Core.RunAs.Monitoring">

      <MachineName>$Target/Host/Host/Property[Type='SqlCoreLib!Microsoft.SQLServer.Core.DBEngine']/MachineName$</MachineName>

      <NetbiosComputerName>$Target/Host/Host/Property[Type='SqlCoreLib!Microsoft.SQLServer.Core.DBEngine']/NetbiosComputerName$</NetbiosComputerName>

      <InstanceName>$Target/Host/Host/Property[Type='SqlCoreLib!Microsoft.SQLServer.Core.DBEngine']/InstanceName$</InstanceName>

      <SqlTimeoutSeconds>15</SqlTimeoutSeconds>

      <ConnectionString>$Target/Property[Type="MSRL!Microsoft.SQLServer.Replication.Core.GenericSubscription"]/Distributor$</ConnectionString>

      <MonitoringType>$Target/Host/Host/Property[Type="SqlDiscW!Microsoft.SQLServer.Windows.DBEngine"]/MonitoringType$</MonitoringType>

      <SubscriptionType>$Target/Property[Type="MSRL!Microsoft.SQLServer.Replication.Core.GenericSubscription"]/Type$</SubscriptionType>

      <PublisherName>$Target/Property[Type="MSRL!Microsoft.SQLServer.Replication.Core.GenericSubscription"]/Publisher$</PublisherName>

      <Subscriber>$Target/Property[Type="MSRL!Microsoft.SQLServer.Replication.Core.GenericSubscription"]/Subscriber$</Subscriber>

      <PublisherDb>$Target/Property[Type="MSRL!Microsoft.SQLServer.Replication.Core.GenericSubscription"]/PublicationDatabase$</PublisherDb>

      <SubscriberDb>$Target/Property[Type="MSRL!Microsoft.SQLServer.Replication.Core.GenericSubscription"]/SubscriptionDatabase$</SubscriberDb>

      <Publication>$Target/Property[Type="MSRL!Microsoft.SQLServer.Replication.Core.GenericSubscription"]/PublicationName$</Publication>

      <IntervalSeconds>300</IntervalSeconds>

      <SyncTime/>

      <TimeoutSeconds>200</TimeoutSeconds>

      <CheckMachineAndInstanceName>false</CheckMachineAndInstanceName>

    </DataSource>

  </DataSources>

  <ConditionDetection ID="Mapper" TypeID="Perf!System.Performance.DataGenericMapper">

    <ObjectName>$Target/Property[Type="MSRL!Microsoft.SQLServer.Replication.Core.GenericSubscription"]/SubscriptionName$</ObjectName>

    <CounterName>Subscription: Count of Pending Commands</CounterName>

    <InstanceName/>

    <Value>$Data/Property[@Name='SubscriptionPendingCmds']$</Value>

  </ConditionDetection>

  <WriteActions>

    <WriteAction ID="WriteToDatabase" TypeID="SC!Microsoft.SystemCenter.CollectPerformanceData"/>

    <WriteAction ID="WriteToDW" TypeID="SCDW!Microsoft.SystemCenter.DataWarehouse.PublishPerformanceData"/>

  </WriteActions>

</Rule>