Réplication MSSQL 2012 : nombre de commandes en attente

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

Nombre de commandes en attente de réplication dans la base de données de distribution pour l'abonnement.

Knowledge Base article:

Résumé

Nombre de commandes en attente de réplication dans la base de données de distribution pour l'abonnement.

Paramètres remplaçables

Nom	Description	Valeur par défaut
Activé	Active ou désactive le flux de travail	Oui
Intervalle (secondes)	Intervalle de temps récurrent en secondes, pendant lequel le workflow est exécuté.	300
Délai d'attente (secondes)	Délai d'attente (secondes)	300
Heure de synchronisation	Heure de synchronisation

Element properties:

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

Member Modules:

ID	Module Type	TypeId	RunAs
DS	DataSource	Microsoft.SQLServer.2012.Replication.DataSource.SubscriptionPendingCmdsMonitor	Microsoft.SQLServer.Replication.Monitoring.RunAs.Monitor
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.2012.Replication.CollectionRule.Subscription.SubscriptionPendingCmdsPerformanceCounter" Enabled="true" Target="MS2RD!Microsoft.SQLServer.2012.Replication.Subscription" ConfirmDelivery="false" Remotable="true" Priority="Normal" DiscardLevel="100">

  <Category>PerformanceCollection</Category>

  <DataSources>

    <DataSource ID="DS" TypeID="Microsoft.SQLServer.2012.Replication.DataSource.SubscriptionPendingCmdsMonitor" RunAs="MSRL!Microsoft.SQLServer.Replication.Monitoring.RunAs.Monitor">

      <SqlTimeout>300</SqlTimeout>

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

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

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

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

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

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

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

      <IntervalSeconds>300</IntervalSeconds>

      <SyncTime/>

    </DataSource>

  </DataSources>

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

    <ObjectName>$Target/Property[Type="MSRL!Microsoft.SQLServer.Replication.Library.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>