"Linchi Shea" <LinchiShea@discussions.microsoft.com> wrote in message
news:F6FB03D7-3B0F-4CD1-B2A2-BBFD660502EE@microsoft.com...
> Hari;
>
> My comment had nothing to do with whether /3GB is used, how it should be
> used, or what impact it may have. I was commenting on the statement that
> AWE
> can be used only if you have more than 4GB physical memory. As the data at
> the link indicate that setting AWE has an impact on SQL Server memory
> consumption even with 4GB physical memory. And if you want your bpool to
> consume a certain amount of memory under 4GB, you may need to use AWE to
> accomplish that.
>
> Now, whether or not you should use AWE with less than 4GB of physical
> memory
> or whether there is any compelling rason for doing so are entirely
> different
> issue.
>
> Linchi
>
> "Hari Prasad" wrote:
>
>> Hello Linchi,
>>
>> If I remember correct for a server with 4 GB RAM running in SQL Server
>> 2005
>> 32 bit and Windows 2003 Advanced, all I did is just /3GB switch in
>> Boot.ini
>> to
>> use 3 GB RAM. I will take a look into the server on Moday and keep you
>> posted
>>
>> Thanks
>> Hari
>>
>>
>>
>>
>> "Linchi Shea" <LinchiShea@discussions.microsoft.com> wrote in message
>> news:45A920F2-86E6-4A86-A1B1-8306C3077E8B@microsoft.com...
>> >> AWE can be used only if you have more than 4 GB physical memory.
>> >
>> > That's not correct. Take a look at some empirical data at
>> > http://sqlblog.com/blogs/linchi_shea/default.aspx?p=2
>> >
>> > Linchi
>> >
>> > "Hari Prasad" wrote:
>> >
>> >> Hello,
>> >>
>> >> AWE can be used only if you have more than 4 GB physical memory. But
>> >> The
>> >> /3GB switch is used to tell SQL Server to take advantage of 3GB out of
>> >> the
>> >> base 4GB
>> >> of RAM that Windows OS supports natively. If you don't specify this
>> >> option,
>> >> then SQL Server will only take advantage of 2GB of the first 4GB of
>> >> RAM
>> >> in
>> >> the
>> >> server, essentially wasting 1GB of RAM
>> >>
>> >> Please post the OS and SQL Server edition. This is because For SQL
>> >> Server
>> >> 2005 - 64 bit running in Windows 2003 you donot want any changes in
>> >> BOOT.INI
>> >> to use the additional RAM.
>> >>
>> >> Thanks
>> >> Hari
>> >>
>> >>
>> >>
>> >> "Leila" <Leilas@hotpop.com> wrote in message
>> >> news:OEze$NnfHHA.2432@TK2MSFTNGP03.phx.gbl...
>> >> > Hi,
>> >> > Imagine that my server has 4GB physical memory. I have added /3GB
>> >> > switch
>> >> > to boot.ini.
>> >> > Should I enable AWE configuration for my SQL Server to use 3 GB
>> >> > address
>> >> > space? Or AWE must only be used when I have more than 4GB memory?
>> >> > Thanks in advance,
>> >> > Leila
>> >> >
>> >>
>> >>
>> >>
>>
>>
>>