sys.dm_db_fts_index_physical_stats (Transact-SQL)

Returns a row for each full-text or semantic index in each table that has an associated full-text or semantic index.

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:

• sys.dm_fts_index_population (Transact-SQL)

• sys.dm_fts_semantic_similarity_population (Transact-SQL)

Security

Permissions

Requires VIEW SERVER STATE permission on the server.

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

Zobacz także

Koncepcje

Manage and Monitor Semantic Search