sys.dm_fts_population_ranges (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)yesAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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

On SQL Server, requires VIEW SERVER STATE permission.
On SQL Database Premium Tiers, requires the VIEW DATABASE STATE permission in the database. On SQL Database Standard and Basic Tiers, requires the Server admin or an Azure Active Directory admin account.

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

See Also

Full-Text Search and Semantic Search Dynamic Management Views and Functions (Transact-SQL)