Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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
add comment

1 Answer

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
add comment

Your Answer

 
discard

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.