Sample Header Ad - 728x90

What perfmon metric will help me to monitor whether the SQL server memory is under pressure and resulting in usage of page file on disk?

2 votes
1 answer
828 views
SQL server is assigned 110GB memory. It is consuming the entire memory. I want to understand whether there is memory pressure or not. Usually SQL server will remove old pages from the memory (that it currently doesn't require) and pull in required pages from disk. However, when there is memory pressure - (assuming all pages in memory are required and actively used) SQL server will utilize the page file on disk as an alternate memory area. What perfmon metric will help me to monitor whether the SQL server memory is under pressure (that is disk page file is being used)? I know about Memory:Page Fault/sec - but this is not restricted to only SQL server memory pressure. What other perf mon metric can help me?
Asked by variable (3590 rep)
Oct 6, 2021, 04:33 AM
Last activity: Oct 6, 2021, 11:36 AM