Returns a row for each full-text or semantic index in each table that has an associated full-text or semantic index.
|Applies to: SQL Server ( SQL Server 2012 through current version).|
|object_id||int||Object ID of the table that contains the index.|
|fulltext_index_page_count||bigint||Logical size of the extraction in number of index pages.|
|keyphrase_index_page_count||bigint||Logical size of the extraction in number of index pages.|
|similarity_index_page_count||bigint||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:
On SQL Server, requires
VIEW SERVER STATE permission.
On SQL Database Premium Tiers, requires the
VIEW DATABASE STATE permission in the database. On SQL Database Standard and Basic Tiers, requires the Server admin or an Azure Active Directory admin account.
The following example shows how to query for the logical size of each full-text or semantic index in every table that has an associated full-text or semantic index:
SELECT * FROM sys.dm_db_fts_index_physical_stats; GO