8GB memory – Data Execution Prevention – Boot.ini | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

8GB memory – Data Execution Prevention – Boot.ini

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
]]>

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |