3GB and 4GB RAM on SQL 2000 Ent, Win 2003 Ent

We have two SQL servers that we need to optimize the RAM for SQL server.
Both servers are running SQL 2000 Enterprise with Windows 2003 Enterprise.
What is the optimum boot.ini settings and SQL settings for these servers.
From what I have read so far, it seems I need to do the following:
On the 3 GB server, simply add the /3GB option in the boot.ini.
On the 4 GB server, simply add the /3GB option in the boot.ini as well. It
seems I only need to turn awe on the SQL server if it has more than 4 GB of
RAM.
Can anyone clarify this for me? Are there any known issues using these
settings?
Thank You,
Kevin
You are correct. AWE is only needed if you have more than 4GB of physical
memory in the box. Do not use /3GB with more than (12,16) GB of RAM. I
have heard different recommendations so pick either 12 or 16 GB as your
choice.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Kevin Hammond" <kghammond@.nrscorp.com> wrote in message
news:ck0pvg$77j$1@.grandcanyon.binc.net...
> We have two SQL servers that we need to optimize the RAM for SQL server.
> Both servers are running SQL 2000 Enterprise with Windows 2003 Enterprise.
> What is the optimum boot.ini settings and SQL settings for these servers.
> From what I have read so far, it seems I need to do the following:
> On the 3 GB server, simply add the /3GB option in the boot.ini.
> On the 4 GB server, simply add the /3GB option in the boot.ini as well.
It
> seems I only need to turn awe on the SQL server if it has more than 4 GB
of
> RAM.
> Can anyone clarify this for me? Are there any known issues using these
> settings?
> Thank You,
> Kevin
>
|||i don't think this is right. you need the AWE option of
sql server in any case. the question is only if you need
also the /PAE switch.
for clarifying this check out the MS KB-article 274750
"How to configure memory for more than 2 GB in SQL Server"
http://support.microsoft.com/default.aspx?scid=kb;en-
us;274750

>--Original Message--
>You are correct. AWE is only needed if you have more
than 4GB of physical
>memory in the box. Do not use /3GB with more than
(12,16) GB of RAM. I
>have heard different recommendations so pick either 12 or
16 GB as your[vbcol=seagreen]
>choice.
>--
>Geoff N. Hiten
>Microsoft SQL Server MVP
>Senior Database Administrator
>Careerbuilder.com
>I support the Professional Association for SQL Server
>www.sqlpass.org
>"Kevin Hammond" <kghammond@.nrscorp.com> wrote in message
>news:ck0pvg$77j$1@.grandcanyon.binc.net...
RAM for SQL server.[vbcol=seagreen]
Windows 2003 Enterprise.[vbcol=seagreen]
for these servers.[vbcol=seagreen]
following:[vbcol=seagreen]
boot.ini.[vbcol=seagreen]
boot.ini as well.[vbcol=seagreen]
>It
has more than 4 GB[vbcol=seagreen]
>of
issues using these
>
>.
>
|||If you only have 4GB it is probably better to let SQL Server have 3GB and let the OS have the rest
of the memory. Using PAE is not for free and it is also a bit if extra admin burden.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Juliane" <anonymous@.discussions.microsoft.com> wrote in message
news:0d2001c4abc3$08586640$a401280a@.phx.gbl...[vbcol=seagreen]
>i don't think this is right. you need the AWE option of
> sql server in any case. the question is only if you need
> also the /PAE switch.
> for clarifying this check out the MS KB-article 274750
> "How to configure memory for more than 2 GB in SQL Server"
> http://support.microsoft.com/default.aspx?scid=kb;en-
> us;274750
>
>
> than 4GB of physical
> (12,16) GB of RAM. I
> 16 GB as your
> RAM for SQL server.
> Windows 2003 Enterprise.
> for these servers.
> following:
> boot.ini.
> boot.ini as well.
> has more than 4 GB
> issues using these