sys.dm_fts_index_population (Transact-SQL)

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

FromToRelationship
dm_fts_active_catalogs.database_iddm_fts_index_population.database_idOne-to-one
dm_fts_active_catalogs.catalog_iddm_fts_index_population.catalog_idOne-to-one
dm_fts_population_ranges.parent_memory_addressdm_fts_index_population.memory_addressMany-to-one

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

Community Additions

ADD
Show:
© 2016 Microsoft