sys.dm_db_xtp_index_stats (Transact-SQL)sys.dm_db_xtp_index_stats (Transact-SQL)

适用于: 是SQL Server是Azure SQL 数据库否Azure SQL 数据仓库否并行数据仓库APPLIES TO: yesSQL Server yesAzure SQL Database noAzure SQL Data Warehouse noParallel Data Warehouse

包含上次重新启动数据库后收集的统计信息。Contains statistics collected since the last database restart.

有关详细信息,请参阅内存中 OLTP(内存中优化)Guidelines for Using Indexes on Memory-Optimized TablesFor more information, see In-Memory OLTP (In-Memory Optimization) and Guidelines for Using Indexes on Memory-Optimized Tables.

列名Column name 数据类型Data type 描述Description
object_idobject_id bigintbigint 该索引所属对象的 ID。ID of the object to which this index belongs.
xtp_object_idxtp_object_id bigintbigint 该对象的当前版本相对应的内部 ID。Internal ID corresponding to the current version of the object.

注意:适用于 SQL Server 2016 (13.x)SQL Server 2016 (13.x)Note: Applies to SQL Server 2016 (13.x)SQL Server 2016 (13.x).
index_idindex_id bigintbigint 索引的 ID。ID of the index. 该 index_id 只在该对象中是唯一的。The index_id is unique only within the object.
scans_startedscans_started bigintbigint 执行的内存中 OLTP 索引扫描的次数。Number of In-Memory OLTP index scans performed. 每次进行选择、插入、更新或删除时都需要进行索引扫描。Every select, insert, update, or delete requires an index scan.
scans_retriesscans_retries bigintbigint 需要重试的索引扫描次数,Number of index scans that needed to be retried,
rows_returnedrows_returned bigintbigint 自表创建或 SQL ServerSQL Server 启动以来返回的累计行数。Cumulative number of rows returned since the table was created or the start of SQL ServerSQL Server.
rows_touchedrows_touched bigintbigint 自表创建或 SQL ServerSQL Server 启动以来访问的累计行数。Cumulative number of rows accessed since the table was created or the start of SQL ServerSQL Server.
rows_expiringrows_expiring bigintbigint 仅限内部使用。Internal use only.
rows_expiredrows_expired bigintbigint 仅限内部使用。Internal use only.
rows_expired_removedrows_expired_removed bigintbigint 仅限内部使用。Internal use only.
phantom_scans_startedphantom_scans_started bigintbigint 仅限内部使用。Internal use only.
phatom_scans_retriesphatom_scans_retries bigintbigint 仅限内部使用。Internal use only.
phantom_rows_touchedphantom_rows_touched bigintbigint 仅限内部使用。Internal use only.
phantom_expiring_rows_encounteredphantom_expiring_rows_encountered bigintbigint 仅限内部使用。Internal use only.
phantom_expired_rows_encounteredphantom_expired_rows_encountered bigintbigint 仅限内部使用。Internal use only.
phantom_expired_removed_rows_encounteredphantom_expired_removed_rows_encountered bigintbigint 仅限内部使用。Internal use only.
phantom_expired_rows_removedphantom_expired_rows_removed bigintbigint 仅限内部使用。Internal use only.
object_addressobject_address varbinary(8)varbinary(8) 仅限内部使用。Internal use only.

权限Permissions

要求对当前数据库拥有 VIEW DATABASE STATE 权限。Requires VIEW DATABASE STATE permission on the current database.

请参阅See Also

内存优化表动态管理视图(Transact SQL)Memory-Optimized Table Dynamic Management Views (Transact-SQL)