December 29, 2017 at 11:53 am
shahgols - Friday, December 29, 2017 8:19 AMHi Sue, which one of the queries can I run to understand why there is such a high free page count and such low PLE?
Just as with other things in SQL Server, you run through a series of things for a process of elimination as well as areas to look into. Just looking at PLE alone will not tell you much. And there usually aren't any single scripts or queries that are going to tell you exactly what you want to know. You need to understand the big picture, in this case memory architecture, and drill into things from there
I would still follow all of the directions, advise and queries in that original link. He has another version of this on his MS blog but that post is more current. On his MS blog, the queries are prefaced with "some of the queries we use to troubleshoot memory". If you'd rather reference his MS blog, it has fewer queries but here is the link:
Troubleshooting SQL Server Memory
And if you get an error with running any of the queries, look up whatever you are querying and see if changes were made to that DMV, function, etc. The changes with sys.dm_os_memory_clerks is in the documentation. You can also find additional information on what uses memory outside the buffer pool in this article -
SQL Server 2012 memory consumption outside the buffer pool
The article on using DBCC MEMORYSTATUS gives additional information on different memory concepts and explains stolen pages and why those would be high when the buffer pool is low.
INF: Using DBCC MEMORYSTATUS to Monitor SQL Server Memory Usage
Sue
Viewing post 16 (of 15 total)
You must be logged in to reply to this topic. Login to reply