Edit

SQL Server XTP Phantom Processor object

  • Article

Applies to: SQL Server

The SQL Server XTP Phantom Processor performance object contains counters related to the In-Memory OLTP engine's phantom processing subsystem. This component is responsible for detecting phantom rows in transactions running at the SERIALIZABLE isolation level, as well as constraint validation in concurrency scenarios.

This table describes the SQL Server XTP Phantom Processor counters.

Counter Description
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.
Phantom expired rows removed/sec The number of expired rows removed by phantom scans (on average), per second.
Phantom expired rows touched/sec The number of expired rows touched by phantom scans (on average), per second.
Phantom expiring rows touched/sec The number of expiring rows touched by phantom scans (on average), per second.
Phantom rows touched/sec The number of rows touched by phantom scans (on average), per second.
Phantom scans started/sec The number of phantom scans started (on average), per second.

Example

You begin to explore the query performance counters in this object using this T-SQL query on the sys.dm_os_performance_counters dynamic management view:

SELECT * FROM sys.dm_os_performance_counters
WHERE object_name LIKE '%XTP Phantom Processor%';

Related content