| title | SQL Server XTP Phantom Processor object | |||
|---|---|---|---|---|
| description | Learn about the SQL Server XTP Phantom Processor performance object, which contains counters for the In-Memory OLTP engine's phantom processing subsystem. | |||
| author | MikeRayMSFT | |||
| ms.author | mikeray | |||
| ms.date | 12/04/2023 | |||
| ms.service | sql | |||
| ms.subservice | performance | |||
| ms.topic | reference | |||
| helpviewer_keywords |
|
[!INCLUDE 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. |
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%';