Paging file

Hi,

We have the following configuration .

Windows Server 2008 Enterprise SP 2
64 Bit. 32 Gb Ram.

B: Drive 40000 Mb. Used for backup purposes.
C: Drive - OS 20000 Mb.
E: Drive  - SQL Server installed on this drive. No page file.

This server runs SQL only. Currently it runs very slowly with the memory usage at a constant 97 %, which is SQL.

What page file configuration would give the best performance?

Any help would be appreciated.
Thanks
Morpheus7Asked:
Who is Participating?
 
Pramod UbheConnect With a Mentor Commented:
windows server 2008 does not use more than 32 gb of page file, you need to set page file as 32 gb and ask database administrator to lower down the amount of memory used by SQL (there is a setting in SQL to set max memory used by SQL services).
0
 
QPRConnect With a Mentor Commented:
Unless you specify a max memory limit, SQL will hold all available memory "in case" it needs it in a hurry. It will release it back to the OS on request. Because it is occupying 97% doesn't necessarily mean it is using 97% if you see what I mean.
Have you looked into what is active in SQL when things are slow?
Do you have SQL Management Studio installed so you can view activity monitor to see what processes are running?
Does the slowness coincide with any maintenance?
Are you 100% sure nothing else is running?
Back-ups? Anti-virus?
0
 
Morpheus7Author Commented:
Hi,

The server is replicating 14 small articles 24/7.  Looking at the processes, nothing else is running.

Thanks
0
Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

 
QPRCommented:
Can you view the SQL processes in management studio?
0
 
Micael CarlssonDBA ConsultantCommented:
try tool RAMMap.exe to see what is occupying the RAM. Set the page file to what the system recommend.
0
 
Prashant GirennavarConnect With a Mentor Commented:
Mark has a good explaination about page file configuration

http://blogs.technet.com/b/markrussinovich/archive/2008/11/17/3155406.aspx

How Big Should I Make the Paging File?

Check the above section

Thanks,

-Prashant Girennavar.
0
 
McKnifeCommented:
MS sees problems in server 2008 ("R1") memory management and offers a service executable that addresses those. I used it and it's impressive.
http://www.microsoft.com/en-us/download/details.aspx?id=9258
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.