SQL Server XTP Storage object
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%';
Related content
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for