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

Is there a definitive guide for PageFile size on the latest 64-bit servers with large amounts of RAM?

I've seen conflicting recommendations, and am wondering if the latest releases have changed the recommendations.

share|improve this question
    
What you should set the Pagefile to is highly dependent on what the server is doing. –  Chris S Oct 1 '11 at 2:50
    
Here's a MS reference support.microsoft.com/kb/889654 –  Darian Miller Oct 1 '11 at 3:01

1 Answer 1

When running SQL Server on a box with a lot of RAM set the page file to about 6 Gigs. SQL Server won't swap to disk unless something really wrong happens and allocating 192 gigs of disk space to a page file that will never be used is insane.

share|improve this answer
    
What about the referrals to always setting your page file size to RAM x 1.5 since that's what Windows expects? –  Darian Miller Oct 1 '11 at 2:55
    
Here's one reference: rusanu.com/2009/11/22/… –  Darian Miller Oct 1 '11 at 2:58
    
On the flip side, the comment on this link: sqlblog.com/blogs/buck_woody/archive/2010/06/29/… by Remus Rusanu disputes the 1.5x requirement. –  Darian Miller Oct 1 '11 at 3:07
    
They are outdated. Old times (little ram) and generic - with SQL Server pecial rules apply as SQL Server basically uses the RAM as cache so it does not hit the disc (slow). Having the cache cached out to disc sort of makes it redundant to start with. –  TomTom Oct 1 '11 at 5:59

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.