Memory Settings

Hi - we have SQL Server Enterprise 2005 and Windows Standard 2003, with 8GB
RAM on the box. 3 questions for the experts:
(1) Firstly, my understanding is that only 4GB can be used by windows - is
this correct?
(2) do we still have to change boot.ini file or is this not needed with
windows 2003?
(3) do we need to make changes to sp_configure - the max server memory will
need changing but how about the AWE setting?
Thanks.Jack
- Enabling Memory Support for Over 4GB of Physical Memory
http://msdn2.microsoft.com/en-us/library/ms179301.aspx
"Jack" <jack@.Nospam.com> wrote in message
news:%2367lbLjDHHA.3492@.TK2MSFTNGP02.phx.gbl...
> Hi - we have SQL Server Enterprise 2005 and Windows Standard 2003, with
> 8GB RAM on the box. 3 questions for the experts:
> (1) Firstly, my understanding is that only 4GB can be used by windows - is
> this correct?
> (2) do we still have to change boot.ini file or is this not needed with
> windows 2003?
> (3) do we need to make changes to sp_configure - the max server memory
> will need changing but how about the AWE setting?
> Thanks.
>|||Also
http://blogs.msdn.com/slavao/
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:upLFsNjDHHA.4404@.TK2MSFTNGP06.phx.gbl...
> Jack
> - Enabling Memory Support for Over 4GB of Physical Memory
> http://msdn2.microsoft.com/en-us/library/ms179301.aspx
>
>
> "Jack" <jack@.Nospam.com> wrote in message
> news:%2367lbLjDHHA.3492@.TK2MSFTNGP02.phx.gbl...
>|||Hi Jack,
I just started playing with AWE my self and this is what I found so far.
SQL Server 2005 can make use of the extra memory with modifying the boot.ini
.
Make sure that the account that the sql service is running as is part of the
lock pages in memory group policy, AWE is enabled in SQL server, and
configure max memory in SQL server to be at most 7GB, leaving 1 GB for the
OS. If you go to 16 GB of RAM then leave 2 GB free for the OS. The max tha
t
the OS can use depends on the version of the OS that you are running I think
.
--
MG
"Jack" wrote:

> Hi - we have SQL Server Enterprise 2005 and Windows Standard 2003, with 8G
B
> RAM on the box. 3 questions for the experts:
> (1) Firstly, my understanding is that only 4GB can be used by windows - is
> this correct?
> (2) do we still have to change boot.ini file or is this not needed with
> windows 2003?
> (3) do we need to make changes to sp_configure - the max server memory wil
l
> need changing but how about the AWE setting?
> Thanks.
>
>