any point in putting more than 2Gb ram in machine for standard edition ?

if a member server runs 2000 or 2003 with SQL server standard edition is
there any point putting more than 2Gb of ram in the machine ?
i.e i base this on 2Gb being the max for Sql server 200.
thanks for your advice
Scott
Standard edition is limited to 2GB so the additional memory won't be used by
SQL Server directly. However, the OS requires memory too so you should
consider this as well as memory needed by other apps. I usually spec 3GB
for a dedicated SQL Server 2000 running Standard Edition.
Hope this helps.
Dan Guzman
SQL Server MVP
"scott" <aintnoapmhere@.yahoo.com> wrote in message
news:%23T2POP72FHA.632@.TK2MSFTNGP10.phx.gbl...
> if a member server runs 2000 or 2003 with SQL server standard edition is
> there any point putting more than 2Gb of ram in the machine ?
> i.e i base this on 2Gb being the max for Sql server 200.
> thanks for your advice
> Scott
>
|||"scott" <aintnoapmhere@.yahoo.com> wrote in message
news:%23T2POP72FHA.632@.TK2MSFTNGP10.phx.gbl...
> if a member server runs 2000 or 2003 with SQL server standard edition is
> there any point putting more than 2Gb of ram in the machine ?
> i.e i base this on 2Gb being the max for Sql server 200.
> thanks for your advice
> Scott
>
Yes.
Don't forget about the O/S and any other stuff that is going on. Put at
least 3GB in the box. 1 for the O/S and 2 for SQL. ;-)
Rick Sawtell
MCT, MCSD, MCDBA
|||brilliant. many thanks
scott