• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 619
  • 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

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

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