Thank you!

Just an update, looks like both solutions work with n number of parenthesis.  Brilliant!!!  Thank you so much!!!

Thank you all, appreciate it.  I forgot to mention that the number of open/close parenthesis can vary.  I'll see if I can work off your solutions to make that happen. ...

Luis, thank you so much, the second point was the reason why I saw dupes.  I added "s.database_id = DB_ID()" and that solved the issue.  Thank you very much!!!

What's the PLE value when the paging is occurring?

Hi Sue, which one of the queries can I run to understand why there is such a high free page count and such low PLE?

Hi Sue, I must have not run that since it threw an error on SQL 2012. 

Either way, I am still  baffled by this.  Might have to open...

I've run Perfmon when PLE is in the 100-150 range and found the below:

Counter Database Cache Memory  is average of 17GB, minimum 16GB, maximum 19GB.

Counter  Free...

Hi Eric, I am referring to the buffer pool, where data/index pages are kept.  I ran your query and have attached the result.  As you can see, only a portion...

Hi Sue, thanks for the response.  I had actually been to that very page and been through all the scripts.  I am still unable to find an answer.

Hi Sue, I have done a SUM on pages_kb in dm_os_memory_clerks, which adds up the space taken by all clerk types.  The total is 22GB.  SQL Server is using 51GB,...

Thank you guys! The second code worked like a charm, thank you so much!

Thanks Sapen. I have been tasked to find out what are the things that sysadmin can do that other server/db roles cannot do. Was wondering if there is...

Yeah, sorry, I mean that I reduced the maximum memory size for SQL Server by 10GB.

Are there any DMVs that can help in stead of the cumbersome MEMORYSTATUS?

Thanks, exactly what I was looking for! 🙂