TechNet
Export (0) Print
Expand All

sys.dm_fts_population_ranges (Transact-SQL)

 

Updated: June 10, 2016

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure 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 nameData typeDescription
memory_addressvarbinary(8)Address of memory buffers allocated for activity related to this subrange of a full-text index population.
parent_memory_addressvarbinary(8)Address of memory buffers representing the parent object of all ranges of population related to a full-text index.
is_retrybitIf the value is 1, this subrange is responsible for retrying rows that encountered errors.
session_idsmallintID of the session that is currently processing this task.
processed_row_countintNumber 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_countintNumber of rows that have encountered errors by this range. Forward progress is persisted and counted every 5 minutes, rather than with every batch commit.

Requires VIEW SERVER STATE permission on the server.

Significant joins of this dynamic management view

FromToRelationship
dm_fts_population_ranges.parent_memory_addressdm_fts_index_population.memory_addressMany-to-one

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

Community Additions

ADD
Show:
© 2016 Microsoft