SQL Server 2008 Active/Active cluster memory configuration

Giganews Newsgroups
Subject: SQL Server 2008 Active/Active cluster memory configuration
Posted by:  Igor Marchenko
Date: Wed, 18 Nov 2009

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

Replies