Sample Header Ad - 728x90

What does 0 memory grants pending, but low PLE, high lazy writes/sec and free list stalls/sec indicate?

0 votes
3 answers
1145 views
My server memory is 100GB, of which 90GB is allocated to SQL server via the max memory setting. I am monitoring a sql server that has got 0 memory grants pending. This means no process is waiting for memory. If this was greater than 0 then it will indicate memory pressure which would get resolved upon increasing the max sql server memory setting. However I am seeing low PLE (page life expectancy), high lazy writes/sec and free list stalls/sec. Does this indicate memory pressure?
Asked by variable (3590 rep)
May 5, 2022, 09:33 AM
Last activity: May 6, 2022, 08:29 AM