?
Solved

Paging file

Posted on 2013-05-14
8
Medium Priority
?
317 Views
Last Modified: 2013-05-20
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
0
Comment
Question by:Morpheus7
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
8 Comments
 
LVL 29

Assisted Solution

by:QPR
QPR earned 668 total points
ID: 39163835
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
 

Author Comment

by:Morpheus7
ID: 39163849
Hi,

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

Thanks
0
 
LVL 29

Expert Comment

by:QPR
ID: 39163860
Can you view the SQL processes in management studio?
0
Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
LVL 29

Expert Comment

by:QPR
ID: 39163865
0
 
LVL 1

Expert Comment

by:micen
ID: 39163869
try tool RAMMap.exe to see what is occupying the RAM. Set the page file to what the system recommend.
0
 
LVL 10

Assisted Solution

by:Prashant Girennavar
Prashant Girennavar earned 664 total points
ID: 39163902
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
 
LVL 56

Expert Comment

by:McKnife
ID: 39164045
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
 
LVL 10

Accepted Solution

by:
Pramod Ubhe earned 668 total points
ID: 39164402
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

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Issue: One Windows 2008 R2 64bit server on the network unable to connect to a buffalo Device (Linkstation) with firmware version 1.56. There are a total of four servers on the network this being one of them. Troubleshooting Steps: Connect via h…
After seeing many questions for JRNL_WRAP_ERROR for replication failure, I thought it would be useful to write this article.
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles to another domain controller. Log onto the new domain controller with a user account t…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Suggested Courses
Course of the Month11 days, 5 hours left to enroll

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question