PAE / AWE switch - SQL Server Forums

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

SQL Server 2000 Forums

SQL Server Administration (2000)

PAE / AWE switch

Author

Topic

Blin
Starting Member

36 Posts

Posted - 2007-03-12 : 16:18:17

I have a server with 8GB physical memory (SQL Server 2000), 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) 4 2147483647 6144 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.

snSQL
Master Smack Fu Yak Hacker

1837 Posts

Posted - 2007-03-12 : 16:33:39

That number is in MB, 6144MB is 6GB. So you have it configured for 6GB and it is running with 6GB. The 2147483647 value is the maximum that you can set it to, which is 2147483647MB, which is 2 petabytes, a little more than you're likely to have any time soon

Blin
Starting Member

36 Posts

Posted - 2007-03-12 : 16:51:32

Thanks for the explanation.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources