Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

sys.dm_fts_population_ranges (Transact-SQL)

Applies To: SQL Server 2014, SQL Server 2016 Preview

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

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

Applies to: SQL Server (SQL Server 2008 through current version).

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.

Requires VIEW SERVER STATE permission on the server.

From

To

Relationship

dm_fts_population_ranges.parent_memory_address

dm_fts_index_population.memory_address

Many-to-one

Community Additions

ADD
Show:
© 2015 Microsoft