August 6, 2013 at 1:03 am
Hi, we are planning to upgrade the ram in our SQL 2008 R2 cluster running on Windows 2008 R2. Both SQL and Windows are Ent edition. currently the two nodes have 32GB of memory each, we already purchased 2 x 32GB memory upgrades for these servers. Now normally i just hard configure the Windows pagefile to the Windows recommend size but in this case when we upgrade the memory in the server to 64GB the C: probably wont have much free space left to set the Page file to 96GB.
If i set the page file to say 72GB the system meory plus 8GB will this be enough for successful crash dumps?
Recommendations?
August 6, 2013 at 3:09 am
You don't need that much page file. SQL shouldn't be using the page file at all and all that's needed with crash dumps, except in rare circumstances are kernel or mini dumps
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 6, 2013 at 5:41 pm
Great thanks, in that case i might just leave the page file at the current 48GB file size.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy