SQL Server: PLE > 300 is nonsense

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

稿源:DallasDBAs (源链) | 关于 | 阅读提示

本站遵循[CC BY-NC-SA 4.0]。如您有版权、意见投诉等问题,请通过eMail联系我们处理。
酷辣虫 » 后端存储 » SQL Server: PLE > 300 is nonsense

喜欢 (0)or分享给?

专业 x 专注 x 聚合 x 分享 CC BY-NC-SA 4.0

使用声明 | 英豪名录