Maximum Memory for standart edition / enterprise

Hello there
I am runing on sql 7 environment and planing to move to 2k environment
(quite late but.....).
for one of the databases, I have a server with 4G of ram but I have only sql
server standart, I am wondering if it will still take 4 G of ram since MS
claims it will take only 2 G'
for some reason I heard that it can utilize the full 4G ?
another thing is: I have licenses for 1 processor, do you guys know if I can
upgrade that to 2?
thanks !Hi,
SQL Standard edition can only use 2 GB RAM at the max. To utilize more you
have to use SQL Server Enterprise edition.
I have licenses for 1 processor, do you guys know if I can upgrade that to
2?
http://www.microsoft.com/sql/howtobuy/default.asp
Thanks
Hari
MCDBA
"simo sentissi" <simo_sentissi@.skc.edu> wrote in message
news:OVG$ndQZEHA.1652@.TK2MSFTNGP09.phx.gbl...
> Hello there
> I am runing on sql 7 environment and planing to move to 2k environment
> (quite late but.....).
> for one of the databases, I have a server with 4G of ram but I have only
sql
> server standart, I am wondering if it will still take 4 G of ram since MS
> claims it will take only 2 G'
> for some reason I heard that it can utilize the full 4G ?
> another thing is: I have licenses for 1 processor, do you guys know if I
can
> upgrade that to 2?
>
> thanks !
>