Collects the Windows "Core Merges Completed" performance counter for SQL 2014 DB Engine merge operation.
Note that this rule is enabled only for SQL editions supporting Memory-Optimized Data (64-bit Enterprise, Developer, or Evaluation edition).
The rule collects the Windows "Core Merges Completed" performance counter for SQL 2014 DB Engine merge operation.
The XTP Storage performance object contains counters related to SQL Server merge operation. The operation merges two adjacent data and delta file pairs and creates a new data and delta file pair.
Core Merges Completed - The number of core merges completed by the merge worker thread. These merges still need to be installed.
Note that this rule is enabled only for SQL editions supporting Memory-Optimized Data (64-bit Enterprise, Developer, or Evaluation edition).
Name | Description | Default Value |
Enabled | Enables or disables the workflow. | No |
Frequency (seconds) | The recurring interval of time in seconds in which to run the workflow. | 900 |
Target | Microsoft.SQLServer.2014.DBEngine |
Category | PerformanceCollection |
Enabled | False |
Instance Name | XTP Storage |
Counter Name | Core Merges Completed |
Frequency | 900 |
Alert Generate | False |
Remotable | True |
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 |
<Rule ID="Microsoft.SQLServer.2014.CollectionRule.DBEngine.XTPCoreMergesCompleted" Target="SQL2014Core!Microsoft.SQLServer.2014.DBEngine" Enabled="false">
<Category>PerformanceCollection</Category>
<DataSources>
<DataSource ID="DS" TypeID="SystemPerf!System.Performance.DataProvider">
<ComputerName>$Target/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$</ComputerName>
<CounterName>Core Merges Completed</CounterName>
<ObjectName>XTP Storage</ObjectName>
<InstanceName>$Target/Property[Type="SQL2014Core!Microsoft.SQLServer.2014.ServerRole"]/InstanceName$</InstanceName>
<AllInstances>false</AllInstances>
<Frequency>900</Frequency>
</DataSource>
</DataSources>
<ConditionDetection ID="PerfMapper" TypeID="SystemPerf!System.Performance.DataGenericMapper">
<ObjectName>SQL DB Engine:XTP Storage</ObjectName>
<CounterName>$Data/CounterName$</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>