PAE Switch | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

PAE Switch

I have a server with 8GB physical memory, and I wanted to expand the memory from 2GB(default) to 6GB using AWE, so I did this: 1. added /PAE in boot.ini
2. sp_configure ‘show advanced options’, 1
sp_configure ‘awe enabled’, 1
sp_configure ‘max server memory’, 6144
RECONFIGURE with override
GO 3. shut down and restarted SQL Server When I run exec sp_configure ‘max server memory (MB)’ It returns – Name Min Max Configure_value Run_value
max server memory (MB)421474836476144 6144 And, it appears that Max server memory is still 2GB rather than 6GB that I requested. However, Configure and Run values are all 6GB. What do these two value mean? Should Max show 6GB instead of 2147483647. What did I do wrong in this setting? Any input would be greatly appreciated. Thank you very much.
No double postings please… MohammedU.
I´ve locked.
Luis Martin
Moderator All in Love is Fair
Stevie Wonder
All postings are provided “AS IS” with no warranties for accuracy.