Kommentar
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
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