2

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.

2

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.

  • 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

By clicking "Post Your Answer", you agree to our terms of service, privacy policy and cookie policy

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