Manage and Monitor Semantic Search

Articol
02/28/2023

Applies to: SQL Server

Describes the process of semantic indexing and the tasks related to managing and monitoring the indexes.

Check the status of semantic indexing

Is the first phase of semantic indexing complete?

Query the dynamic management view, sys.dm_fts_index_population (Transact-SQL), and check the status and status_description columns.

The first phase of indexing includes the population of the full-text keyword index and the semantic key phrase index, as well as the extraction of document similarity data.

USE database_name  
GO  
  
SELECT * FROM sys.dm_fts_index_population WHERE table_id = OBJECT_ID('table_name')  
GO

Is the second phase of semantic indexing complete?

Query the dynamic management view, sys.dm_fts_semantic_similarity_population (Transact-SQL), and check the status and status_description columns..

The second phase of indexing includes the population of the semantic document similarity index.

USE database_name  
GO  
  
SELECT * FROM sys.dm_fts_semantic_similarity_population WHERE table_id = OBJECT_ID('table_name')  
GO

Check the size of the semantic indexes

What is the logical size of a semantic key phrase index or a semantic document similarity index?

Query the dynamic management view, sys.dm_db_fts_index_physical_stats (Transact-SQL).

The logical size is displayed in number of index pages.

USE database_name  
GO  
  
SELECT * FROM sys.dm_db_fts_index_physical_stats WHERE object_id = OBJECT_ID('table_name')  
GO

What is the total size of the full-text and semantic indexes for a full-text catalog?

Query the IndexSize property of the FULLTEXTCATALOGPROPERTY (Transact-SQL) metadata function.

SELECT FULLTEXTCATALOGPROPERTY('catalog_name', 'IndexSize')  
GO

How many items are indexed in the full-text and semantic indexes for a full-text catalog?

Query the ItemCount property of the FULLTEXTCATALOGPROPERTY (Transact-SQL) metadata function.

SELECT FULLTEXTCATALOGPROPERTY('catalog_name', 'ItemCount')  
GO

Force the population of the semantic indexes

You can force the population of full-text and semantic indexes by using the START/STOP/PAUSE or RESUME POPULATION clause with the same syntax and behavior that is described for full-text indexes. For more information, see ALTER FULLTEXT INDEX (Transact-SQL) and Populate Full-Text Indexes.

Since semantic indexing is dependent on full-text indexing, semantic indexes are only populated when the associated full-text indexes are populated.

Example: Start a full population of full-text and semantic indexes

The following example starts full population of both full-text and semantic indexes by altering an existing full-text index on the Production.Document table in the AdventureWorks2022 sample database.

USE AdventureWorks2022  
GO  
  
ALTER FULLTEXT INDEX ON Production.Document  
    START FULL POPULATION  
GO

Disable or re-enable semantic indexing

You can enable or disable full-text or semantic indexing by using the ENABLE/DISABLE clause with the same syntax and behavior that is described for full-text indexes. For more information, see ALTER FULLTEXT INDEX (Transact-SQL).

When semantic indexing is disabled and suspended, queries over semantic data continue to work successfully and to return previously indexed data. This behavior is not consistent with the behavior of Full-Text Search.

-- To disable semantic indexing on a table  
USE database_name  
GO  
  
ALTER FULLTEXT INDEX ON table_name DISABLE  
GO  
  
-- To re-enable semantic indexing on a table  
USE database_name  
GO  
  
ALTER FULLTEXT INDEX ON table_name ENABLE  
GO

About the phases of semantic indexing

Semantic Search indexes two kinds of data for each column on which it is enabled:

Key phrases
Document similarity

Semantic indexing occurs in two phases, in conjunction with full-text indexing:

Phase 1. The full-text keyword index and the semantic key phrase index are populated in parallel at the same time. The data required to index document similarity is also extracted at this time.
Phase 2. The semantic document similarity index is then populated. This index depends on both indexes that were populated in the preceding phase.

Issue: Semantic Indexes Are Not Populated

Are the associated full-text indexes populated?

Since semantic indexing is dependent on full-text indexing, semantic indexes are only populated when the associated full-text indexes are populated.

Are full-text search and semantic search properly installed and configured?

For more information, see Install and Configure Semantic Search.

Is the FDHOST service not available, or is there another condition that would cause full-text indexing to fail?

For more information, see Troubleshoot Full-Text Indexing.

Partajați prin