sys.dm_fts_index_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 information about the full-text index and semantic key phrase populations currently in progress in SQL Server.

Column nameData typeDescription
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.
memory_addressvarbinary(8)Memory address of the internal data structure that is used to represent an active population.
population_typeintType of population. One of the following:

1 = Full population

2 = Incremental timestamp-based population

3 = Manual update of tracked changes

4 = Background update of tracked changes.
population_type_descriptionnvarchar(120)Description for type of population.
is_clustered_index_scanbitIndicates whether the population involves a scan on the clustered index.
range_countintNumber of sub-ranges into which this population has been parallelized.
completed_range_countintNumber of ranges for which processing is complete.
outstanding_batch_countintCurrent number of outstanding batches for this population. For more information, see sys.dm_fts_outstanding_batches (Transact-SQL).
statusintApplies to: SQL Server 2012 through SQL Server 2016.

Status of this Population. Note: some of the states are transient. One of the following:

3 = Starting

5 = Processing normally

7 = Has stopped processing

For example, this status occurs when an auto merge is in progress.

11 = Population aborted

12 = Processing a semantic similarity extraction
status_descriptionnvarchar(120)Description of status of the population.
completion_typeintStatus of how this population completed.
completion_type_descriptionnvarchar(120)Description of the completion type.
worker_countintThis value is always 0.
queued_population_typeintType of the population, based on tracked changes, which will follow the current population, if any.
queued_population_type_descriptionnvarchar(120)Description of the population to follow, if any. For example, when CHANGE TRACKING = AUTO and the initial full population is in progress, this column would show "Auto 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.

When statistical semantic indexing is enabled in addition to full-text indexing, the semantic extraction and population of key phrases, and the extraction of document similarity data, occur simultaneously with full-text indexing. The population of the document similarity index occurs later in a second phase. For more information, see Manage and Monitor Semantic Search.

Requires VIEW SERVER STATE permission on the server.

Significant joins of this dynamic management view


Dynamic Management Views and Functions (Transact-SQL)
Full-Text Search and Semantic Search Dynamic Management Views and Functions (Transact-SQL)

Community Additions