Page Life Expectancy – if you don’t know this stuff, don’t call yourself a senior DBA, please….

Hi all,

yesterday I was once again asked by a fellow ‘senior’ DBA I know, about the 300 second guideline for the PLE (Page Life Expectancy) counter. It never really ceases to amaze me how many people in our community are still not aware on how to interpret this value and be able to calculate a proper value for their specific situation. So to help everyone with the basics, the following link points to the blog posting by Paul Randal of SQLSkills.

http://www.sqlskills.com/blogs/paul/page-life-expectancy-isnt-what-you-think/

In this posting he explains what this counter is really about and how it should be interpreted. This includes the info on how it relates to NUMA nodes. This is pretty essential info, so don’t skip this part and make sure you understand it.

Oowww and don’t forget, NUMA is something that will bite you in the ass (performance-wise) if you don’t know how it plays a part in your environment. Especially if you are running SQL in a virtual setup, talk to your virtualization admins and know how your servers (hosts) and VM (guests) are configured. But I will get some more info about that and what to look for, in a future posting.

Advertisements
Page Life Expectancy – if you don’t know this stuff, don’t call yourself a senior DBA, please….

Kick-off for a new blog about SQL and other techie-stuff

Hello World…. I believe that is the traditional first posting on pretty much any blog and even tough I hate traditions in some cases, this one does feel fitting.

Now for the real stuff… Welcome to my blog about SQL and other techie-stuff. My name is Martijn van der Munnik and I live in the Netherlands. I am a self-employed¬†Technology Consultant with a primary focus on SQL Server and all tech that surround and supports it. This blog will be about sharing information (duh!) and opinions on pretty much anything SQL Server related. I will be writing my own blog content but also ‘borrowing’ stuff from other blogs and sites and reposting it. Yeah, I know… ethics and bla bla bla… I will OFCOURSE¬†be giving credits where credit is due and linking back to the sources that I used.

Anyways, again welcome to my blog and I hope you will enjoy it.

Martijn

Kick-off for a new blog about SQL and other techie-stuff