Returns information about the full-text index populations currently in progress.
Beginning in SQL Server 2008, the meanings of the following columns have changed: memory_address, outstanding_batch_count, status, and worker_count.
ID of the database that contains the full-text index being populated.
ID of the full-text catalog that contains this full-text index.
ID of the table for which the full-text index is being populated.
Memory address of the internal data structure that is used to represent an active population.
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.
Description for type of population.
Indicates whether the population involves a scan on the clustered index.
Number of sub-ranges into which this population has been parallelized.
Number of ranges for which processing is complete.
Current number of outstanding batches for this population. For more information, see sys.dm_fts_outstanding_batches (Transact-SQL).
Status of this Population. Note: some of the states are transient. One of the following:
3 = Starting
5 = Processing normally
7 = Has stopped processing
For example, this status occurs when an auto merge is in progress.
11 = Population aborted
Description of status of the population.
Status of how this population completed.
Description of the completion type.
This value is always 0.
Type of the population, based on tracked changes, which will follow the current population, if any.
Description of the population to follow, if any. For example, when CHANGE TRACKING = AUTO and the initial full population is in progress, this column would show "Auto population."
Time that the population started.
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.