Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 Other Topics
 8GB memory - Data Execution Prevention - Boot.ini

Author  Topic 

franco
Constraint Violating Yak Guru

255 Posts

Posted - 2005-12-09 : 10:28:43
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

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2005-12-12 : 09:04:12
Add /3GB /PAE to the boot.ini file. Go into SQL Server and make sure you have awe enabled. For details, look at this document:

http://weblogs.sqlteam.com/derrickl/archive/2005/12/04/8484.aspx

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.
Go to Top of Page
   

- Advertisement -