• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 622
  • Last Modified:

SQL 2008 R2 Page File Size

Hello everyone,

We have 4 sql servers which have 96 GB Memory each.

During the build we didn't se the page file size.

By default pagefile size is 96 GB.

Is there any recomendation for setting up page file size?

We dont want pagefile to be utilizing 96GB disk space in C volume.

Please advice us?


Jaya
0
shankarvetrivel
Asked:
shankarvetrivel
2 Solutions
 
dqmqCommented:
It's a little hard to advise on that because there are so many interacting variables. Since you have a huge amount of RAM memory, maybe you don't need any paging space. :>).   I think something like 1-2 times your ram is a common recommendation.

Also, you might want to consider cross-posting this in a Windows Server forum.
0
 
TempDBACommented:
Here is a kb article that explains it:-
http://support.microsoft.com/kb/889654/en-us

You would also like to look into the existing discussion:-
http://stackoverflow.com/questions/2588/appropriate-pagefile-size-for-sql-server
0
 
Ramesh Babu VavillaCommented:
microsoft suggests page file can be 150% of installed RAM
0
 
Anthony PerkinsCommented:
2 GB.  See Brent Ozar's blog here:
http://www.brentozar.com/archive/2008/03/sql-server-2005-setup-checklist-part-1-before-the-install/

Incidentally anyone who still recommends 1.5 the size of memory is clearly delusional or living in the past.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now