| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | helpviewer_keywords | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
SQL Server XTP Storage object |
Learn about the SQL Server XTP Storage performance object, which contains counters related to on-disk storage for In-Memory OLTP in SQL Server. |
MikeRayMSFT |
mikeray |
12/04/2023 |
sql |
performance |
reference |
|
[!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%';