sys.dm_fts_population_ranges (Transact-SQL)

Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance

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 and SQL Managed Instance, requires VIEW SERVER STATE permission.

On SQL Database Basic, S0, and S1 service objectives, and for databases in elastic pools, the server admin account, the Microsoft Entra admin account, or membership in the ##MS_ServerStateReader## server role is required. On all other SQL Database service objectives, either the VIEW DATABASE STATE permission on the database, or membership in the ##MS_ServerStateReader## server role is required.

Permissions for SQL Server 2022 and later

Requires VIEW SERVER PERFORMANCE 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

Next steps

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