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
RECONFIGURE
GO
sp_configure ‘awe enabled’, 1
RECONFIGURE
GO
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… http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=20086 MohammedU.
Moderator
SQL-Server-Performance.com

IÂ´ve locked.
Luis Martin
Moderator
SQL-Server-Performance.com All in Love is Fair
Stevie Wonder
All postings are provided â€œAS ISâ€ with no warranties for accuracy.

]]>