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 Tuesday, August 17, 2010 9:56 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Sunday, March 23, 2014 1:28 AM
Points: 22, Visits: 292
Comments posted to this topic are about the item Can you set a pagefile more than 4GB?
Post #970874
Posted Wednesday, August 18, 2010 1:45 AM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, December 20, 2013 8:21 AM
Points: 61, Visits: 699
Hi Stanley, thanks to share.

Can you tell us whether your server is 32 or 64 bits ?

David B.


David B.
Post #970961
Posted Wednesday, August 18, 2010 2:13 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, July 03, 2011 7:09 AM
Points: 258, Visits: 494
David BAFFALEUF (8/18/2010)
Hi Stanley, thanks to share.

Can you tell us whether your server is 32 or 64 bits ?

David B.


I know where this is going. If it's a 32-bit machine, it can't address more than 4GB of memory.


Random Technical Stuff
Post #970973
Posted Wednesday, August 18, 2010 2:44 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, November 25, 2010 6:54 AM
Points: 71, Visits: 88
Hi,

Nice article, but it's worth to mention that it won't work with different paging files spread around different partitions. Unless you have enough free space on c:\ the dumps will be corrupt. We had it a lot of times and did multiple investigations - dumps will be actually cached on first paging file (on drive c: usually) before they will get copied to the other paging files.

So either you make your first paging file large enough, or you won't get a dump that can be fully analyzed.

In case you don't have enough space left, you should rather go for a "kernel memory dump" which fits the needs for analysis in about 98% of all cases. (Actually a bluescreen can happens in the priviledged kernel mode, this the inital stacktrace/trigger will always be visible in the kernel dump, the further analysis however can get stuck at a certain point as user memory is missing)

regards

Andreas
Post #970990
Posted Wednesday, August 18, 2010 5:58 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Sunday, March 23, 2014 1:28 AM
Points: 22, Visits: 292
David BAFFALEUF (8/18/2010)
Hi Stanley, thanks to share.

Can you tell us whether your server is 32 or 64 bits ?

David B.


They are 32 bits.
Post #971049
Posted Wednesday, August 18, 2010 5:59 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Sunday, March 23, 2014 1:28 AM
Points: 22, Visits: 292
ta.bu.shi.da.yu (8/18/2010)
David BAFFALEUF (8/18/2010)
Hi Stanley, thanks to share.

Can you tell us whether your server is 32 or 64 bits ?

David B.


I know where this is going. If it's a 32-bit machine, it can't address more than 4GB of memory.


Hi David,

With Windows Server 2003 Enterpise Edition, and PAE switch in boot.ini, it can address more than 4GB memory.
Post #971050
Posted Wednesday, August 18, 2010 6:33 AM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, December 20, 2013 8:21 AM
Points: 61, Visits: 699
Hi,

Thanks for your answers. I know PAE allows windows to go beyond the 4Gb boundary. I was rather interested because in the referenced KB article, it is said :

"The Complete memory dump option is not available on computers that are running a 32-bit operating system and that have 2 gigabytes (GB) or more of RAM. (...) "

David B.




David B.
Post #971068
Posted Wednesday, August 18, 2010 7:04 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, April 03, 2014 12:46 PM
Points: 1,413, Visits: 4,531
Stanley Chan (8/18/2010)
ta.bu.shi.da.yu (8/18/2010)
David BAFFALEUF (8/18/2010)
Hi Stanley, thanks to share.

Can you tell us whether your server is 32 or 64 bits ?

David B.


I know where this is going. If it's a 32-bit machine, it can't address more than 4GB of memory.


Hi David,

With Windows Server 2003 Enterpise Edition, and PAE switch in boot.ini, it can address more than 4GB memory.


there are a lot of limitations in how it addresses the RAM above 4GB. this is why we are replacing all 32bit servers with x64 ones


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 #971099
Posted Wednesday, August 18, 2010 7:45 AM
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: 2 days ago @ 11:58 AM
Points: 3,924, Visits: 1,588
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.


SQL DBA.
Post #971136
Posted Wednesday, August 18, 2010 7:47 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Sunday, March 23, 2014 1:28 AM
Points: 22, Visits: 292
ab.sqlservercentral (8/18/2010)
Hi,

Nice article, but it's worth to mention that it won't work with different paging files spread around different partitions. Unless you have enough free space on c:\ the dumps will be corrupt. We had it a lot of times and did multiple investigations - dumps will be actually cached on first paging file (on drive c: usually) before they will get copied to the other paging files.

So either you make your first paging file large enough, or you won't get a dump that can be fully analyzed.

In case you don't have enough space left, you should rather go for a "kernel memory dump" which fits the needs for analysis in about 98% of all cases. (Actually a bluescreen can happens in the priviledged kernel mode, this the inital stacktrace/trigger will always be visible in the kernel dump, the further analysis however can get stuck at a certain point as user memory is missing)

regards

Andreas


Andreas,
Thanks for your comments. Yes, it requires a single page file in C: which is big enough. For those servers with more than 64GB memory, it is not common to have a large enough C:.
Post #971138
« Prev Topic | Next Topic »

Add to briefcase 1234»»»

Permissions Expand / Collapse