sys-dm-fts-index-population-transact-sql.md

title	sys.dm_fts_index_population (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/29/2017
ms.prod	sql
ms.prod_service	database-engine, sql-database
ms.reviewer
ms.technology	system-objects
ms.topic	language-reference
f1_keywords	sys.dm_fts_index_population dm_fts_index_population sys.dm_fts_index_population_TSQL dm_fts_index_population_TSQL
dev_langs	TSQL
helpviewer_keywords	sys.dm_fts_index_population dynamic management view
ms.assetid	82d1c102-efcc-4b60-9a5e-3eee299bcb2b
author	pmasl
ms.author	pelopes
monikerRange	=azuresqldb-current||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current

sys.dm_fts_index_population (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-asdb-xxxx-xxx-md]

Returns information about the full-text index and semantic key phrase populations currently in progress in [!INCLUDEssNoVersion].

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)	Memory address of the internal data structure that is used to represent an active 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	Current number of outstanding batches for this population. For more information, see sys.dm_fts_outstanding_batches (Transact-SQL).
status	int	Applies to: [!INCLUDEssSQL11] and later. 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 12 = Processing a semantic similarity extraction
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	This value is always 0.
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. For example, when CHANGE TRACKING = AUTO and the initial full population is in progress, this column would show "Auto population."
start_time	datetime	Time that 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.

Remarks

When statistical semantic indexing is enabled in addition to full-text indexing, the semantic extraction and population of key phrases, and the extraction of document similarity data, occur simultaneously with full-text indexing. The population of the document similarity index occurs later in a second phase. For more information, see Manage and Monitor Semantic Search.

Permissions

On [!INCLUDEssNoVersion_md], requires VIEW SERVER STATE permission.
On [!INCLUDEssSDS_md] Premium Tiers, requires the VIEW DATABASE STATE permission in the database. On [!INCLUDEssSDS_md] Standard and Basic Tiers, requires the Server admin or an Azure Active Directory admin account.

Physical Joins

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

See Also

Dynamic Management Views and Functions (Transact-SQL)
Full-Text Search and Semantic Search Dynamic Management Views and Functions (Transact-SQL)