SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Paging File Counters
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

MorrisK
Yak Posting Veteran

83 Posts

Posted - 03/04/2013 :  13:52:50  Show Profile  Reply with Quote
Running Windows Server 2003 Standard SP2 64bit and SQL Server 2008 R2 Standard. 8 GB of RAM is installed, page file is set to 4 GB. This server supports our ERP system, Reporting Services, and other applications.

Due to some problems we are having Dell support has recommended increasing the page file size and adding memory. My question is related to the Paging File counters % Usage and % Usage Peak. % Usage is showing an average of 27.284. % Usage Peak is showing 100%. Does it make sense for there to be such a difference between those?

Edited by - MorrisK on 03/04/2013 13:53:53

srimami
Posting Yak Master

160 Posts

Posted - 03/06/2013 :  14:26:30  Show Profile  Reply with Quote
Set page memory to 1.5 times the RAM as recommended by Microsoft which in your case is 12GB
Go to Top of Page

MorrisK
Yak Posting Veteran

83 Posts

Posted - 03/07/2013 :  10:17:44  Show Profile  Reply with Quote
Thanks for the reply. Now that I look at the following explanation for % Usage Peak I think I understand how this is possible.

"Show the peak the page file got to since the last reboot. Usually this is not too far off from the page file usage %. Unfortunately when page file issues happen, they do not correct themselves without a reboot."

http://sqlserverplanet.com/optimization/performance-counters

I also found the following article which challenges the conventional advice of 1.5 x RAM.

http://blogs.technet.com/b/markrussinovich/archive/2008/11/17/3155406.aspx
Go to Top of Page

MorrisK
Yak Posting Veteran

83 Posts

Posted - 03/07/2013 :  10:28:00  Show Profile  Reply with Quote
Found these articles also.

"There is no specific recommendation for page file size. Your requirements will be based on the hardware and software that you use and the load that you put on the computer."

http://support.microsoft.com/kb/889654

http://blogs.technet.com/b/perfguru/archive/2008/09/24/guidance-on-page-file-size-x64-and-x32-machines-windows-2003-servers.aspx

Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000