Export (0) Print
Expand All
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.

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
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.