May 9, 2014 at 2:19 pm
I think my sever(SQL Server 2008 r2) got memory pressure. MEMORYCLERK_SQLOPTIMIZER has the highest Allocated memory, 34.6 GB out of total 64 GB RAM. MemoryClerk_SQLBufferPool has a high # of Virtual Memory Committed, 52.6 GB.
Stolen page - 4727167
Free page - 25120
Dirty - 36734
Latched - 4
Could anybody advise how to troubleshooting this problem? Thanks in advance!
May 10, 2014 at 8:20 am
SQL Server will take all the memory on a system that you let it take and it will hold on to that memory pretty much indefinitely. It's not a problem. It's by design. But, you should put a limit on the max memory.
However, if you think you might be under memory pressure, I have an article [/url]that shows two quick ways to determine if that's true. The query for reading the ring buffers was problematic for some people, but there was a suggested fix in the comments. Just scroll down.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply