Search


	Podcast:		voiceofthedba's podcast
	Episode:		Be Prepared with Baselines
	Category:		Technology
	Duration:		00:03:17
	Publish Date:		2018-06-10 20:00:00
	Description:		I visited a doctor recently, and he told me a measurement he'd made. I asked if it was good or bad, and he said he had no idea. The value varied too much from person to person, and without values from the past, he couldn't really evaluate the significance of it. He will be able to in the future, now that he has a value, but there's nothing that can be done now. At this point, he has a baseline (of sorts) and can now start to judge how things change over time. After that visit, I started thinking about Page Life Expectancy (PLE). PLE is one of those counters that so many DBAs look at early in their career. Often they've read guidance that they should worry once this is below 300, which isn't true. There are calculations for this, but they are based on your system, and really, they're a rough rule of thumb. Really you need to measure this for your system, so that you know what a the value often is and then worry when it dips. Read the rest of Be Prepared with Baselines
	Total Play:		0