sys.dm_fts_index_population (Transact-SQL)
Returns information about the full-text index and semantic key phrase populations currently in progress.
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.
|
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 |
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. |
