| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic |
|---|---|---|---|---|---|---|---|
XTP (In-Memory OLTP) Performance Counters |
SQL Server provides objects and counters that can be used by Performance Monitor to monitor In-Memory OLTP activity. |
MikeRayMSFT |
mikeray |
12/04/2023 |
sql |
performance |
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]. |