Home Forums SQL Server 2008 SQL Server Newbies Instance is under memory pressure. How to relieve from pressure RE: Instance is under memory pressure. How to relieve from pressure

  • Sean Lange - Friday, March 24, 2017 12:25 PM

    We are back to you needing to ask a question. What that means is you need to provide enough details of your situation that others have a chance at helping you. At this point all we know is you think there is too much memory pressure because "It is experiencing high Page reads/sec, low PLE , high free list stalls and high value of lazy writes". We don't even know what those values are. Keep in mind we can't see your screen, have no idea what your architecture or hardware is like. The ONLY information we have is what you have posted...and at this point you haven't posted anything resembling details. Look at all the people on this thread trying to pry the details out of you. We all want to help you. But for us to be able to do that requires that you provide us those details. Unless you can do that nobody can do anything to help you.

    free list stalls/sec=20
    lazy writes/sec=7639
    page reads/sec=1060131091
    PLE=306