Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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 |
|