Updated: June 10, 2016
Returns information about the full-text index and semantic key phrase populations currently in progress in SQL Server.
|Column name||Data 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.|
|memory_address||varbinary(8)||Memory address of the internal data structure that is used to represent an active population.|
|population_type||int||Type 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_description||nvarchar(120)||Description for type of population.|
|is_clustered_index_scan||bit||Indicates whether the population involves a scan on the clustered index.|
|range_count||int||Number of sub-ranges into which this population has been parallelized.|
|completed_range_count||int||Number of ranges for which processing is complete.|
|outstanding_batch_count||int||Current number of outstanding batches for this population. For more information, see sys.dm_fts_outstanding_batches (Transact-SQL).|
|status||int||Applies 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_description||nvarchar(120)||Description of status of the population.|
|completion_type||int||Status of how this population completed.|
|completion_type_description||nvarchar(120)||Description of the completion type.|
|worker_count||int||This value is always 0.|
|queued_population_type||int||Type of the population, based on tracked changes, which will follow the current population, if any.|
|queued_population_type_description||nvarchar(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_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.|
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.