Post reply

Which instance is having memory pressure?

  • June 18, 2017 at 2:08 am

    #326827

    Good Morning Experts,

    I have multiple SQL Server instances running on the same machine. How to find which instance is having memory pressure?

  • June 18, 2017 at 3:10 am

    #1947184

    coolchaitu - Sunday, June 18, 2017 2:08 AM

    Good Morning Experts,

    I have multiple SQL Server instances running on the same machine. How to find which instance is having memory pressure?

    I did a blog post a while ago about identifying servers with memory pressure.  It extends a query I borrowed from Jonathan Kehayias's SQLSkills post on the subject.

    Run the query in my post periodically against the various instances, and see which one reports more / longest memory pressure events.

    I suspect, though, that what you're most likely to find is that the server itself is underprovisioned for memory (hey, you're asking this question), and that you're quite likely to find that either most or all of the instances are suffering, in which case reduce the memory allocation of those instances that aren't suffering.  And get more memory in the server.

    Thomas Rushton
    blog: https://thelonedba.wordpress.com

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

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