Benchmark for different edition of sql server 2000

Our company is pondering whether we should upgrade from
standard version to enterprise version. Some high level
people is very concerned about the price.
Is there any good article/whitepaper for this? Something
like industry standard, micrsoft recommendataion,etc?
Thanks.What are your reasons for upgrading? Unless you use the features =specific to Enterprise, it might not be worth the cost.
You can refer to http://www.microsoft.com/sql/techinfo/default.asp
for all sorts of information on SQL Server.
-- Keith
"JZHU" <hzhua16@.hotmail.com> wrote in message =news:005901c39f14$1673b570$a501280a@.phx.gbl...
> Our company is pondering whether we should upgrade from
> standard version to enterprise version. Some high level
> people is very concerned about the price. > Is there any good article/whitepaper for this? Something
> like industry standard, micrsoft recommendataion,etc?
> > Thanks.|||Thanks. My major concern is about the memory. Our database
is around 150-200 GB right now, and support 2000-3000
users. The standard version only support 2G memory. Is it
too little? Currently, when we run the query, most of the
time, it has physical read instead of logical read.
>--Original Message--
>What are your reasons for upgrading? Unless you use the
features specific to Enterprise, it might not be worth the
cost.
>You can refer to
>http://www.microsoft.com/sql/techinfo/default.asp
>for all sorts of information on SQL Server.
>--
>Keith
>
>"JZHU" <hzhua16@.hotmail.com> wrote in message
news:005901c39f14$1673b570$a501280a@.phx.gbl...
>> Our company is pondering whether we should upgrade from
>> standard version to enterprise version. Some high level
>> people is very concerned about the price.
>> Is there any good article/whitepaper for this? Something
>> like industry standard, micrsoft recommendataion,etc?
>> Thanks.
>.
>|||> Thanks. My major concern is about the memory. Our database
> is around 150-200 GB right now, and support 2000-3000
> users. The standard version only support 2G memory. Is it
> too little?
Could be, but it depends of the sweetspot for your memory usage. How about acquiring Developer
Edition and run your benchmark test against this? It is only some $50.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"JZHU" <hzhua16@.hotmail.com> wrote in message news:047a01c39f1e$596c2240$a101280a@.phx.gbl...
> Thanks. My major concern is about the memory. Our database
> is around 150-200 GB right now, and support 2000-3000
> users. The standard version only support 2G memory. Is it
> too little? Currently, when we run the query, most of the
> time, it has physical read instead of logical read.
> >--Original Message--
> >What are your reasons for upgrading? Unless you use the
> features specific to Enterprise, it might not be worth the
> cost.
> >
> >You can refer to
> >http://www.microsoft.com/sql/techinfo/default.asp
> >for all sorts of information on SQL Server.
> >
> >--
> >Keith
> >
> >
> >"JZHU" <hzhua16@.hotmail.com> wrote in message
> news:005901c39f14$1673b570$a501280a@.phx.gbl...
> >> Our company is pondering whether we should upgrade from
> >> standard version to enterprise version. Some high level
> >> people is very concerned about the price.
> >> Is there any good article/whitepaper for this? Something
> >> like industry standard, micrsoft recommendataion,etc?
> >>
> >> Thanks.
> >.
> >