Post reply

Max and Min Memory setting are the same.

  • September 11, 2014 at 5:52 pm

    #296093

    Hello,

    Here's an odd one for you. I have just started at a new place, I noticed that the previous DBA had the max min memory settings the same, and the buffer pages chart is 90% stolen. I've not done or seen this before, what kind of effect is this going to be having on the server?

    I know this needs to be changed, just wandering what the effect must be on performance.

    Thanks,

    D.

  • September 12, 2014 at 2:24 am

    #1744991

    It means that SQL cannot respond to OS requests to reduce its memory usage and hence, if the OS comes under memory pressure may result in SQL being swapped to the page file (if locked pages is not enabled).

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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