Memory Pressure

  • 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!

  • 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 RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply