Link to home
Create AccountLog in
Avatar of Morpheus7
Morpheus7

asked on

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
SOLUTION
Avatar of QPR
QPR
Flag of New Zealand image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of Morpheus7
Morpheus7

ASKER

Hi,

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

Thanks
Can you view the SQL processes in management studio?
try tool RAMMap.exe to see what is occupying the RAM. Set the page file to what the system recommend.
SOLUTION
Avatar of Prashant Girennavar
Prashant Girennavar
Flag of India image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
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
ASKER CERTIFIED SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account