THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Tibor Karaszi

Log Page Life Expectancy over time

You often see Page Life Expectancy referred to as an interesting performance monitor counter. And it can be! It indicates for how long a page is expected to stay in cache, from the time it was brought into cache.

But just looking at a snapshot value doesn't say that much. It might be high, but that is because you haven't had a high turnover of you pages for the past couple of hours. Or the other way around, you happen to look just after a very rare monster query. Furthermore, having a log can show you how PLE changes over time.

"The app was slow at two o'clock today."

You look at the PLE log and you see how PLE dropped at that time, which indicates that something was executed that did lots of I/O. Or you don't see PLE drop at all, and can assume that it probably was a blocking situation instead.

Some of you already have performance monitoring solutions that include PLE logging over time. For you that don't, I created a very simple solution. It involved a table, a scheduled Agent job and queries to read the data. That's it.

You find it at http://karaszi.com/log-page-life-expectancy-over-time .

Improvements and comments are of course appreciated. :-)

Published Wednesday, September 7, 2016 2:02 PM by TiborKaraszi
Filed under: ,

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

wef said:

http://www.chanel-outlet.co    Chanel Outlet

http://www.payless-shoes.co    payless shoes

http://www.80s-fashion.org    80's Fashion

http://www.3chathk.com    Nike Air Jordan Enfants

http://www.michaelkorsoutlet-vip.us    Michael Kors Outlet

http://www.ybreen.com    Air Jordan Retro 3

http://www.raybanshop.us    ray ban shop

http://www.promise--rings.us    Promise Rings - Official

http://www.tuxedos4u.com    populaire Nike Lunarmax

http://www.puma-outlet.net    puma outlet

http://www.coachfactoryoutlet.cc    coach factory outlet

http://www.katespade-outlet.net    katespade outlet

http://www.abirdtoldme.fr    Nike Air Force

http://www.coachbagsfactoryoutlet.us    Coach Bags Outlet

http://www.nikeschuheshop.de    NIKE Schuhe Shop

http://www.casio-watches.us    casio watches

http://www.michelewatch.us    michele watch

http://www.oakley-australia.net    oakley australia

http://www.ad29.fr    Air Jordan 10

http://www.qiqifashion.us/    qiqi fashion

http://www.birkenstocksandals.co    birkenstock sandals

http://www.burberrybagsoutlet.us    burberry bags outlet

http://www.michael-kors-shoes.us    michael kors shoes

http://www.menssunglasses.us    Sunglasses outlet sale

http://www.searchedtabsonline.com    Nike Air Jordan Enfants

http://www.raybanclubmaster.us    ray ban clubmaster sunglasses

http://www.cartier-watches.org    Cartier Watches

http://www.pumaoutlet.net    puma outlet online

http://www.hermesbag.us    hermes bag

http://www.louisvuittonoutletbox.com    louis vuitton outlet

http://www.coach-factory-outlet.org/    coach factory outlet

http://www.clearanceoutlet.us/    clearance

http://www.prada-outlet.us.com    prada outlet woodbury

meadc2.11

February 10, 2018 7:24 PM

Leave a Comment

(required) 
(required) 
Submit

This Blog

Syndication

Privacy Statement