Post reply

Memory allocation rule of thumb

  • June 15, 2015 at 1:43 am

    #299054

    Hi Experts,

    We have a SQL Server 2012 Enterprise edition cluster (2 node) installed on Windows 2012 R2 Std. server.

    256 GB RAM is available in both the node and it is dedicated DB server.

    It's pure OLTP database and only DB engine and client is installed.

    In this setup, how much memory we should allocate to SQL Server ideally ?

    I understand that it depends, however what's the rule of thumb here to allocate memory to SQL Server ?

    Thanks,

    San.

  • June 15, 2015 at 5:09 am

    #1805415

    Chapter 4: http://www.red-gate.com/community/books/accidental-dba

    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 1 (of 1 total)

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