AWE Enabling 1

[alan12345]

I am using thw following to set a 1GIG max server memory for SQL Server:

sp_configure 'show advanced options', 1
RECONFIGURE
Go

sp_configure 'awe enabled', 1
RECONFIGURE
Go

sp_configure 'max server memory', 1024
RECONFIGURE
Go

But my server memory is not up to 1,103,928k which is bigger than 1,024,000k.

What happened?

Thanks,
Alan

 

[mrdenny]

1 Gig is 1,048,576k no 1,024,000k.

Turn AWE off. AWE is used to use over 2 Gigs of memory. For a server using 1 gig AWE is not needed.

Are you saying that your server is using 1,103,928k or memory? SQL may grab a little more memory than the setting so that it can finish loading an object into memory.

If you just reduced the amount of memory that SQL is alowed to use it can take time for the cache to flush it self out. Restarting the SQL Service will speed the process up.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com