Post reply

Max server Memory

  • May 16, 2014 at 7:45 am

    #307462

    Hi Brent,

    On my virtual SQL box there is web server also installed. When i went to 'Resource Monitor' saw w3wp.ext was on the top and taking more than 1.25 GB (commit) and sqlserv.ext was only 350 MB.

    Server has 16 GB total memory, Max Server Memory in sql setting was 12 GB. What a saw 'Physical Memory' was constantly 95%.

    So I did lower Max Server Memory to 10 GB for Sql and 6 GB for other services. Now Physical Memory' in Task Manager went down to 85%!!! Do you agree the change or there is better way to do it?

    And if you would, how much Min Server Memory do u recommend in this case? I have default 0 right now. Should i also 'Lock pages in memory'?

  • May 16, 2014 at 8:05 am

    #1714195

    0 is fine for min server memory.

    As for locked pages... https://www.simple-talk.com/sql/database-administration/great-sql-server-debates-lock-pages-in-memory/

    p.s. Don't use Task manager to check SQL Server's memory.

    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