sp_fulltext_service 'resource_usage' , n
where n is a value from 1 to 5 representing low to high priority respectively.
Saturday, 1 July 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.
where n is a value from 1 to 5 representing low to high priority respectively.
where n is a value from 1 to 5 representing low to high priority respectively.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment