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 2000 Forums
 SQL Server Administration (2000)
 Low Page Life Expectancy
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

JaybeeSQL
Posting Yak Master

112 Posts

Posted - 02/25/2013 :  07:28:08  Show Profile  Reply with Quote
Hi all,

Got a problem with PLE that I'm not certain how to diagnose....

My monitoring software reports intermittent numbers from 130-180, well below the MS recommendation of 300. It hits this 10-15 times every day, at random intervals. Our Buffer/Procedure cache hit ratios % are both in the high 90's, which is consistent with our data being lightly transacted (although this is a log shipping primary)

Server spec is:

SS EE (32bit)
64Gb Ram.

Any way to tell if this is a problem, or threatens to become one?

Cheers,

JB

jackv
Flowing Fount of Yak Knowledge

United Kingdom
2047 Posts

Posted - 02/25/2013 :  07:46:07  Show Profile  Visit jackv's Homepage  Reply with Quote
the key with Page Life expectancy is consistency. If it's consistently low than that is a good indicator more physical memory is required. In your case it's intermittent , so : check fo rmissing indexes, updated statistics and indexes missing statistics first. Does this alleviate the problem?
Use a measurement , for example, over 10 minutes on a represntative workload and check the PLE

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page

JaybeeSQL
Posting Yak Master

112 Posts

Posted - 02/25/2013 :  09:50:41  Show Profile  Reply with Quote
Updated stats, and indexes missing stats - are these two separate things?
Go to Top of Page

jackv
Flowing Fount of Yak Knowledge

United Kingdom
2047 Posts

Posted - 02/25/2013 :  11:18:58  Show Profile  Visit jackv's Homepage  Reply with Quote
Yes , same thing. Check this post to get date of last time updated http://www.sqlserver-dba.com/2011/01/index-missing-statistics.html

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page

chadmat
The Chadinator

USA
1974 Posts

Posted - 03/09/2013 :  17:40:22  Show Profile  Visit chadmat's Homepage  Reply with Quote
Also,

300 is far too low a threshhold for the size of your Buffer Pool (Assuming you have the lion's share of that 64GB dedicaated to this instance). And 32 bit still???

-Chad
Go to Top of Page

James K
Flowing Fount of Yak Knowledge

3589 Posts

Posted - 03/10/2013 :  13:03:15  Show Profile  Reply with Quote
Might seem like a silly question, but you do have AWE enabled, don't you? Are you on Server 2003 or 2008?
Go to Top of Page

JaybeeSQL
Posting Yak Master

112 Posts

Posted - 03/11/2013 :  05:51:55  Show Profile  Reply with Quote
2K3, AWE enabled. Moving the OS estate (well over 100 servers) to 64bit would cause an upheaval of colossal proportions, given how tightly regulated and scrutinised our environment is.
Go to Top of Page

jackv
Flowing Fount of Yak Knowledge

United Kingdom
2047 Posts

Posted - 03/11/2013 :  11:44:49  Show Profile  Visit jackv's Homepage  Reply with Quote
AWE is not required in 64 bit , but you may want to consider Lock Pages in Memory .This will depend on different scenarios. The main benefit of turning it on is that the buffer pool buffer doesn't get paged out.



Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page

chadmat
The Chadinator

USA
1974 Posts

Posted - 03/11/2013 :  19:23:59  Show Profile  Visit chadmat's Homepage  Reply with Quote
What is Total Server Memory and Target Server Memory in perfmon?

Also, can you corrolate the drops in PLE with any large reporting queries or anything like that?

-Chad
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.09 seconds. Powered By: Snitz Forums 2000