AWE enable help - 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 2005 Forums

SQL Server Administration (2005)

AWE enable help

Author

Topic

gangadhara.ms
Aged Yak Warrior

549 Posts

Posted - 2010-10-18 : 01:36:16

Dear Experts,

I required help to set max and min memory on my production and test server to enable AWE.

1.I have a test server with 8GB of RAM and i need to enable AWE on it.
SQL server 2005 Enterprise edition on Windows server 2003

what will be server min and max memory i need to set ?

2.I have a PROD server with 32GB of RAM and i need to enable AWE on it.
SQL server 2005 Enterprise edition on Windows server 2003

what will be server min and max memory i need to set ?

Both the servers are dedicated SQL server,

I have using this query to enable AWE:

The following example shows how to enable AWE and to configure the min server memory to 1 GB and the max server memory to 6 GB:
First, enable AWE:

sp_configure 'show advanced options', 1
RECONFIGURE
GO
sp_configure 'awe enabled', 1
RECONFIGURE
GO

After SQL Server restarts, the following message should appear in the SQL Server error log: Address Windowing Extensions enabled.
Next, configure memory:

sp_configure 'min server memory', 1024
RECONFIGURE
GO
sp_configure 'max server memory', 6144
RECONFIGURE
GO

My main concern here is to how much will be the min and max memory ?

Thanks,
Gangadhar

gangadhara.ms
Aged Yak Warrior

549 Posts

Posted - 2010-10-19 : 00:57:44

Can please somebody suggest me here!!!

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2010-10-19 : 18:30:25

well, looks like you answered your own question. that's why no responses.

gangadhara.ms
Aged Yak Warrior

549 Posts

Posted - 2010-10-20 : 00:58:17

Hi Russell,

Actually my question was with for 8GB RAM what should be the min and max server memory ?

And for 32GB of RAM what should be the min and max server memory to enable AWE for proper utilization?

Hope somebody will reply to question

Thanks In advance,
Gangadhar

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2010-10-20 : 11:32:12

Assuming it is the only instance on the box, I'll leave 1.5 - 2.0 GB for the OS of the 8 GB of RAM, so probably I'd start with max memory of 6656.

For the 32GB box, again assuming it's the only instance, I'll leave 4 GB for the OS, so I'll set max memory to 28672.

I don't bother to configure minimum memory setting.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources