Enterprise versus Standard edition (2000 or 2005)

Hi All
I am a little puzzled now
Simple (or maybe not so simple) question
Is the Enterprise versions more "stable" or "usable" than the Standard
versions?
I got an email today stating this:
" (...) runs on the standard edition they may well run into problems down
the line with performance and usability"
Obviously Enterprise versions scales much better than standard versions and
the Enterprise versions has some features not supported in Standard versions
But consider a small server with max 2 cpu's and max 4Gb mem and max eg 50
users and only light load
Nothing special like data replication etc is used, you could use eg PostGRE
instead and you'll be fine
Any comments? - please :)
- Peter
--
Hi! I'm a .signature *virus*!
Copy me into your ~/.signature to help me spread!No difference regarding stability. As for usability, well, that can only mean that EE has features
that SE don't. If you don't need those features, then go for SE.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Peter Lykkegaard" <plykkegaard@.nospam.nospam> wrote in message
news:%23Ka01e7OHHA.2232@.TK2MSFTNGP02.phx.gbl...
> Hi All
> I am a little puzzled now
> Simple (or maybe not so simple) question
> Is the Enterprise versions more "stable" or "usable" than the Standard versions?
> I got an email today stating this:
> " (...) runs on the standard edition they may well run into problems down the line with
> performance and usability"
> Obviously Enterprise versions scales much better than standard versions and the Enterprise
> versions has some features not supported in Standard versions
> But consider a small server with max 2 cpu's and max 4Gb mem and max eg 50 users and only light
> load
> Nothing special like data replication etc is used, you could use eg PostGRE instead and you'll be
> fine
> Any comments? - please :)
> - Peter
> --
> Hi! I'm a .signature *virus*!
> Copy me into your ~/.signature to help me spread!
>|||Hi,
for the reference see the feature list on the MS website:
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
HTH, jens K. Suessmeyer.
--
http://www.sqlserver2005.de
--|||Peter Lykkegaard wrote:
> Hi All
> I am a little puzzled now
> Simple (or maybe not so simple) question
> Is the Enterprise versions more "stable" or "usable" than the Standard
> versions?
> I got an email today stating this:
> " (...) runs on the standard edition they may well run into problems down
> the line with performance and usability"
> Obviously Enterprise versions scales much better than standard versions and
> the Enterprise versions has some features not supported in Standard versions
> But consider a small server with max 2 cpu's and max 4Gb mem and max eg 50
> users and only light load
> Nothing special like data replication etc is used, you could use eg PostGRE
> instead and you'll be fine
> Any comments? - please :)
> - Peter
>
I've never heard any claims that one is more/less stable than the other.
Standard is limited in the amount of memory it can use, thus *may* not
perform as well as Enterprise under the right conditions. Enterprise
also offers some tools and features that Standard doesn't, but certainly
nothing affecting stability.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Jens wrote:
> for the reference see the feature list on the MS website:
Thanks :)
Online Restore and Fast Recovery could be of interest in some cases but only
as nice to have
- Peter
--
Hi! I'm a .signature *virus*!
Copy me into your ~/.signature to help me spread!