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