Collects the Windows "Dusty corner scan retries/sec (Phantom-issued)" performance counter for the XTP engine's phantom processing subsystem.
The rule collects the Windows "Dusty corner scan retries/sec (Phantom-issued)" performance counter for the XTP engine's phantom processing subsystem.
The XTP Phantom Processor performance object contains counters related to the XTP engine's phantom processing subsystem. This component is responsible for detecting phantom rows in transactions running at the SERIALIZABLE isolation level.
Dusty corner scan retries/sec (Phantom-issued) - The number of scan retries due to write conflicts during dusty corner sweeps issued by the phantom processor (on average), per second. This is a very low-level counter, not intended for customer use.
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.2016.DBEngine |
Category | PerformanceCollection |
Enabled | True |
Instance Name | SQL Server 2016 XTP Phantom Processor |
Counter Name | Dusty corner scan retries/sec (Phantom-issued) |
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.2016.CollectionRule.DBEngine.XTPDustyCornerScanRetriesSecPhantomIssued" Target="SQL2016Core!Microsoft.SQLServer.2016.DBEngine" Enabled="true">
<Category>PerformanceCollection</Category>
<DataSources>
<DataSource ID="DS" TypeID="SystemPerf!System.Performance.DataProvider">
<ComputerName>$Target/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$</ComputerName>
<CounterName>Dusty corner scan retries/sec (Phantom-issued)</CounterName>
<ObjectName>SQL Server 2016 XTP Phantom Processor</ObjectName>
<InstanceName>$Target/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.ServerRole"]/InstanceName$</InstanceName>
<AllInstances>false</AllInstances>
<Frequency>900</Frequency>
</DataSource>
</DataSources>
<ConditionDetection ID="PerfMapper" TypeID="SystemPerf!System.Performance.DataGenericMapper">
<ObjectName>SQL DB Engine:SQL Server 2016 XTP Phantom Processor</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>