Export (0) Print
Expand All

sys.dm_fts_semantic_similarity_population (Transact-SQL)

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).

Applies to: SQL Server (SQL Server 2012 through current version).

Column name

Type

Description

database_id

int

ID of the database that contains the full-text index being populated.

catalog_id

int

ID of the full-text catalog that contains this full-text index.

table_id

int

ID of the table for which the full-text index is being populated.

document_count

int

Number of total documents in the population

document_processed_count

int

Number of documents processed since start of this population cycle

completion_type

int

Status of how this population completed.

completion_type_description

nvarchar(120)

Description of the completion type.

worker_count

int

Number of worker threads associated with similarity extraction

status

int

Status 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_description

nvarchar(120)

Description of status of the population.

start_time

datetime

Time that the population started.

incremental_timestamp

timestamp

Represents 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 about the status of semantic indexing, query sys.dm_fts_index_population (Transact-SQL).

Permissions

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;
GO

Community Additions

ADD
Show:
© 2014 Microsoft