Saturday, February 25, 2012

AWE and Max Server Memory (MB)

What purpose does Max Server Memory (MB) serve, if I have 8 GB of RAM:
1. I have the switch properly set in the boot.ini
2. AWE Enabled is set to 1
3. Max Server Memory (MB) set to 2147483647
In other words, if I want to reserve 2 GB for my OS, then would not the Max
Server Memory (MB) set to 2147483647 allow SQL Server to use 6 GB?
--
Message posted via http://www.sqlmonster.comYou want to set the max server memory to 6 GB = 6 * 1,204 MB = 7,224 MB.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
"cbrichards via SQLMonster.com" <u3288@.uwe> wrote in message
news:65e80daa1f3f8@.uwe...
What purpose does Max Server Memory (MB) serve, if I have 8 GB of RAM:
1. I have the switch properly set in the boot.ini
2. AWE Enabled is set to 1
3. Max Server Memory (MB) set to 2147483647
In other words, if I want to reserve 2 GB for my OS, then would not the Max
Server Memory (MB) set to 2147483647 allow SQL Server to use 6 GB?
--
Message posted via http://www.sqlmonster.com|||You should also see my reply to your original post on this subject.
--
Andrew J. Kelly SQL MVP
"cbrichards via SQLMonster.com" <u3288@.uwe> wrote in message
news:65e80daa1f3f8@.uwe...
> What purpose does Max Server Memory (MB) serve, if I have 8 GB of RAM:
> 1. I have the switch properly set in the boot.ini
> 2. AWE Enabled is set to 1
> 3. Max Server Memory (MB) set to 2147483647
> In other words, if I want to reserve 2 GB for my OS, then would not the
> Max
> Server Memory (MB) set to 2147483647 allow SQL Server to use 6 GB?
> --
> Message posted via http://www.sqlmonster.com
>

No comments:

Post a Comment