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 !
>

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 !
>

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 !
>

Maximum Articles for Transaction Replication SQL 2000 and SQl 2005

Hello,
We are planing to implement transaction replication for 800 DB on SQL 2000
custer (as a publisher) and have seperate servers for Distribution and
Subscriber.
What is the maximum nnumber of articles I can have per DB.
What are the capacity limitations for this type of setup other than hardware
What other areas i need to make sure are in place before this is implemented.
Appreciate any comments
Please advise...
Thanks
Is that 800 databases or 1 db with 800 articles?
800 articles is no problem, I am replicating 850 with no problems, however
all in 1 db.
The problem you will have is on the distributor, you will define 800
publications, and 800 subscriptions - if only replicating to 1 server.
On distributor you will see a seperate exe for each replication agent. And
with trans you will have 1 Log Reader, 1 Snapshot, and 1 Distribution Agent
for each pub. Each exe will try to capture anywhere from 2 to 5Mb of RAM. You
do the math.
Best to test solution before implementation. And only replicate what you
absolutely need...
Good luck - post results if you implement in prod.
ChrisB MCDBA
MSSQLConsulting.com
"KetanB" wrote:

> Hello,
> We are planing to implement transaction replication for 800 DB on SQL 2000
> custer (as a publisher) and have seperate servers for Distribution and
> Subscriber.
> What is the maximum nnumber of articles I can have per DB.
> What are the capacity limitations for this type of setup other than hardware
> What other areas i need to make sure are in place before this is implemented.
> Appreciate any comments
> Please advise...
> Thanks