sys.dm_db_fts_index_physical_stats

Description

Returns a row for each full-text or semantic index in each table that has an associated full-text Object ID of the table that contains the index. Logical size of the extraction in number of index pages. Logical size of the extraction in number of index pages. Logical size of the extraction in number of index pages. Manage and Monitor Semantic Search For information about the status of semantic indexing, query the following dynamic

Syntax

##MS_ServerStateReader##

Permissions

Returns a row for each full-text or semantic index in each table that has an associated full-text or semantic index. int Object ID of the table that contains the index. Logical size of the extraction in number of index pages. Logical size of the extraction in number of index pages. Logical size of the extraction in number of index pages. For more information, see Manage and Monitor Semantic Search. For information about the status of semantic indexing, query the following dynamic management views: sys.dm_fts_index_population (Transact-SQL) sys.dm_fts_semantic_similarity_population (Transact-SQL) On SQL Server and SQL Managed Instance, requires permission. On SQL Database , , and service objectives, and for databases in , the server admin account, the Microsoft Entra admin account, or membership in the server role is required. On all other SQL Database service objectives, ﾉ