Post reply

Max & Min Memory configuration on 64 bit

  • May 3, 2010 at 11:18 pm

    #232246

    I have 48 GB of RAM on my windows 2008 64 bit server. There are three instances of 64 bit is running with max memory of 10 GB and min memory of 5 GB.

    This is an OLTP env having 6 databases in total. Is the memory config is correct or di I have to increase it. How do I conclude if the memory setting is fine?

    "More Green More Oxygen !! Plant a tree today"

  • May 4, 2010 at 12:49 am

    #1161621

    All 3 instances set to 10GB? Are they all of equal importance and memory usage?

    10*3 = 30GB, so there's 18GB remaining. Is there anything else on the server?

    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

  • May 4, 2010 at 1:19 am

    #1161627

    I see an aweful lot of memory left over. As Gail was asking, are they all the same for importance.. I might bump the memory to top at 14GB if they are..

    CEWII

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

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