I'm trying to understand memory stats a lot better and have been troubleshooting an issue with one of our SharePoint DB servers for a while now. Low PLE, frequent lazy writes, slow performance etc
I noticed today that the stolen memory counter was high, and remained high. It didn't really fluctuate.
My server has 16GB RAM and SQL Server is allocated a maximum 12GB. The stolen memory counter is around 8.5GB. Is that normal?
What could that be and how to pinpoint the cause? What should I be looking at?
SQL Server 2012 is patched to SP3.
UPDATE: Here's an output of a query of os_performance_counters showing the high Stolen Memory (high being relative to the max memory of 12GB given to SQL Server)
By looking at trend data in SCOM I can see that Stolen Memory has increased steadily over the last 120 days from 2GB to 8.5GB... this is really puzzling me.