Редагувати

Поділитися через


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

Diagram of physical joins for sys.dm_fts_population_ranges.

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)