sys.dm_fts_index_population (Transact-SQL)sys.dm_fts_index_population (Transact-SQL)

适用于: 是SQL Server是Azure SQL 数据库否Azure SQL 数据仓库否并行数据仓库APPLIES TO: yesSQL Server yesAzure SQL Database noAzure SQL Data Warehouse noParallel Data Warehouse

返回有关 SQL ServerSQL Server 中当前正在进行的全文索引填充和语义关键字短语填充的信息。Returns information about the full-text index and semantic key phrase populations currently in progress in SQL ServerSQL Server.

列名Column name 数据类型Data type 描述Description
database_iddatabase_id intint 包含正在填充的全文索引的数据库 ID。ID of the database that contains the full-text index being populated.
catalog_idcatalog_id intint 包含此全文索引的全文目录的 ID。ID of the full-text catalog that contains this full-text index.
table_idtable_id intint 其全文索引正在被填充的表的 ID。ID of the table for which the full-text index is being populated.
memory_addressmemory_address varbinary(8)varbinary(8) 用于表示活动填充的内部数据结构的内存地址。Memory address of the internal data structure that is used to represent an active population.
population_typepopulation_type intint 填充类型。Type of population. 可以是以下类型之一:One of the following:

1 = 完全填充1 = Full population

2 = 基于时间戳的增量式填充2 = Incremental timestamp-based population

3 = 对跟踪的更改进行手动更新3 = Manual update of tracked changes

4 = 对跟踪的更改进行后台更新。4 = Background update of tracked changes.
population_type_descriptionpopulation_type_description nvarchar(120)nvarchar(120) 对填充类型的说明。Description for type of population.
is_clustered_index_scanis_clustered_index_scan bitbit 指示填充是否涉及对聚集索引的扫描。Indicates whether the population involves a scan on the clustered index.
range_countrange_count intint 并行执行填充的子范围数。Number of sub-ranges into which this population has been parallelized.
completed_range_countcompleted_range_count intint 处理完成的范围数。Number of ranges for which processing is complete.
outstanding_batch_countoutstanding_batch_count intint 此填充当前未完成的批处理个数。Current number of outstanding batches for this population. 有关详细信息,请参阅sys.dm_fts_outstanding_batches (TRANSACT-SQL)For more information, see sys.dm_fts_outstanding_batches (Transact-SQL).
statusstatus intint 适用范围SQL Server 2012 (11.x)SQL Server 2012 (11.x)SQL Server 2017SQL Server 2017Applies to: SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2017SQL Server 2017.

此填充的状态。Status of this Population. 说明:某些状态是暂时的。Note: some of the states are transient. 可以是以下类型之一:One of the following:

3 = 正在启动3 = Starting

5 = 正常处理5 = Processing normally

7 = 已停止处理7 = Has stopped processing

例如,正在进行自动合并时将出现此状态。For example, this status occurs when an auto merge is in progress.

11 = 已中止填充11 = Population aborted

12 = 处理语义相似性提取12 = Processing a semantic similarity extraction
status_descriptionstatus_description nvarchar(120)nvarchar(120) 对填充状态的说明。Description of status of the population.
completion_typecompletion_type intint 有关填充完成的状态。Status of how this population completed.
completion_type_descriptioncompletion_type_description nvarchar(120)nvarchar(120) 完成类型的说明。Description of the completion type.
worker_countworker_count intint 此值始终为 0。This value is always 0.
queued_population_typequeued_population_type intint 基于跟踪更改的填充类型,此类填充将在当前填充(如果存在)之后发生。Type of the population, based on tracked changes, which will follow the current population, if any.
queued_population_type_descriptionqueued_population_type_description nvarchar(120)nvarchar(120) 对随后要进行的填充(如果存在)的说明。Description of the population to follow, if any. 例如,当 CHANGE TRACKING = AUTO 并且正在进行初始完全填充时,此列将显示“自动填充”。For example, when CHANGE TRACKING = AUTO and the initial full population is in progress, this column would show "Auto population."
start_timestart_time datetimedatetime 填充开始的时间。Time that the population started.
incremental_timestampincremental_timestamp timestamptimestamp 表示完全填充的开始时间戳。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.


如果除了全文索引之外还启用了统计语义索引,则关键字短语的语义提取和填充以及文档相似性数据的提取与全文索引同时发生。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.


SQL ServerSQL Server,需要VIEW SERVER STATE权限。On SQL ServerSQL Server, requires VIEW SERVER STATE permission.
SQL 数据库SQL Database高级层,需要VIEW DATABASE STATE数据库中的权限。On SQL 数据库SQL Database Premium Tiers, requires the VIEW DATABASE STATE permission in the database. SQL 数据库SQL Database标准版和基本层,需要服务器管理员Azure Active Directory 管理员帐户。On SQL 数据库SQL Database Standard and Basic Tiers, requires the Server admin or an Azure Active Directory admin account.

物理联接Physical Joins

此动态管理视图的重要联接Significant joins of this dynamic management view

关系基数Relationship Cardinalities

FromFrom 若要To 关系Relationship
dm_fts_active_catalogs.database_iddm_fts_active_catalogs.database_id dm_fts_index_population.database_iddm_fts_index_population.database_id 一对一One-to-one
dm_fts_active_catalogs.catalog_iddm_fts_active_catalogs.catalog_id dm_fts_index_population.catalog_iddm_fts_index_population.catalog_id 一对一One-to-one
dm_fts_population_ranges.parent_memory_addressdm_fts_population_ranges.parent_memory_address dm_fts_index_population.memory_addressdm_fts_index_population.memory_address 多对一Many-to-one

请参阅See Also

动态管理视图和函数 (Transact-SQL) Dynamic Management Views and Functions (Transact-SQL)
全文搜索和语义搜索动态管理视图和函数(Transact SQL)Full-Text Search and Semantic Search Dynamic Management Views and Functions (Transact-SQL)