| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | monikerRange | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sys.dm_db_fts_index_physical_stats (Transact-SQL) |
sys.dm_db_fts_index_physical_stats (Transact-SQL) |
rwestMSFT |
randolphwest |
02/24/2023 |
sql |
system-objects |
reference |
|
|
|
=azuresqldb-current||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current |
[!INCLUDE SQL Server Azure SQL Database Azure SQL Managed Instance]
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 more information, see Manage and Monitor Semantic Search.
For information about the status of semantic indexing, query the following dynamic management views:
On [!INCLUDEssNoVersion_md] and SQL Managed Instance, requires VIEW SERVER STATE permission.
On SQL Database Basic, S0, and S1 service objectives, and for databases in elastic pools, the server admin account, the Microsoft Entra admin account, or membership in the ##MS_ServerStateReader## server role is required. On all other SQL Database service objectives, either the VIEW DATABASE STATE permission on the database, or membership in the ##MS_ServerStateReader## server role is required.
Requires VIEW SERVER PERFORMANCE 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