Skip to content

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

Latest commit

 

History

History
62 lines (53 loc) · 3.51 KB

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

File metadata and controls

62 lines (53 loc) · 3.51 KB
title sys.dm_db_xtp_index_stats (Transact-SQL)
description For In-Memory OLTP tables, sys.dm_db_xtp_index_stats contains statistics collected since the last database restart.
author rwestMSFT
ms.author randolphwest
ms.date 03/02/2022
ms.prod sql
ms.prod_service database-engine, sql-database
ms.technology system-objects
ms.topic reference
f1_keywords
sys.dm_db_xtp_index_stats
dm_db_xtp_index_stats
sys.dm_db_xtp_index_stats_TSQL
dm_db_xtp_index_stats_TSQL
helpviewer_keywords
sys.dm_db_xtp_index_stats dynamic management view
dev_langs
TSQL
monikerRange >=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.
phatom_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.

See also

Next steps