Page file size on Window 2008 SQL Server

I have setup a Window 2008 SQL Server with 4 partition
OS
TempDB
SQLLog
Data

OS has been reserved with 8GB of memory and the remaining memory is given to SQL server (through memory setting). However, I find that the pagefile.sys is around 134GB which take up a lot of space on C: drive. Is there a better way to handle it ? Can I restrict the page system to around 8GB ? Tks
AXISHKAsked:
Who is Participating?
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.

Mr TorturSystem EngineerCommented:
Hi AXISHK,
First it depends of your physical RAM size.
Here is a Microsoft KB about it : http://support.microsoft.com/kb/2860880 
And second it depends... because it is well-known subject, you will find a lot of different thinking about it.
Mine is that when you have a lot of RAM (>20 GB) it is not necessary to apply Microsoft ratio rule.
0
Pramod UbheCommented:
2k8 does not use page file more than 32 GB.
for RAM < 24 GB it is recommended to have 1.5 times however, for higher configurations like having RAM more than 24GB, you can set page file to 32GB.
0
AXISHKAuthor Commented:
I have installed Window 2008R2 Enterprise, with 128GB of page. Pagefile size is around 134GB.

as 128GB will be reserved in SQL Server, leaving OS with 8GB.

Should I simplify set the page size as 12GB ? correct ?

Tks
0
Creating Active Directory Users from a Text File

If your organization has a need to mass-create AD user accounts, watch this video to see how its done without the need for scripting or other unnecessary complexities.

Mr TorturSystem EngineerCommented:
Hi AXISHK,

I would like to help you, and don't want to argue, but :
- I don't understand your numbers at all (you have 128GB RAM, and tell us you reserve 128GB for SQL so leaving 8GB for the OS? something is wrong here ; and why finally you plan to move to a 12GB page file size?)

- in fact I am not a DBA nor SQL specialist, and on a SQL Server your question is a matter of SQL best practices ; I know a little about windows systems and to my advice I would set a page file obtained with the equation : RAM peak commit – physical RAM = n GB ; it should be small if your server is well sized ; so you can set your page file between n and nx2 GB

Page file is a wide discussion but what I think is that you just need to look after SQL best practices, and I don't know that.
0
AXISHKAuthor Commented:
Sorry, typo mistake. Physical RAM 128GB. Max Memory that SQL Server can use is 120GB. Current Page size on Window OS is 134GB (this is created by "system managed").  

That's why I count 8GB on Window 2008R2 and estimate the pagefile size. I have surfed for answer but I can't sort it out. Tks
0
Pramod UbheCommented:
You need to configure page file to 32 gb.
0
AXISHKAuthor Commented:
My server is Window 2008 R2 Enterprise, it supports large memory  > 32GB memory....

Again, can I use 8GB (after reserving 120GB of memory to SQL) as a baseline in calculating the page file ? Tks
0
Pramod UbheCommented:
Though it support large memory, it can use page file max up to 32 GB
0

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
AXISHKAuthor Commented:
tks
0
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
Microsoft SQL Server 2008

From novice to tech pro — start learning today.