sys.dm_fts_index_population
Returns information about the full-text index populations currently in progress.
| Column name | Data type | Description |
|---|---|---|
database_id |
int |
ID of the database that contains the full-text index being populated. |
catalog_id |
int |
ID of the full-text catalog that contains this full-text index. |
table_id |
int |
ID of the table for which the full-text index is being populated. |
memory_address |
varbinary(8) |
Address of the memory buffers allocated for the current population. |
population_type |
int |
Type of population. One of the following: 1 = Full population 2 = Incremental timestamp-based population 3 = Manual update of tracked changes 4 = Background update of tracked changes. |
population_type_description |
nvarchar(120) |
Description for type of population. |
is_clustered_index_scan |
bit |
Indicates whether the population involves a scan on the clustered index. |
range_count |
int |
Number of sub-ranges into which this population has been parallelized. |
completed_range_count |
int |
Number of ranges for which processing is complete. |
outstanding_batch_count |
int |
Number of work batches processed since the last population check point. |
status |
int |
Status of this Population. Note: some of the states are transient. One of the following: 0 = New population 1 = Resume on database startup 2 = Temporary error 3 = Starting 4 = Resuming after temporary error 5 = Processing normally 6 = Stopping 7 = Has stopped processing 8 = Encountered row-level errors that will be retried 9 = Starting retry phase 10 = Processing retries |
status_description |
nvarchar(120) |
Description of status of the population. |
completion_type |
int |
Status of how this population completed. |
completion_type_description |
nvarchar(120) |
Description of the completion type. |
worker_count |
int |
Number of worker tasks currently processing this population. |
queued_population_type |
int |
Type of the population, based on tracked changes, which will follow the current population, if any. |
queued_population_type_description |
nvarchar(120) |
Description of the population to follow, if any. |
start_time |
datetime |
Time the population started. |
incremental_timestamp |
timestamp |
Represents the starting timestamp for a full population. For all other population types this value is the last committed checkpoint representing the progress of the populations. |
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_active_catalogs.database_id |
dm_fts_index_population.database_id |
One-to-one |
dm_fts_active_catalogs.catalog_id |
dm_fts_index_population.catalog_id |
One-to-one |
dm_fts_population_ranges.parent_memory_address |
dm_fts_index_population.memory_address |
Many-to-one |
Examples
The following example returns all full populations currently active on the server.
SELECT * FROM sys.dm_fts_index_population
WHERE population_type = 1
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 |
|