Post reply

Dymanically Configured memory vs Fixed memory size

  • October 15, 2008 at 8:21 am

    #125212

    I'd always thought that, for example, a single server running nothing but SQL Server youd use dynamically manged memory and make sure you left some for the OS...

    Now Im being told that no it should be set to a fixed size of 3/4 of the avail memory

    I not sure I follow the rationale .. any views/words of wisdom etc etc ?

    thanks si

  • October 15, 2008 at 8:28 am

    #885258

    My preference is to set the max memory and let SQL manage the rest.

    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 20, 2008 at 5:46 am

    #887061

    GilaMonster (10/15/2008)

    My preference is to set the max memory and let SQL manage the rest.

    thank you Gail ... so can you see any rationale or reason as to why, or in which circumstances youd choose a fixed size ?

    ~simon

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

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