sys.dm_fts_population_ranges

Returns information about the specific crawl ranges related to a full-text index population currently in progress. A crawl range is a work task on one part of a table that returns data to the full-text search service.

Column name	Data type	Description
memory_address	varbinary(8)	Address of memory buffers allocated for activity related to this subrange of a full-text index population.
parent_memory_address	varbinary(8)	Address of memory buffers representing the parent object of all ranges of population related to a full-text index.
is_retry	bit	If the value is 1, this subrange is responsible for retrying rows that encountered errors.
session_id	smallint	ID of the session that is currently processing this task.
processed_row_count	int	Number of rows that have been processed by this range.
error_count	int	Number of rows that have encountered errors by this range.

Permissions

Requires VIEW SERVER STATE permission on the server.

Physical Joins

Relationship Cardinalities

From	To	Relationship
dm_fts_population_ranges.parent_memory_address	dm_fts_index_population.memory_address	Many-to-one

Examples

The following example returns all tables that are currently being worked on by at least one crawl range.

SELECT DISTINCT database_id, table_id 
    FROM sys.dm_fts_index_population population 
    JOIN sys.dm_fts_population_ranges ranges 
        ON (population.memory_address = ranges.parent_memory_address)
    WHERE ranges.session_id <> 0

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.