Saturday, July 1, 2006

Full Text Indexes - Indexing Priority

To set the priority for full text indexes i.e. how much processor is dedicated to performing the indexing process (and consequently how quickly the job completes), use the following command.

sp_fulltext_service 'resource_usage' , n


where n is a value from 1 to 5 representing low to high priority respectively.

No comments: