AWE enabled ?

Hi All,

When i run the command,

use master
go
sp_configure 'awe enabled',1
go
reconfigure
go

I got the output,
name : awe enabled
minimum: 0
Maximum: 1
config_value: 0
run_value: 0

From the value of config_value ,it mean that the "awe" is not enabled.

But, when we see the System Configuration:
OS Win 2003 Standard sp1

Sql server 2005 sp1 ( I have only one instance )

System configuration = 3.83 GB of RAM

The total is 3.83GB of RAM, but When i right click the sql server
instance , select 'Properties' and then on the 'General' tab , i
see 'Memory' assigned to that instance as = 3927 (MB)

Does this mean that, someone already has enabled AWE option. That's
the reason its showing memory = 3927 MB. (or) i have to enable it
externally.

Can someone reply as soon as possible plz.

Thanks.

Here are the commands you need to run in SQL Server

sp_configure 'show advanced options', 1 RECONFIGURE GO sp_configure 'awe enabled', 1 RECONFIGURE GOYou also need to make sure your boot.ini file has the /PAE switch in it.|||

Hi GlennAlanBerry,

Do u mean to say /3GB (or) /PAE.

Because my Operating System is Win 2003 standard sp1 and sql server 2005 sp1.

And without enabling AWE also , sql server instance properties shows full sql server RAM?

Thanks.

|||If you only have 4GB of RAM in the server, and you want the OS to be able to use 3GB for applications instead of a max of 2GB, you would want to use the /3GB switch. If you had, say 8GB of RAM in the server, and you wanted the OS to be able to use more than 4GB of memory, you would want to use the /PAE switch.