Enterprise vs Standard

Question

Post reply

Enterprise vs Standard

Joe-192014

SSC Rookie

Points: 37
More actions
November 25, 2004 at 1:37 am

#163250

Hello
Currently I am working on the project which required me to decide what edition of MS SQL 2000 to use.
1) I would like to know the performance and stability of Enterprise & Standard edition.
We are using 3rd party clustering to improve availability which can go up to 99.995%. Feature wise, we don't need enterprise edition. My only worry is whether standard edition is stable enough or else there would be a lot of fail-over(s).
Could you guys please kindly advice me? I really appreciate that if you can point me where to get any researched or statistic data.
Best Regards,
Joe

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Frank Kalis SSC Guru Points: 111183 More actions · Answer 1

Maybe this is a starting point:

http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/sqlhalp.mspx

http://www.microsoft.com/usa/webcasts/ondemand/1883.asp

http://www.microsoft.com/technet/prodtechnol/sql/2000/plan/ssmsam.mspx

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

Joe-192014 SSC Rookie Points: 37 More actions · Answer 2

Hi Frank

Thanks a lot of pointing where to start. In fact, what I am looking for is kind of comparison between those 2 editions in term of stability. I would like to know how reliable and how many transactions can be done in 2 different editions.

Is there any differences in this boundary btw? I don't know where to get those statistics.

And thanks again for your kindness.

Joe