| title | SQL Server XTP Storage object | |||
|---|---|---|---|---|
| description | Learn about the SQL Server XTP Storage performance object, which contains counters related to on-disk storage for In-Memory OLTP in SQL Server. | |||
| 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 Storage performance object contains counters related to on-disk storage for In-Memory OLTP in [!INCLUDE ssNoVersion].
This table describes the SQL Server XTP Storage counters.
| Counter | Description |
|---|---|
| Checkpoints Closed | Count of checkpoints closed done by online agent. |
| Checkpoints Completed | Count of checkpoints processed by offline checkpoint thread. |
| Core Merges Completed | The number of core merges completed by the merge worker thread. These merges still need to be installed. |
| Merge Policy Evaluations | The number of merge policy evaluations since the server started. |
| Merge Requests Outstanding | The number of merge requests outstanding since the server started. |
| Merges Abandoned | The number of merges abandoned due to failure. |
| Merges Installed | The number of merges successfully installed. |
| Total Files Merged | The total number of source files merged. This count can be used to find the average number of source files in the merge. |
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 Storage%';