Open for Voting

Add an Instance Memory in Use metric to the Resources | Memory page

I have an issue where some process was gradually consuming more memory on a server over time. The SQL instance on that server was therefore getting less and less memory over that time. When I looked in DPA to see the historical information on how much RAM the SQL Server process for the instance had been getting, I was surprised to find that there wasn't a chart for that.

I did see that the PLE was gradually dropping over time, but assumed that was due to the significant data growth that we have experienced, not because something outside SQL Server was leaking memory. If I had this additional metric available, I would have been able to diagnose this issue long ago, before the O/S Memory utilization eventually tipped me off. (SQL Server was apparently gradually releasing memory so the O/S Memory is use stayed steady until the SQL Server hit MINMEM).