| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | helpviewer_keywords | dev_langs | |||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
max full-text crawl range (server configuration option) |
Find out about the max full-text crawl range option. See how it optimizes SQL Server CPU utilization to improve crawl performance during a full crawl. |
rwestMSFT |
randolphwest |
03/02/2017 |
sql |
configuration |
conceptual |
|
|
[!INCLUDE SQL Server]
Use the max full-text crawl range option to optimize CPU utilization, which improves crawl performance during a full crawl. Using this option, you can specify the number of partitions that [!INCLUDEmsCoName] [!INCLUDEssNoVersion] should use during a full index crawl. For example, if there are many CPUs and their utilization is not optimal, you can increase the maximum value of this option. In addition to this option, [!INCLUDEssNoVersion] 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.
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.
The max full-text crawl range option is an advanced option. 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.
RECONFIGURE (Transact-SQL)
Server Configuration Options (SQL Server)
sp_configure (Transact-SQL)