SQLServer 2008R2 Min & Max meory settings question

• jamessdba

  SSCrazy

  Points: 2256

  More actions

  April 26, 2016 at 11:46 pm

  #310196

  Hi,

  One of my production server running on sql server 2008R2 Standard Edition with Two Instances (Default+ Named)Total RAM is 64GB ,

  Please suggest me how to set/devide equally min & Max memory settings for Two instances (No HighAvailabilty)

  Thanks in advance.

• Grant Fritchey

  SSC Guru

  Points: 398882

  More actions

  April 27, 2016 at 7:42 am

  #1874935

  I would follow the recommendation from Jonathan Kehayias[/url].

  "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