Collects the Windows "Log records written/sec" performance counter for SQL 2014 DB Engine XTP transaction logging.
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 "Log records written/sec" performance counter for SQL 2014 DB Engine XTP transaction logging.
The XTP Transaction Log performance object contains counters related to XTP transaction logging in SQL Server.
Log records written/sec - The number of records written to the SQL Server transaction log by the XTP engine (on average), per second.
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 Transaction Log |
Counter Name | Log records written/sec |
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.XTPLogRecordsWrittenPerSec" 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>Log records written/sec</CounterName>
<ObjectName>XTP Transaction Log</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 Transaction Log</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>