Unanswered question

Neo load Report alert

When i am running my report i am getting alert 'SQLServer:Buffer Manager/Page life expectancy <= 200.0' for my sql what it means ?? it comes in red ?

MAHIMA A.
MAHIMA A.

MAHIMA A.

Level
0
78 / 100
points

Answers

Alexis N.
Alexis N.

Alexis N.

Level
2
1255 / 2000
points
Team

Page Life Expectancy is the number of seconds a page will stay in the buffer pool without references. In simple words, if your page stays longer in the buffer pool (area of the memory cache) your PLE is higher, leading to higher performance as every time request comes there are chances it may find its data in the cache itself instead of going to the hard drive to read the data.

More information here: https://blog.sqlauthority.com/2010/12/13/sql-server-what-...