SQL 2012 Total Memory On Consolidated Server

• rick_buchan

  SSC Rookie

  Points: 41

  More actions

  September 17, 2012 at 8:04 am

  #267863

  [font="Times New Roman"][/font]

  We are looking to create a SQL 2012 consolidated estate on physical servers using standard edition.

  This link shows the capacity limits

  http://msdn.microsoft.com/en-us/library/cc645993%28v=SQL.110%29.aspx#CrossBoxScale

  While the first two rows show the values used by a single instance, the third does not. So does this mean the maximum total memory that can be used by all instances on a server is 64Gb, or that limit, as I suspect, is per instance, and Microsoft have worded it so just to add a little bit of confusion.

  Thanks.

  Rick.

• Grant Fritchey

  SSC Guru

  Points: 398890

  More actions

  September 18, 2012 at 5:57 am

  #1539030

  As far as I know, that's per instance.

  "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
  - Theodore Roosevelt

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning