全文檢索搜耙最大範圍伺服器組態選項max full-text crawl range Server Configuration Option

適用於: 是SQL Server 否Azure SQL Database 否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 系統預存程序來變更設定,只有當 show advanced options 設為 1 時,才能變更 max full-text crawl rangeIf 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

RECONFIGURE (Transact-SQL) RECONFIGURE (Transact-SQL)
伺服器組態選項 (SQL Server) Server Configuration Options (SQL Server)
sp_configure (Transact-SQL)sp_configure (Transact-SQL)