sys.dm_fts_index_population

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

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)	Address of the memory buffers allocated for the current 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	Number of work batches processed since the last population check point.
status	int	Status of this Population. Note: some of the states are transient. One of the following: 0 = New population 1 = Resume on database startup 2 = Temporary error 3 = Starting 4 = Resuming after temporary error 5 = Processing normally 6 = Stopping 7 = Has stopped processing 8 = Encountered row-level errors that will be retried 9 = Starting retry phase 10 = Processing retries
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	Number of worker tasks currently processing this population.
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.
start_time	datetime	Time 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

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

Examples

The following example returns all full populations currently active on the server.

SELECT * FROM sys.dm_fts_index_population 
    WHERE population_type = 1

See Also

Reference

Dynamic Management Views and Functions
Full-Text Search Related Dynamic Management Views

Help and Information

Getting SQL Server 2005 Assistance

Change History

Release	History
12 December 2006	New content: Added the example.