|
|
|
Grasshopper
      
Group: General Forum Members
Last Login: Sunday, March 31, 2013 7:02 AM
Points: 22,
Visits: 280
|
|
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).
|
|
|
|
|
Old Hand
      
Group: General Forum Members
Last Login: Thursday, May 09, 2013 5:59 AM
Points: 389,
Visits: 140
|
|
We have twice as much of Memory allocated as pagefile.
Is there a threshold or related impact on having such a setup?
|
|
|
|
|
SSC Rookie
      
Group: General Forum Members
Last Login: Thursday, April 18, 2013 9:52 PM
Points: 28,
Visits: 169
|
|
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
|
|
|
|
|
Say Hey Kid
      
Group: General Forum Members
Last Login: Wednesday, May 01, 2013 5:17 PM
Points: 701,
Visits: 207
|
|
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)
|
|
|
|
|
Hall of Fame
       
Group: General Forum Members
Last Login: Friday, March 15, 2013 2:43 PM
Points: 3,924,
Visits: 1,554
|
|
[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.
|
|
|
|
|
Ten Centuries
      
Group: General Forum Members
Last Login: Yesterday @ 2:11 PM
Points: 1,409,
Visits: 4,506
|
|
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]
|
|
|
|
|
Old Hand
      
Group: General Forum Members
Last Login: Thursday, May 09, 2013 5:59 AM
Points: 389,
Visits: 140
|
|
We have page file as 32gigs as opposed to 16gigs of memory
Hope it doesn't do any harm
|
|
|
|
|
Ten Centuries
      
Group: General Forum Members
Last Login: Yesterday @ 2:11 PM
Points: 1,409,
Visits: 4,506
|
|
|
|
|
|
Say Hey Kid
      
Group: General Forum Members
Last Login: Wednesday, May 01, 2013 5:17 PM
Points: 701,
Visits: 207
|
|
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).
|
|
|
|
|
Forum 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.
|
|
|
|