Page file settings - MS Server 2012 on Hyper V environment


Please advise what would be the ideal/preferred page file size for a 2012 server running mainly SQL 2012

The server is a virtual server on a Hyper-V host and has 47Gb virtual memory assigned.

Windows Paging is currently set to Automatic.

Server 2012 has the following recommendation:
Minimum of 16Mb
Ideal Page file of 9599MB
Currently the page has over grown due to a faulty SQL action and is sitting at: 55051Mb leaving no free space on the C drive.

It would be great to get a second opinion: I was thinking to setting the page file to 20Gb and maximum of 25GB.

Quintin SmithAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

David Johnson, CD, MVPOwnerCommented:
how much memory have you allocated for SQL Server the default max memory for SQL server is some ridiculous amount like 16TB
Quintin SmithAuthor Commented:
Good point. I did not setup the SQL side. I see it has 48128MB assigned.
My C: drive only has 36GB free :-(

I could increase the C drive space a little but still would like to know what would be ideal. I can't move the page file to another drive.

So I guess I need to make a call to add more space but how much to accommodate a good page file for my 47gb ram

Any suggestions?
David Johnson, CD, MVPOwnerCommented:
Total VM Size 47 GB, SQL allowed to use 47GB... Should you not at least carve out 4-8GB for the operating system? If you look at the memory resources under a normal workload what is the committed and in use memory? the difference is your paged pool.. The standard rule of thumb is to have a page file that is 1.5x the amount of memory.

Are you near the limit of 2TB for a vhd? and that is why you can't make the drive larger?
Has Powershell sent you back into the Stone Age?

If managing Active Directory using Windows Powershell® is making you feel like you stepped back in time, you are not alone.  For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why.

Quintin SmithAuthor Commented:
Hi David

The C drive VHD is set to 64Gb and I don't have more space on the cluster available to allocate as it will result in Veeam backups failing and also affect SAN performance.

I have a 64Gb vhd to work with
47Gb of virtual memory
I need to allocate enough memory for the OS (2012 R2) for paging
Consider adjust SQL from not using all the memory (I would prefer not to change SQL memory allocation if I don't have to)
I must mention that the LOG files for SQL has been set to populate the D drive which has 50GB of space of which 48gb (Same size as SQL allocation) has been used.  Leaving me with 1.5Gb free on the D drive only. The log files are also set to for simple logging.

Hope this helps

David Johnson, CD, MVPOwnerCommented:
Time to go to management and get more storage.. for the primary cluster and the backup devices. After a backup do the log files shrink or do you have a separate db backup that will clear the log files? To be brutally honest with you 64G for the OS simply is not enough space. Server 2012R2 base (up to date) requires approx 20G + 25G paging file leaves less than 1/3 free . if the sql data files also reside on the OS disk (not recommended) then you have even less space free.

As for paging files I would make it 25/25 minimum = maximum to reduce disk fragmentation.  55GB paging + 15 GB minimum OS > your hard drive of 64GB.. the math doesn't work.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Quintin SmithAuthor Commented:
Thanks David! I don't have that luxury at the moment so would have to work with what I have until I can get more storage space
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows Server 2012

From novice to tech pro — start learning today.