Post reply

MEMORY SETTINGs for SQL Server

  • October 9, 2018 at 5:30 am

    #370081

    Hi All,

    This has been long lasting question for me. Its regarding MAX SERVER MEMORY setting.
    How do we or what value to be set and on what basis we will be setting high or low values for max server memory setting, when we are supposed install multiple instances or running multiple features like SSIS,SSRS,SSAS on the same machine?

    Thanks,

    Sam

  • October 9, 2018 at 7:45 am

    #2008678

    Min at 0 unless you have a really good reason. Max, server's physical memory - what anything else on the server needs - reservation for the OS.

    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

  • October 11, 2018 at 10:35 pm

    #2009283

    Agreed.

    We normally reserve 15% of physical for the OS,

    But be aware if you run any backup agents ( like Avamar or similar ),these can use RAM as well and may force SQL to trim its RAM usage unless SQL pages are locked in memory.

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

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