Memory below 4 GB is not usable for AWE. Use only the /3GB switch. And
extend the Server Max Memory configuration setting.

See:

Memory -AWE, Not usable < 4GB
http://download.microsoft.com/downlo...dv64BitEnv.doc


--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous


"Immy" <therealasianbabe@hotmail.com> wrote in message
news:uNjKKAM3GHA.4484@TK2MSFTNGP02.phx.gbl...
> OK - so assuming its standard edition, it supports 4GB.
> Check this link out for exactly how to do what you want -
> http://support.microsoft.com/kb/274750/
> But, I tend to agree with you, for the extra 1GB - I'm not so sure i'd go
> messing around with the OS.
>
> Immy
>
> "Simon" <Simon@discussions.microsoft.com> wrote in message
> news:4F31F562-88F7-441C-8C9D-702849E5A141@microsoft.com...
>>I am using Windwos 2003.
>>
>> Is it worth enabling AWE for a 4G server though ? I thought it need to be
>> more than 4G to make it worthwhile.
>>
>> I have already changed the setting in sp_configure.
>>
>> "Keith Kratochvil" wrote:
>>
>>> What OS are you running?
>>>
>>> Open Books Online and choose "Go" from the menu.
>>> Enter this into the url line:
>>> mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL%2 0Server\80\Tools\Books\architec.chm::/8_ar_sa_6b3k.htm
>>>
>>> The page that is displayed will be: Using AWE Memory on Windows 2000
>>>
>>> You should add /3GB or /PAE to the boot ini. You will also need to
>>> configure SQL Server to use the additional memory via sp_configure and
>>> the
>>> 'awe enabled' option.
>>>
>>> --
>>> Keith Kratochvil
>>>
>>>
>>> "Simon" <Simon@discussions.microsoft.com> wrote in message
>>> news86C6528-C966-42D1-9D8A-BBD32A7F8527@microsoft.com...
>>> >I have Enterprise edition though. But it still maxes out at 1.7G.
>>> >
>>> > Do I have to have the /3GB switch in the boot.ini ?
>>> >
>>> > "Keith Kratochvil" wrote:
>>> >
>>> >> From the "Maximum Capacity Specifications" within Books Online:
>>> >> SQL 2k Standard Edition only supports 2GB of RAM.
>>> >> SQL2k EE supports up to 64GB of RAM under the appropriate Operating
>>> >> System.
>>> >>
>>> >> --
>>> >> Keith Kratochvil
>>> >>
>>> >>
>>> >> "Simon" <Simon@discussions.microsoft.com> wrote in message
>>> >> news:FFAA80F9-D096-4045-8013-E32F0F6EC6B7@microsoft.com...
>>> >> >I have a dual processor server with 4G of memory. However SQL 2000
>>> >> >is
>>> >> >only
>>> >> > using 1.7G. I have looked at sp_configure to get SQL to use more
>>> >> > memory
>>> >> > but I
>>> >> > don`t seem to get better than 1.7G. Why is this ? What is the
>>> >> > easiest
>>> >> > way
>>> >> > to
>>> >> > increase the memory used by SQL ?
>>> >> >
>>> >> > Thanks
>>> >> >
>>> >> > Si
>>> >>
>>> >>
>>> >>
>>>
>>>
>>>
>
>