Regarding the Page file size in Clustered environment:

Question

Regarding the Page file size in Clustered environment:

gary1

SSC-Insane

Points: 21152
More actions
January 19, 2010 at 1:06 pm

#219716

Hi,
We have Active/Active/Passive cluster setup for SQL Server 2005 EE x64 with SP3. We have only C drive as local drive on all of the 3 nodes with default page file size 2046 MB on C drive. We have 16 GB of RAM and the Max memory for SQL instance is set to 13 GB and 3 GB is left for OS. From Quest Spot light monitoring tool, I'm getting Low virtual memory alert
Used Virtual memory (committed ) is 15, 440
Free Virtual memory is down to 16% And
paging files:
showing used space as 67 MB out of the 2 GB.
After talking to some of the DBAs and seraching on the forums, I came to know that on clustered Servers, we need to have separate local drive (other than OS drive) on all the nodes and have the page file size 1.5 times the RAM.
Please advice

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

gary1 SSC-Insane Points: 21152 More actions · Answer 1

Could you please give me some inputs on the Page file settings, size on Clustered SQL Servers on x64 Windows 2003 servers

gary1 SSC-Insane Points: 21152 More actions · Answer 2

I Appreciate if some body shed some light on having (requirement of) separate local drive for page file and page file size = ~1.5 times of RAM in a clustered environment

thanks

Joie Andrew One Orange Chip Points: 27360 More actions · Answer 3

If you had a dedicated drive for your page file, then it could definitely help in performance, although if you do not have a certain amount of space also reserved on the c: drive then you lose the capability of saving memory dumps when systems go down.

As for the 1.5GB rule, that was more of a standard when the standard amount of memory in servers was not larger than 4-8GB. With 16GB you very well may not need a page file 1.5 times the size of of your RAM. If you have the space for it, then go for it, otherwise, I would size it to something more reasonable depending on the load on the server.

What are the settings currently set at?

Joie Andrew
"Since 1982"

gary1 SSC-Insane Points: 21152 More actions · Answer 4

Currently, on C drive(we have only one local drive i.e C), the page file is set to default size of 2046 MB

Thank you