Folks,
I have a Windows Server 2003 SP2 Standard Edition x86 server in our prod environment. Some more info on this box:
1. Processor doesnt do hardware DEP.
2. Runs SQL.
3. Has 2x 2GB sticks (for a total of 4GB) but the OS only see 3.25GB (32 bit OS)
4. Boot.ini file
multi(0)disk(0)rdisk(0)partition(1)\WINDOWS="Windows Server 2003, Standard" /fastdetect /3GB /NoExecute=OptOut
So the issue is that once every 40 days or so, this server runs out of memory and stops responding and lies there dead in the water. Only option is to restart it after which it works fine for another so many days (no set pattern to the number of days) before it needs another restart.
Now is it okay to use the /PAE switch on such a server?
I read somewhere that the /NoExecute=OptOut also enables the /PAE switch, is this right??
The /3GB switch was put in so SQL could have more resources. Is it advisable to use the /PAE switch, the /3GB switch and /NoExecute=OptOut switch together? Would it help at all to chuck in the /PAE switch on this server.
Help is
greatly appreciated as I cannot find a link which explains the implications of using these switches together.