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.