Page life expectancy critiacl alert

[dbasupport]

Hi ,

We are using the check_t plugin to monitor the page life expectancy performance counter for sql server database .
Getting critical alert , need some inputs to resolve this alert .
We have 4Gb physical memory for the server . From the below value 2811460.00 sec , I belive this the cumulative value .
I need to right threshold for critical and warning alert .


mssqldev01 View service status details for this host PerfMon MSSQL Buffer Mgr Page life expectancyDBA Team looking into the issueThis service problem has been acknowledged Critical 3d 8h 45m 42s 5/5 2020-07-06 12:29:51 MSSQL Buffer Mgr Page life expectancy = 2811460.00 sec

[dbasupport]

This is the present setting which is set for PLE .

-l "\\SQLServer:Buffer Manager\\Page life expectancy","MSSQL Buffer Mgr Page life expectancy","sec" -w 86400 -c 172800!!!!!

[benjaminsmith]

Hi @dbasupport,

We are using the check_t plugin to monitor the page life expectancy performance counter for sql server database .

My apologies but I'm not familiar with check_t can you post a link to the plugin page or upload it to the thread and post the full check as well? Thanks, Benjamin

[dbasupport]

Sorry--- typo error ,its check_nt is the plugin

[ssax]

If it's regularly above the threshold you should increase the thresholds:

Code: Select all

-l "\\SQLServer:Buffer Manager\\Page life expectancy","MSSQL Buffer Mgr Page life expectancy","sec" -w 2900000 -c  3200000!!!!!

Thresholds really need to be tuned for your server, if that's a normal value returned then you'll need to increase the thresholds otherwise it will alert.

See here:

https://blog.sqlauthority.com/2010/12/1 ... e-counter/
https://www.sqlskills.com/blogs/paul/pa ... you-think/
http://houseofbrick.com/page-life-expec ... lling-you/