sys.dm_fts_population_ranges
Returns information about the specific crawl ranges related to a full-text index population currently in progress. A crawl range is a work task on one part of a table that returns data to the full-text search service.
| 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. |
error_count |
int |
Number of rows that have encountered errors by this range. |
Permissions
Requires VIEW SERVER STATE permission on the server.
Physical Joins
.gif "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 |
Examples
The following example returns all tables that are currently being worked on by at least one crawl range.
SELECT DISTINCT database_id, table_id
FROM sys.dm_fts_index_population population
JOIN sys.dm_fts_population_ranges ranges
ON (population.memory_address = ranges.parent_memory_address)
WHERE ranges.session_id <> 0
See Also
Reference
Dynamic Management Views and Functions
Full-Text Search Related Dynamic Management Views
Help and Information
Getting SQL Server 2005 Assistance
Change History
| Release | History |
|---|---|
12 December 2006 |
|