Page Lifeexpectancy Problem ??

Question

Page Lifeexpectancy Problem ??

Lavanyasri

SSCarpal Tunnel

Points: 4907
More actions
September 2, 2011 at 7:05 am

#256610

Hi all,
I added pagelife expectancy[SQl server :Buffer manager ] counter . Its showing constant value of 89,387 .

Viewing 9 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

muthukkumaran Kaliyamoorthy SSCoach Points: 19026 More actions · Answer 1

Lavanyasri (9/2/2011)
Hi all,
I added pagelife expectancy[SQl server :Buffer manager ] counter . Its showing constant value of 89,387 .

That will be fine .Is there any problem ?

Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/

Lavanyasri SSCarpal Tunnel Points: 4907 More actions · Answer 2

HI ,

Thanks for quick response.

I googled for this is issue , in some articles saying the pagelife expectancy value should be low .

i searched , but i didn't get exactly what is the use of this , what are the recommended values .

muthukkumaran Kaliyamoorthy SSCoach Points: 19026 More actions · Answer 3

Lavanyasri (9/2/2011)
HI ,
Thanks for quick response.
I googled for this is issue , in some articles saying the pagelife expectancy value should be low .
i searched , but i didn't get exactly what is the use of this , what are the recommended values .

Where you read it. that is totally incorrect.

better it should be always high.

PLE is How long (no.of seconds) a page will stay in the memory i.e buffer pool.

Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/

muthukkumaran Kaliyamoorthy SSCoach Points: 19026 More actions · Answer 4

I googled for this is issue

What's your issue?

Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/

Grant Fritchey SSC Guru Points: 399278 More actions · Answer 5

Page life expectancy shows how long pages have been in memory. That's it. A long time is good. The longer the better. I've seen weeks without a page flush before. It's when it's very low or you get lots of drops, frequently, that you need to be concerned. A nice high value, that's fine.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

Lavanyasri SSCarpal Tunnel Points: 4907 More actions · Answer 6

Thanks Grant\Muthu

I have one more question :

[Memory ]

Pagefaults\Sec : is varying from 60,90,220,2434 like this ??

What is the recomended value [i.e low or high ] . I am new to perfromance issues .

Gail Shaw SSC Guru Points: 1004514 More actions · Answer 7

Lesson 1 in perfmon. Most counters don't have hard values of good and bad. What you need to watch for is values that are very different to what's normal for your system.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Grant Fritchey SSC Guru Points: 399278 More actions · Answer 8

GilaMonster (9/2/2011)
Lesson 1 in perfmon. Most counters don't have hard values of good and bad. What you need to watch for is values that are very different to what's normal for your system.

What Gail said.

You'll have to watch your counters over time. Just looking at them, without the context of a before and after (they looked like this yesterday/last week/last month) it's frequently difficult to tell if you have a problem. However, a big number on page life expectancy is never a problem.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning