Home
  •  

Réplication MSSQL 2012 : nombre de travaux d'agents de réplication en échec sur le serveur de distribution

Microsoft.SQLServer.2012.Replication.CollectionRule.Distributor.ReplicationAgentFailJobsPerformanceCounter (Rule)

Nombre de travaux d'agents de réplication en échec sur le serveur de distribution

Knowledge Base article:

Résumé

Nombre de travaux d'agents de réplication en échec sur le serveur de distribution

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:

TargetMicrosoft.SQLServer.2012.Replication.Distributor
CategoryPerformanceCollection
EnabledTrue
Alert GenerateFalse
RemotableTrue

Member Modules:

ID Module Type TypeId RunAs 
DS DataSource Microsoft.SQLServer.2012.Replication.DataSource.DistributorFailJobsMonitor 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.Distributor.ReplicationAgentFailJobsPerformanceCounter" Enabled="true" Target="MS2RD!Microsoft.SQLServer.2012.Replication.Distributor" ConfirmDelivery="false" Remotable="true" Priority="Normal" DiscardLevel="100">

  <Category>PerformanceCollection</Category>

  <DataSources>

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

      <SqlTimeout>300</SqlTimeout>

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

      <NumberOfConsecutiveFails>1</NumberOfConsecutiveFails>

      <CategoryList>Distribution</CategoryList>

      <ExcludeCategoryList/>

      <IntervalSeconds>300</IntervalSeconds>

      <SyncTime/>

    </DataSource>

  </DataSources>

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

    <ObjectName>$Target/Property[Type="MSRL!Microsoft.SQLServer.Replication.Library.GenericDistributor"]/InstanceName$</ObjectName>

    <CounterName>Distributor: Count of Failed Jobs</CounterName>

    <InstanceName/>

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

  </ConditionDetection>

  <WriteActions>

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

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

  </WriteActions>

</Rule>