SQL Server 2008 64 bit Active/Active cluster memory settings

• Igor Marchenko

  Hall of Fame

  Points: 3281

  More actions

  November 18, 2009 at 6:07 pm

  #213917

  Hello!

  We will be installing SQL Server 2008 64 bit EE on Windows 2008 EE (Active/Active cluster). I would like to confirm following settings considering we will have 32GB of memory on each node:

  1. No need to enable AWE.

  2. No need to set 'Lock Pages In Memory'.

  3. Cap Min and Max Memory usage on each instance (leave memory not only to OS, but also to the second instance in case of failover). I am not exactly sure how to cap memory. Would it be possible to make memory Max adjustment when failover occurs? Otherwise, we might be wasting memory.

  4. No need to set /3GB in boot.ini.

  Any other configurational setting to consider?

  Thank you in advance,

  Igor

• support.sql

  Default port

  Points: 1444

  More actions

  November 29, 2009 at 3:54 pm

  #1085187

  I recommend you enable these options, in order to ensure the best way to memory assignment in 64 bit platform.

  1. enable AWE.

  2. set 'Lock Pages In Memory'.

  SNM

  Try Free Microsoft SQL Server Data Collector & Performance Monitor.

  http://www.analyticsperformance.com[/url]
  
  @nalyticsperformance - Microsoft SQL Server & Windows Server Free Data Collector

• jasonmorris

  SSCrazy

  Points: 2492

  More actions

  November 30, 2009 at 6:46 am

  #1085371

  No need for AWE in 64-bit