sys.dm_db_fts_index_physical_stats (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2012)yesAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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).|

Column name Type Description
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.

General Remarks

For more information, see Manage and Monitor Semantic Search.

Metadata

For information about the status of semantic indexing, query the following dynamic management views:

Permissions

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.

Examples

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  

See Also

Manage and Monitor Semantic Search