up vote 2 down vote favorite
1
share [g+] share [fb]

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.

link|improve this question
80% accept rate
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
feedback

1 Answer

up vote 2 down vote

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.

link|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
feedback

Your Answer

 
or
required, but never shown
discard

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