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.

AWE / Maximum Server Memory

We have a clustered environment with each node having 8GB memory, Win2k3
Enterprise Edition SP2, and SQL2k Enterprise Edition SP4.
I have read a few articles on AWE and the following link provided me with a
lot of information, but I still have a few questions:
http://www.sql-server-performance.com/awe_memory.asp
I understand that the switches that I should use are /3GB /PAE.
In the above article it stated that AWE technology is used only for the RAM
that exceeds the base 4GB of RAM. It further states that once the AWE
Enabled option is set to 1, SQL Server will take all of the RAM except 128MB
reserved for the OS. My question here is whether this statement refers to
128MB of the available AWE memory (e.g. the 128MB of the 4GB that is not from
the base 4GB in an 8GB configuration). So with the /3GB switch and AWE
enabled, does the operating system have approxiamtely 1.128GB dedicated to
the OS or only 128MB (this latter seems much too low).
When setting "Maximum Server Memory" does this refer to the entire 8GB (my
guess is yes)? And with no other applications running, should this be set to
8GB or (8GB - 1.128GB => 6.872GB).
The only other applications that we have running are the Vertias Client for
Backups and Symantec's Antivirus besides the standard Windows 2003 services.
I'm sure most production environments have something very similar. What
sould the recommended "Maximum Server Memory" be set to for a 8GB environment
with these services running.
Thanks,
Larry
Larry
> When setting "Maximum Server Memory" does this refer to the entire 8GB (my
> guess is yes)? And with no other applications running, should this be set
> to
> 8GB or (8GB - 1.128GB => 6.872GB).
Yes , you can set up even to 7GB :-))

> The only other applications that we have running are the Vertias Client
> for
> Backups and Symantec's Antivirus besides the standard Windows 2003
> services.
> I'm sure most production environments have something very similar. What
> sould the recommended "Maximum Server Memory" be set to for a 8GB
> environment
> with these services running.
You have to determine how much memory does each proccess take and
according to it set the MAX memory
"Larry Herbinaux" <LarryHerbinaux@.discussions.microsoft.com> wrote in
message news:7E65D50A-7BA1-4F5E-B62A-B8F9792C77CC@.microsoft.com...
> We have a clustered environment with each node having 8GB memory, Win2k3
> Enterprise Edition SP2, and SQL2k Enterprise Edition SP4.
> I have read a few articles on AWE and the following link provided me with
> a
> lot of information, but I still have a few questions:
> http://www.sql-server-performance.com/awe_memory.asp
> I understand that the switches that I should use are /3GB /PAE.
> In the above article it stated that AWE technology is used only for the
> RAM
> that exceeds the base 4GB of RAM. It further states that once the AWE
> Enabled option is set to 1, SQL Server will take all of the RAM except
> 128MB
> reserved for the OS. My question here is whether this statement refers to
> 128MB of the available AWE memory (e.g. the 128MB of the 4GB that is not
> from
> the base 4GB in an 8GB configuration). So with the /3GB switch and AWE
> enabled, does the operating system have approxiamtely 1.128GB dedicated to
> the OS or only 128MB (this latter seems much too low).
> When setting "Maximum Server Memory" does this refer to the entire 8GB (my
> guess is yes)? And with no other applications running, should this be set
> to
> 8GB or (8GB - 1.128GB => 6.872GB).
> The only other applications that we have running are the Vertias Client
> for
> Backups and Symantec's Antivirus besides the standard Windows 2003
> services.
> I'm sure most production environments have something very similar. What
> sould the recommended "Maximum Server Memory" be set to for a 8GB
> environment
> with these services running.
> Thanks,
> Larry
|||just to mention to be carefuly on mem counting having full 4gb of mem.
close to 4gb boundary, there may be memory mapped area used by motherboard
[pci cards etc], which may take almost 0,5gb of memory.
so, instead of 4gb, you may find available only 3,5gb appx or so
"Larry Herbinaux" <LarryHerbinaux@.discussions.microsoft.com> je napisao u
poruci interesnoj
grupi:7E65D50A-7BA1-4F5E-B62A-B8F9792C77CC@.microsoft.com...
> We have a clustered environment with each node having 8GB memory, Win2k3
> Enterprise Edition SP2, and SQL2k Enterprise Edition SP4.
> enabled, does the operating system have approxiamtely 1.128GB dedicated to
> the OS or only 128MB (this latter seems much too low).
>
> Larry

AWE / Maximum Server Memory

We have a clustered environment with each node having 8GB memory, Win2k3
Enterprise Edition SP2, and SQL2k Enterprise Edition SP4.
I have read a few articles on AWE and the following link provided me with a
lot of information, but I still have a few questions:
http://www.sql-server-performance.com/awe_memory.asp
I understand that the switches that I should use are /3GB /PAE.
In the above article it stated that AWE technology is used only for the RAM
that exceeds the base 4GB of RAM. It further states that once the AWE
Enabled option is set to 1, SQL Server will take all of the RAM except 128MB
reserved for the OS. My question here is whether this statement refers to
128MB of the available AWE memory (e.g. the 128MB of the 4GB that is not from
the base 4GB in an 8GB configuration). So with the /3GB switch and AWE
enabled, does the operating system have approxiamtely 1.128GB dedicated to
the OS or only 128MB (this latter seems much too low).
When setting "Maximum Server Memory" does this refer to the entire 8GB (my
guess is yes)? And with no other applications running, should this be set to
8GB or (8GB - 1.128GB => 6.872GB).
The only other applications that we have running are the Vertias Client for
Backups and Symantec's Antivirus besides the standard Windows 2003 services.
I'm sure most production environments have something very similar. What
sould the recommended "Maximum Server Memory" be set to for a 8GB environment
with these services running.
Thanks,
LarryLarry
> When setting "Maximum Server Memory" does this refer to the entire 8GB (my
> guess is yes)? And with no other applications running, should this be set
> to
> 8GB or (8GB - 1.128GB => 6.872GB).
Yes , you can set up even to 7GB :-))
> The only other applications that we have running are the Vertias Client
> for
> Backups and Symantec's Antivirus besides the standard Windows 2003
> services.
> I'm sure most production environments have something very similar. What
> sould the recommended "Maximum Server Memory" be set to for a 8GB
> environment
> with these services running.
You have to determine how much memory does each proccess take and
according to it set the MAX memory
"Larry Herbinaux" <LarryHerbinaux@.discussions.microsoft.com> wrote in
message news:7E65D50A-7BA1-4F5E-B62A-B8F9792C77CC@.microsoft.com...
> We have a clustered environment with each node having 8GB memory, Win2k3
> Enterprise Edition SP2, and SQL2k Enterprise Edition SP4.
> I have read a few articles on AWE and the following link provided me with
> a
> lot of information, but I still have a few questions:
> http://www.sql-server-performance.com/awe_memory.asp
> I understand that the switches that I should use are /3GB /PAE.
> In the above article it stated that AWE technology is used only for the
> RAM
> that exceeds the base 4GB of RAM. It further states that once the AWE
> Enabled option is set to 1, SQL Server will take all of the RAM except
> 128MB
> reserved for the OS. My question here is whether this statement refers to
> 128MB of the available AWE memory (e.g. the 128MB of the 4GB that is not
> from
> the base 4GB in an 8GB configuration). So with the /3GB switch and AWE
> enabled, does the operating system have approxiamtely 1.128GB dedicated to
> the OS or only 128MB (this latter seems much too low).
> When setting "Maximum Server Memory" does this refer to the entire 8GB (my
> guess is yes)? And with no other applications running, should this be set
> to
> 8GB or (8GB - 1.128GB => 6.872GB).
> The only other applications that we have running are the Vertias Client
> for
> Backups and Symantec's Antivirus besides the standard Windows 2003
> services.
> I'm sure most production environments have something very similar. What
> sould the recommended "Maximum Server Memory" be set to for a 8GB
> environment
> with these services running.
> Thanks,
> Larry|||just to mention to be carefuly on mem counting having full 4gb of mem.
close to 4gb boundary, there may be memory mapped area used by motherboard
[pci cards etc], which may take almost 0,5gb of memory.
so, instead of 4gb, you may find available only 3,5gb appx or so
"Larry Herbinaux" <LarryHerbinaux@.discussions.microsoft.com> je napisao u
poruci interesnoj
grupi:7E65D50A-7BA1-4F5E-B62A-B8F9792C77CC@.microsoft.com...
> We have a clustered environment with each node having 8GB memory, Win2k3
> Enterprise Edition SP2, and SQL2k Enterprise Edition SP4.
> enabled, does the operating system have approxiamtely 1.128GB dedicated to
> the OS or only 128MB (this latter seems much too low).
>
> Larry

AWE / Maximum Server Memory

We have a clustered environment with each node having 8GB memory, Win2k3
Enterprise Edition SP2, and SQL2k Enterprise Edition SP4.
I have read a few articles on AWE and the following link provided me with a
lot of information, but I still have a few questions:
http://www.sql-server-performance.com/awe_memory.asp
I understand that the switches that I should use are /3GB /PAE.
In the above article it stated that AWE technology is used only for the RAM
that exceeds the base 4GB of RAM. It further states that once the AWE
Enabled option is set to 1, SQL Server will take all of the RAM except 128MB
reserved for the OS. My question here is whether this statement refers to
128MB of the available AWE memory (e.g. the 128MB of the 4GB that is not fro
m
the base 4GB in an 8GB configuration). So with the /3GB switch and AWE
enabled, does the operating system have approxiamtely 1.128GB dedicated to
the OS or only 128MB (this latter seems much too low).
When setting "Maximum Server Memory" does this refer to the entire 8GB (my
guess is yes)? And with no other applications running, should this be set t
o
8GB or (8GB - 1.128GB => 6.872GB).
The only other applications that we have running are the Vertias Client for
Backups and Symantec's Antivirus besides the standard Windows 2003 services.
I'm sure most production environments have something very similar. What
sould the recommended "Maximum Server Memory" be set to for a 8GB environmen
t
with these services running.
Thanks,
LarryLarry
> When setting "Maximum Server Memory" does this refer to the entire 8GB (my
> guess is yes)? And with no other applications running, should this be set
> to
> 8GB or (8GB - 1.128GB => 6.872GB).
Yes , you can set up even to 7GB :-))

> The only other applications that we have running are the Vertias Client
> for
> Backups and Symantec's Antivirus besides the standard Windows 2003
> services.
> I'm sure most production environments have something very similar. What
> sould the recommended "Maximum Server Memory" be set to for a 8GB
> environment
> with these services running.
You have to determine how much memory does each proccess take and
according to it set the MAX memory
"Larry Herbinaux" <LarryHerbinaux@.discussions.microsoft.com> wrote in
message news:7E65D50A-7BA1-4F5E-B62A-B8F9792C77CC@.microsoft.com...
> We have a clustered environment with each node having 8GB memory, Win2k3
> Enterprise Edition SP2, and SQL2k Enterprise Edition SP4.
> I have read a few articles on AWE and the following link provided me with
> a
> lot of information, but I still have a few questions:
> http://www.sql-server-performance.com/awe_memory.asp
> I understand that the switches that I should use are /3GB /PAE.
> In the above article it stated that AWE technology is used only for the
> RAM
> that exceeds the base 4GB of RAM. It further states that once the AWE
> Enabled option is set to 1, SQL Server will take all of the RAM except
> 128MB
> reserved for the OS. My question here is whether this statement refers to
> 128MB of the available AWE memory (e.g. the 128MB of the 4GB that is not
> from
> the base 4GB in an 8GB configuration). So with the /3GB switch and AWE
> enabled, does the operating system have approxiamtely 1.128GB dedicated to
> the OS or only 128MB (this latter seems much too low).
> When setting "Maximum Server Memory" does this refer to the entire 8GB (my
> guess is yes)? And with no other applications running, should this be set
> to
> 8GB or (8GB - 1.128GB => 6.872GB).
> The only other applications that we have running are the Vertias Client
> for
> Backups and Symantec's Antivirus besides the standard Windows 2003
> services.
> I'm sure most production environments have something very similar. What
> sould the recommended "Maximum Server Memory" be set to for a 8GB
> environment
> with these services running.
> Thanks,
> Larry|||just to mention to be carefuly on mem counting having full 4gb of mem.
close to 4gb boundary, there may be memory mapped area used by motherboard
[pci cards etc], which may take almost 0,5gb of memory.
so, instead of 4gb, you may find available only 3,5gb appx or so
"Larry Herbinaux" <LarryHerbinaux@.discussions.microsoft.com> je napisao u
poruci interesnoj
grupi:7E65D50A-7BA1-4F5E-B62A-B8F9792C77CC@.microsoft.com...
> We have a clustered environment with each node having 8GB memory, Win2k3
> Enterprise Edition SP2, and SQL2k Enterprise Edition SP4.
> enabled, does the operating system have approxiamtely 1.128GB dedicated to
> the OS or only 128MB (this latter seems much too low).
>
> Larry