| title | XTP (In-Memory OLTP) Performance Counters |
|---|---|
| description | SQL Server provides objects and counters that can be used by Performance Monitor to monitor In-Memory OLTP activity. |
| author | MikeRayMSFT |
| ms.author | mikeray |
| ms.date | 12/04/2023 |
| ms.service | sql |
| ms.subservice | performance |
| ms.topic | reference |
[!INCLUDE SQL Server]
[!INCLUDE ssNoVersion] provides objects and counters that can be used by Performance Monitor to monitor In-Memory OLTP activity. The objects and counters are shared across all instances of a given version of [!INCLUDE ssNoVersion] on the machine, starting in [!INCLUDE ssSQL14].
In the past the object and counter names began with XTP, as in XTP Cursors. Now starting with [!INCLUDE sssql16-md], the names are like the following pattern:
- SQL Server <version> XTP Cursors
For <version> the value is the SQL Server XTP version year, for example, 2017.
The following table describes [!INCLUDE ssNoVersion] performance objects.
| Performance object | Description |
|---|---|
| SQL Server XTP Cursors | The SQL Server XTP Cursors performance object contains counters related to internal In-Memory OLTP engine cursors. Cursors are the low-level building blocks the In-Memory OLTP engine uses to process [!INCLUDE tsql] queries. As such, you do not typically have direct control over them. |
| SQL Server XTP Databases | The SQL Server XTP Databases performance object provides In-Memory OLTP database-specific counters. |
| SQL Server XTP Garbage Collection | The SQL Server XTP Garbage Collection performance object contains counters related to the In-Memory OLTP engine's garbage collector. |
| SQL Server 2016 XTP IO Governor | The SQL Server XTP IO Governor performance object contains counters related to the In-Memory OLTP IO Rate Governor. |
| SQL Server XTP Phantom Processor | 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. |
| SQL Server XTP Storage | The SQL Server XTP Storage performance object contains counters related to In-Memory OLTP storage in [!INCLUDE ssNoVersion]. |
| SQL Server XTP Transaction Log | The SQL Server XTP Transaction Log performance object contains counters related to In-Memory OLTP transaction logging in [!INCLUDE ssNoVersion]. |
| SQL Server XTP Transactions | The SQL Server XTP Transactions performance object contains counters related to In-Memory OLTP engine transactions in [!INCLUDE ssNoVersion]. |