Memory planning for sql server instances

• phebsix

  Old Hand

  Points: 318

  More actions

  March 21, 2013 at 11:52 pm

  #271911

  Hello guys,

  Is there any standard calculation for the allocation of sql server maximum memory on sql server instances? So lets assume there is an instance A with a database of 500GB and an instance B with 2 databases of 250GB how do I use a standard method of allocating memory to these instances.

  Thank you

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  March 22, 2013 at 3:47 am

  #1599696

  Not really that way, depends on the database activity, the portion of the DB that is heavily used, the workload and a whole bunch of other things.

  For what to leave for the OS, see chapter 4 of http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/

  For calculating memory requirements, this may help: http://www.sqlskills.com/blogs/jonathan/post/How-much-memory-does-my-SQL-Server-actually-need.aspx

  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