sys.dm_fts_semantic_similarity_population (Transact-SQL)


Updated: June 10, 2016

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Returns one row of status information about the population of the document similarity index for each similarity index in each table that has an associated semantic index.

The population step follows the extraction step. For status information about the similarity extraction step, see sys.dm_fts_index_population (Transact-SQL).

Column nameTypeDescription
database_idintID of the database that contains the full-text index being populated.
catalog_idintID of the full-text catalog that contains this full-text index.
table_idintID of the table for which the full-text index is being populated.
document_countintNumber of total documents in the population
document_processed_countintNumber of documents processed since start of this population cycle
completion_typeintStatus of how this population completed.
completion_type_descriptionnvarchar(120)Description of the completion type.
worker_countintNumber of worker threads associated with similarity extraction
statusintStatus of this Population. Note: some of the states are transient. One of the following:

3 = Starting

5 = Processing normally

7 = Has stopped processing

11 = Population aborted
status_descriptionnvarchar(120)Description of status of the population.
start_timedatetimeTime that the population started.
incremental_timestamptimestampRepresents the starting timestamp for a full population. For all other population types this value is the last committed checkpoint representing the progress of the populations.

For more information, see Manage and Monitor Semantic Search.

For more information about the status of semantic indexing, query sys.dm_fts_index_population (Transact-SQL).


Requires VIEW SERVER STATE permission on the server.

The following example shows how to query the status of document similarity index populations for all tables that have an associated semantic index:

SELECT * FROM sys.dm_fts_semantic_similarity_population;  

Manage and Monitor Semantic Search

Community Additions