Home / server / Questions / 168471
In Process
dance2die
Asked: 2010-08-10 04:28:57 +0800 CST

How much to increase page file value for SQL Server 2008 R2 Full Text Search Engine

  • 772

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?

sql-server pagefile full-text-search sql-server-2008-r2

1 Answers

  1. 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.

    • 0