This topic has not yet been rated - Rate this topic

sys.dm_db_fts_index_physical_stats (Transact-SQL)

SQL Server 2012

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:

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

Concepts

Manage and Monitor Semantic Search

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD