Share via

  • Article

sys.dm_fts_population_ranges (Transact-SQL)

Returns information about the specific ranges related to a full-text index population currently in progress.

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. Forward progress is persisted and counted every 5 minutes, rather than with every batch commit.

error_count

int

Number of rows that have encountered errors by this range. Forward progress is persisted and counted every 5 minutes, rather than with every batch commit.

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_population_ranges.parent_memory_address

dm_fts_index_population.memory_address

Many-to-one