sys.dm_fts_index_population (Transact-SQL)

Returns information about the full-text index populations currently in progress.

Note

In SQL Server 2008, the meanings of the following columns have changed: memory_address, outstanding_batch_count, status, and worker_count.

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

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.

Permissions

Requires VIEW SERVER STATE permission on the server.

Physical Joins

Significant joins of this dynamic management view

Relationship Cardinalities

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