I've noticed a sudden drop in PLE on my SQL Server.
It's not to say that the system is now slow, just a noticed a drop and everything still seems to be chugging along nicely.
Anyway, in trying to find the cause of this drop, I looked at sys.dm_exec_query_memory_grants
and noticed the following....
What's interesting is that for most of that result set, the used and max used amounts are significantly lower than the granted memory amounts.
This is not normal behavior for this particular system
Could this be playing a part in my PLE drop?
As far as the cause for this differences between the granted and the used memory, I'm leaning towards the cause being that SQL Server is over estimating the memory requirements for the query. Am I on track here?
Could this be attributed to bad
parameter sniffing? How can I track this down?