max full-text crawl range 服务器配置选项max full-text crawl range Server Configuration Option

适用对象:是SQL Server 否Azure SQL 数据库 否Azure Synapse Analytics (SQL DW) 否并行数据仓库APPLIES TO: yesSQL Server noAzure SQL Database noAzure Synapse Analytics (SQL DW) noParallel Data Warehouse

使用 max full-text crawl range 选项可以优化 CPU 使用率,从而提高完全爬网时的爬网性能。Use the max full-text crawl range option to optimize CPU utilization, which improves crawl performance during a full crawl. 使用此选项,可以指定索引完全爬网时 MicrosoftMicrosoft SQL ServerSQL Server 使用的分区数。Using this option, you can specify the number of partitions that MicrosoftMicrosoft SQL ServerSQL Server should use during a full index crawl. 例如,如果有许多 CPU 且它们的使用率并非最佳,则可以增加此选项的最大值。For example, if there are many CPUs and their utilization is not optimal, you can increase the maximum value of this option. 除了此选项以外, SQL ServerSQL Server 还使用众多其他因素(如表中的行数和 CPU 数)来确定应该使用的实际分区数。In addition to this option, SQL ServerSQL Server uses a number of other factors, such as the number of rows in the table and the number of CPUs, to determine the actual number of partitions used.

此选项的默认值是 4;最小值是 1,最大值是 256。The default value of this option is 4; the minimum value is 1, and the maximum value is 256. 对此选项所做的更改只会影响后续的爬网。Changes made to this option affect only subsequent crawls. 不会影响正在进行的爬网。Crawls in process will not be affected by a change in this option setting.

max full-text crawl range 选项是一个高级选项。The max full-text crawl range option is an advanced option. 如果使用 sp_configure 系统存储过程来更改该设置,则仅当 显示高级选项 设置为 1 时才能更改 max full-text crawl range (全文爬网最大范围)。If you are using the sp_configure system stored procedure to change the setting, you can change max full-text crawl range only when show advanced options is set to 1. 该设置将立即生效,无需重新启动服务器。The setting takes effect immediately without a server restart.

另请参阅See Also

服务器配置选项 (SQL Server) Server Configuration Options (SQL Server)
sp_configure (Transact-SQL)sp_configure (Transact-SQL)