Home
  •  

MSSQL 2014-Replikation: Merge-Agent: Konflikte pro Sekunde

Microsoft.SQLServer.2014.Replication.CollectionRule.Distributor.ConflictsPerSec (Rule)

Die Anzahl der Konflikte pro Sekunde, die im Rahmen des Mergevorgangs aufgetreten sind.

Knowledge Base article:

Zusammenfassung

Die Anzahl der Konflikte pro Sekunde, die im Rahmen des Mergevorgangs aufgetreten sind.

Überschreibbare Parameter

Name

Beschreibung

Standardwert

Aktiviert

Aktiviert oder deaktiviert den Workflow.

Ja

Häufigkeit in Sekunden

Das periodische Intervall in Sekunden, in dem der Workflow ausgeführt werden soll.

900

Element properties:

TargetMicrosoft.SQLServer.2014.Replication.Distributor
CategoryPerformanceCollection
EnabledTrue
Instance Name$Target/Property[Type="MSRL!Microsoft.SQLServer.Replication.Library.GenericDistributor"]/PerformanceCounterObject$:Replication Merge
Counter NameConflicts/sec
Frequency900
Alert GenerateFalse
RemotableTrue

Member Modules:

ID Module Type TypeId RunAs 
DS DataSource System.Performance.DataProvider Default
PerfMapper ConditionDetection System.Performance.DataGenericMapper Default
WriteToDB WriteAction Microsoft.SystemCenter.CollectPerformanceData Default
WriteToDW WriteAction Microsoft.SystemCenter.DataWarehouse.PublishPerformanceData Default

Source Code:

<Rule ID="Microsoft.SQLServer.2014.Replication.CollectionRule.Distributor.ConflictsPerSec" Target="MS2RD!Microsoft.SQLServer.2014.Replication.Distributor" Enabled="true">

  <Category>PerformanceCollection</Category>

  <DataSources>

    <DataSource ID="DS" TypeID="Perf!System.Performance.DataProvider">

      <ComputerName>$Target/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$</ComputerName>

      <CounterName>Conflicts/sec</CounterName>

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

      <AllInstances>true</AllInstances>

      <Frequency>900</Frequency>

    </DataSource>

  </DataSources>

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

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

    <CounterName>Merge: Conflicts/sec</CounterName>

    <InstanceName/>

    <Value>$Data/Value$</Value>

  </ConditionDetection>

  <WriteActions>

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

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

  </WriteActions>

</Rule>