Export (0) Print
Expand All

sys.dm_fts_index_population (Transact-SQL)

Returns information about the full-text index and semantic key phrase populations currently in progress in SQL Server.

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

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

Applies to: SQL Server 2012 through SQL Server 2014.

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.

From

To

Relationship

dm_fts_active_catalogs.database_id

dm_fts_index_population.database_id

One-to-one

dm_fts_active_catalogs.catalog_id

dm_fts_index_population.catalog_id

One-to-one

dm_fts_population_ranges.parent_memory_address

dm_fts_index_population.memory_address

Many-to-one

Community Additions

ADD
Show:
© 2014 Microsoft