Export (0) Print
Expand All

sys.dm_fts_population_ranges

Updated: 12 December 2006

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.

Requires VIEW SERVER STATE permission on the server.

From To Relationship

dm_fts_population_ranges.parent_memory_address

dm_fts_index_population.memory_address

Many-to-one

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

Release History

12 December 2006

New content:
  • Added the example.
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft