Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

SQL Server 2008 R2 Full-text search engine (FTS) is taking up too much resource (I/O & Memory) in my production server. (migrated from SQL server 2005).

I have been reading up on SQL Server FTS engine Internals and Enhancements and there was a suggestion on how to improve FTS performance under Performance Improvements section

Increase the page file size if applicable.

But it doesn't mention how much page file size should be increased by. Should it be adjusted thru trial & error? or is there a rule of thumb I can follow?

share|improve this question

From here:

The virtual memory (PAGEFILE.SYS file) setting for your operating system should be set to an amount equal to 3 times the amount of physical RAM in the server.

For example, if physical RAM is 8GB, then ideally you should allocate 24GB to VM.

You may be able to get away with less (1x-2x) but you'll need to perform some load testing to verify that.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.