Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

sys.dm_db_xtp_index_stats (Transact-SQL)

Applies To: SQL Server 2014, SQL Server 2016 Preview

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

Contains statistics collected since the last database restart.

For more information, see In-Memory OLTP (In-Memory Optimization) and Guidelines for Using Indexes on Memory-Optimized Tables.

Applies to: SQL Server (SQL Server 2014 through current version), SQL Database V12.

Column name

Data type

Description

object_id

bigint

ID of the object to which this index belongs.

xtp_object_id

bigint

ID of the memory-optimized table.

index_id

bigint

ID of the index. The index_id is unique only within the object.

scans_started

bigint

Number of In-Memory OLTP 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 SQL Server.

rows_touched

bigint

Cumulative number of rows accessed since the table was created or the start of SQL Server.

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.

object_address

varbinary(8)

Internal use only.

xtp_object_id

bigint

The in-memory OLTP object ID that corresponds to the memory-optimized table.

Requires VIEW DATABASE STATE permission on the current database.

Community Additions

ADD
Show:
© 2015 Microsoft