Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
SQL Server
The SQL Server XTP Storage performance object contains counters related to on-disk storage for In-Memory OLTP in SQL Server.
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. |
Example
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%';