Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««1234»»»

Can you set a pagefile more than 4GB? Expand / Collapse
Author
Message
Posted Wednesday, August 18, 2010 8:41 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, June 17, 2014 9:33 PM
Points: 22, Visits: 297
SanjayAttray (8/18/2010)
I had to change it to 6 GB from default size of 2 GB on a production server few days back. Also, by default pagefile.sys is located in C:\ drive and now changed to D:\ as C:\ generally had a low on space than compared to other drives.

another bad while changing the size or path to this file is that you have to reboot server to take it effected and would recommend all to do in a maintenance window period.

I have to change the size and path on a clustered environment and had to figure it how ? As this file should be on local drives only. Had any body had made changes on Clustered A\P environment ? Kindly post how.

Thanks.


Sanjay,

It doesn't matter how the pagefile defined in Clustered environment.
e.g. Node A has a 2GB pagefile in C: only, node B has a 4GB pagefile in D: only.
If the cluster group hosts on node A, the cluster has 2GB pagefile in C: (that's what Node A configured). If the cluster group failover to node B, the cluster has 4GB pagefile in D: only (that's what Node B configured).
Post #971192
Posted Wednesday, August 18, 2010 10:02 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, May 6, 2014 4:49 PM
Points: 389, Visits: 154
We have twice as much of Memory allocated as pagefile.

Is there a threshold or related impact on having such a setup?
Post #971257
Posted Wednesday, August 18, 2010 10:46 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, December 11, 2014 6:14 AM
Points: 28, Visits: 186
This is good information to know. I hate to get negative on MS but I have to:

Why should a professional server administrator need to resort to "tricks" and "hacks" to do something--not only normal--but *required* if one wants to actually support a mission-critical machine? Why couldn't one just set the pagefile size--or--better yet--have it default to the minimum required?
My questions are rhetoric, this is just a head-shaker.
---Jim
Post #971297
Posted Wednesday, August 18, 2010 1:01 PM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Monday, October 21, 2013 4:37 PM
Points: 701, Visits: 211
I use the /PAE boot.ini switch on a 32-bit windows XP workstation with 4GB of RAM. It not only lets me use 3.25GB of that RAM, it lets me set the paging file to whatever size I want (I set to 8GB initial 16GB max)


Post #971392
Posted Wednesday, August 18, 2010 1:01 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, July 17, 2014 10:56 AM
Points: 3,924, Visits: 1,607
[b]Stanley Chan

Sanjay,

It doesn't matter how the pagefile defined in Clustered environment.
e.g. Node A has a 2GB pagefile in C: only, node B has a 4GB pagefile in D: only.
If the cluster group hosts on node A, the cluster has 2GB pagefile in C: (that's what Node A configured). If the cluster group failover to node B, the cluster has 4GB pagefile in D: only (that's what Node B configured).


Thanks for explanation, Stanley .


SQL DBA.
Post #971393
Posted Wednesday, August 18, 2010 1:18 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, December 15, 2014 1:02 PM
Points: 1,414, Visits: 4,545
Nitya (8/18/2010)
We have twice as much of Memory allocated as pagefile.

Is there a threshold or related impact on having such a setup?


i know someone who used to set it with the minimum and maximum sizes being the same. i thought he was crazy and it used to annoy me until i read that it cuts down on fragmentation in an active paging file. downside is that if you need more space than what you assign, then it's going to slow the server down by a lot.


https://plus.google.com/100125998302068852885/posts?hl=en
http://twitter.com/alent1234
x-box live gamertag: i am null
[url=http://live.xbox.com/en-US/MyXbox/Profile[/url]
Post #971405
Posted Wednesday, August 18, 2010 1:33 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, May 6, 2014 4:49 PM
Points: 389, Visits: 154
We have page file as 32gigs as opposed to 16gigs of memory

Hope it doesn't do any harm
Post #971421
Posted Wednesday, August 18, 2010 1:35 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, December 15, 2014 1:02 PM
Points: 1,414, Visits: 4,545
on our 64bit servers with 32GB of RAM i set it as 32GB - 64GB and don't remember the last time it grew past 32GB

https://plus.google.com/100125998302068852885/posts?hl=en
http://twitter.com/alent1234
x-box live gamertag: i am null
[url=http://live.xbox.com/en-US/MyXbox/Profile[/url]
Post #971424
Posted Wednesday, August 18, 2010 1:40 PM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Monday, October 21, 2013 4:37 PM
Points: 701, Visits: 211
4x RAM is more than plenty. I think most machines get unstable when they start using more than 2x and machines with adequate ram will never hit 2x RAM on page file usage unless there is a major memory leak problem with the software (and the leaked ram is usually paged-out and 'forgotten about' if it is no longer referenced).


Post #971430
Posted Wednesday, August 18, 2010 7:47 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, August 24, 2010 1:18 AM
Points: 1, Visits: 16
Hi Stanley,

A very informative and detailed article. Just one point to add to keep the system running efficiently we keep pagefile size 1.5 times of RAM in most of the Windows 2000 and Windows 2003 kept in 2 partitions.

Would like to know your opinion on this.
Post #971565
« Prev Topic | Next Topic »

Add to briefcase ««1234»»»

Permissions Expand / Collapse