• Skip to main content
  • Skip to primary sidebar

DallasDBAs.com

Explaining SQL Server in plain english

  • Services
    • SQL Server Health Check
  • Pocket DBA®
  • Blog
    • Speaking
  • Testimonials
  • Contact
  • About

SQL Server: PLE > 300 is nonsense

November 20, 2017 by Kevin3NF 3 Comments

I’ve been hearing throughout my entire DBA career that 300 seconds is a good counter for PLE (Page Life Expectancy) to be above.

Paul Randal calls this “utter nonsense“.  If anyone would have the right to say that, its Paul.

There was a time when this MIGHT have been a useful number…but the hardware has changed so much its no longer so.  I “heard” that Paul actually made up that number just for documentation purposes…but that may just be a fun story.   Ask Paul sometime.

Go here to find a good number: Page Life Expectancy isn’t what you think

While you are there, check out all of the posts that start with “SQL Server DBA Myth a Day” and see how many you thought were gospel truth 🙂

Thanks for reading,

Kevin3NF

 

Share this:

  • Click to share on Twitter (Opens in new window)
  • Click to share on LinkedIn (Opens in new window)
  • Click to share on Facebook (Opens in new window)
  • Click to email a link to a friend (Opens in new window)
  • Click to print (Opens in new window)

Related

Filed Under: Uncategorized

About Kevin3NF

Reader Interactions

Comments

  1. Paul Randal says

    November 22, 2017 at 11:42 am

    No – definitely wasn’t me that made that number up.

    Reply
    • Kevin3NF says

      November 22, 2017 at 11:52 am

      Good to know…any idea where it came from?

      Or the “Cost Threshold for Parallelism of 5 came from a desktop at Microsoft in 1997” story?

      Reply

Trackbacks

  1. Myths With Page Life Expectancy – Curated SQL says:
    November 21, 2017 at 7:05 am

    […] Kevin Hill has a public service announcement: […]

    Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Primary Sidebar

Search

Sign up for blogs, DBA availability and more!


Categories

  • Accidental DBA
  • Apprentice
  • Azure
  • backup
  • backup
  • Beginner
  • Career
  • Configuration
  • Cycling
  • Dallas DBAs
  • Deployment
  • Emergency
  • Encryption
  • EntryLevel
  • Fries
  • Goals
  • HADR
  • HealthCheck
  • Index
  • Install
  • IRL
  • Management
  • Migration
  • MySQL
  • Oracle
  • PASS
  • Performance
  • Personal
  • Pluralsight
  • Podcast
  • PowerShell
  • red gate
  • Restore
  • Security
  • Speaking
  • SQL
  • sql 2005 log shipping suspect
  • sql injection
  • SQLSaturday
  • SSIS
  • SSMS
  • Summit
  • TIL
  • Tools
  • Training
  • Troubleshooting
  • TSQL
  • TSQL2sday
  • Uncategorized
  • Upgrade
  • vendor code modify
  • video
  • vNext

Copyright © 2023 · Genesis Sample on Genesis Framework · WordPress · Log in

Privacy Policy