Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Can you set a pagefile more than 4GB?


Can you set a pagefile more than 4GB?

Author
Message
Stanley Chan
Stanley Chan
Grasshopper
Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)

Group: General Forum Members
Points: 24 Visits: 301
Comments posted to this topic are about the item Can you set a pagefile more than 4GB?
David BAFFALEUF
David BAFFALEUF
Valued Member
Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)

Group: General Forum Members
Points: 65 Visits: 712
Hi Stanley, thanks to share.

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

David B.

David B.
ta.bu.shi.da.yu
ta.bu.shi.da.yu
SSC Veteran
SSC Veteran (249 reputation)SSC Veteran (249 reputation)SSC Veteran (249 reputation)SSC Veteran (249 reputation)SSC Veteran (249 reputation)SSC Veteran (249 reputation)SSC Veteran (249 reputation)SSC Veteran (249 reputation)

Group: General Forum Members
Points: 249 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
ab.sqlservercentral
ab.sqlservercentral
Valued Member
Valued Member (71 reputation)Valued Member (71 reputation)Valued Member (71 reputation)Valued Member (71 reputation)Valued Member (71 reputation)Valued Member (71 reputation)Valued Member (71 reputation)Valued Member (71 reputation)

Group: General Forum Members
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
Stanley Chan
Stanley Chan
Grasshopper
Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)

Group: General Forum Members
Points: 24 Visits: 301
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.
Stanley Chan
Stanley Chan
Grasshopper
Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)

Group: General Forum Members
Points: 24 Visits: 301
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.
David BAFFALEUF
David BAFFALEUF
Valued Member
Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)

Group: General Forum Members
Points: 65 Visits: 712
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.
alen teplitsky
alen teplitsky
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1595 Visits: 4621
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
SanjayAttray
SanjayAttray
Hall of Fame
Hall of Fame (4K reputation)Hall of Fame (4K reputation)Hall of Fame (4K reputation)Hall of Fame (4K reputation)Hall of Fame (4K reputation)Hall of Fame (4K reputation)Hall of Fame (4K reputation)Hall of Fame (4K reputation)

Group: General Forum Members
Points: 3953 Visits: 1619
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.
Stanley Chan
Stanley Chan
Grasshopper
Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)

Group: General Forum Members
Points: 24 Visits: 301
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:.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search