SQL Server Performance

8GB memory - Data Execution Prevention - Boot.ini

Discussion in 'SQL Server Clustering' started by franco, Dec 9, 2005.

  1. franco New Member

    Hi all,
    we have 2 node mscs cluster with Windows Server 2003 EE.
    Yesterday we installed SP1 on both nodes and now we just want to add 4GB of
    memory for a total of 8GB per Server.
    I notice that on the boot.ini there is a parameter, wich is the default:
    /NoExecute=OptOut
    The entire string is as follow:
    multi(0)disk(0)rdisk(0)partition(1)WINDOWS="Windows Server 2003,
    Enterprise" /fastdetect /NoExecute=OptOut
    We want to add PAE swich on this boot.ini file but here comes the doubt:
    On the "Changes to functionality in Microsoft Windows Server 2003 Service
    Pack 1" manual, on page 69 there is a note:
    "PAE is required on system running 32-bit version of Windows with processor
    that support hardware-enforced DEP.
    Our processors do NOT support this feauture.
    I also notice that when DEP is enable, wich means "/noexecute=alwayson", or
    "/noexecute =optout", or /noexecute=optin" on a computer with a processor
    that support hardware-enforced DEP, 32-BIT version of windows automatically
    enable physical address extension (PAE), which is just not our case.
    We also tryed this:
    "/noexecute=alwaysoff /PAE "
    but without success.
    Any idea?

    Can we also add /3GB in order to gain 1 more GB for applications?

    Please advise.
    Cheers.


    Franco

Share This Page