Skip to content

Latest commit

 

History

History
63 lines (54 loc) · 3.7 KB

sys-dm-db-xtp-index-stats-transact-sql.md

File metadata and controls

63 lines (54 loc) · 3.7 KB
title description author ms.author ms.date ms.service ms.subservice ms.topic f1_keywords helpviewer_keywords dev_langs monikerRange
sys.dm_db_xtp_index_stats (Transact-SQL)
For In-Memory OLTP tables, sys.dm_db_xtp_index_stats contains statistics collected since the last database restart.
rwestMSFT
randolphwest
02/27/2023
sql
system-objects
reference
sys.dm_db_xtp_index_stats
dm_db_xtp_index_stats
sys.dm_db_xtp_index_stats_TSQL
dm_db_xtp_index_stats_TSQL
sys.dm_db_xtp_index_stats dynamic management view
TSQL
>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current

sys.dm_db_xtp_index_stats (Transact-SQL)

[!INCLUDEsql-asdb-asdbmi]

Contains statistics collected since the last database restart.

For more information, see [[!INCLUDEinmemory] (In-Memory Optimization)](../in-memory-oltp/overview-and-usage-scenarios.md) and Guidelines for Using Indexes on Memory-Optimized Tables.

Column name Data type Description
object_id bigint ID of the object to which this index belongs.
xtp_object_id bigint Internal ID corresponding to the current version of the object.

Note: Applies to [!INCLUDEsssql16-md].
index_id bigint ID of the index. The index_id is unique only within the object.
scans_started bigint Number of [!INCLUDEinmemory] index scans performed. Every select, insert, update, or delete requires an index scan.
scans_retries bigint Number of index scans that needed to be retried,
rows_returned bigint Cumulative number of rows returned since the table was created or the start of [!INCLUDEssNoVersion].
rows_touched bigint Cumulative number of rows accessed since the table was created or the start of [!INCLUDEssNoVersion].
rows_expiring bigint Internal use only.
rows_expired bigint Internal use only.
rows_expired_removed bigint Internal use only.
phantom_scans_started bigint Internal use only.
phantom_scans_retries bigint Internal use only.
phantom_rows_touched bigint Internal use only.
phantom_expiring_rows_encountered bigint Internal use only.
phantom_expired_rows_encountered bigint Internal use only.
phantom_expired_removed_rows_encountered bigint Internal use only.
phantom_expired_rows_removed bigint Internal use only.
object_address varbinary(8) Internal use only.

Permissions

Requires VIEW DATABASE STATE permission on the current database.

Permissions for SQL Server 2022 and later

Requires VIEW DATABASE PERFORMANCE STATE permission on the database.

Related content