Post reply

SQL Server 2008 64 bit Active/Active cluster memory settings

  • 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

  • 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

  • November 30, 2009 at 6:46 am

    #1085371

    No need for AWE in 64-bit

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply