On one of my SQL Servers, I am noticing what I think is memory pressure
PLE is +-100
Buffer Cache Hit Ratio is 99%
I would think that with a low PLE comes a low Buffer Cache Hit Ratio??
I am noticing PAGEIOLATCH waits on top of my wait_stats list - I'm assuming that this ties into the low PLE.
Server: SQL 2008 ENT on Windows 2008 ENT
Memory: Server memory - 50GB, Memory allocated to SQL - 42GB
Locked pages in memory is set
I have had some user complaints about performance
What is the recommended method to approach this