|Subject:||SQL Server 2008 Active/Active cluster memory configuration|
|Posted by:||Igor Marchenko|
|Date:||Wed, 18 Nov 2009|
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,