troubleshooting Question

Page file size ?

Avatar of kevindockerty
kevindockerty asked on
Microsoft SQL ServerWindows Server 2003Microsoft SQL Server 2008SSAS
4 Comments1 Solution404 ViewsLast Modified:
I have a server ( Windows 2003 ) running SQL Server DB and SSAS
We have 32GB of physical memory available
The DB and cubes are farly large 200GB DB's - 100GB cubes

What is the optimum size of the page file I should be using
I am aware that Microsoft recommend 1.5 * Phys RAM GB
( ie in my scemario 48GB page file would be recommended )

I am also aware that this recommendation relates to home PC's and not production servers running large SQL DB's

In practice this is too large as I am limited by local disk space - the alternative being to use a SAN drive which I dont want to do because of poor performance.

Is the 48GB really necessary ?
What would be the impact of reducing this and letting the physical RAM do the work ?
It has been suggested we reduce this page file to a very minimal size ie 1GB - what problems if any would this cause ?

We are trying to balance the slow read time of reading the disk for page file use whilst optimizing memory available for SQL services.

any thoughts?
Kev
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros