TechNet
Export (0) Print
Expand All

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.

Applies to: SQL Server (SQL Server 2012 through current version).
Column nameTypeDescription
object_idintObject ID of the table that contains the index.
fulltext_index_page_countbigintLogical size of the extraction in number of index pages.
keyphrase_index_page_countbigintLogical size of the extraction in number of index pages.
similarity_index_page_countbigintLogical 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:

Permissions

Requires VIEW SERVER STATE permission on the server.

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  

Manage and Monitor Semantic Search

Community Additions

ADD
Show:
© 2016 Microsoft