Posted by Gert-Jan Strik on 12/18/06 19:31

lucm wrote:
>
> > Right now we need to know
> >
> > 1. Enterprise Edition has its own Query running mechanism ( which is
> > different and faster than Standard Edition mechanism) or NOT ?
> > 2. If it is special, what kind of performance differences we will get
> > while using Std Edition.
> > 3. Is there any specific DB size ( or table sizes ) for which Standard
> > Edition is fine and after that one should go for Enterprise.
> >
> > Thanks in advance
> > Nitin Goyal
>
> The engine is not the same. Have a look here:
> http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
> especially in "Scalability and Performance" and "High Availability"
> sections.
>
> As for choosing Standard or Enterprise, you should think about
> concurrent users and operations, not database size.
>
> Regards,
> lucm

Although the storage engine is different (or at least exposes more
features), the query optimizer is the same. So if you are not using
indexed views, you can live with 4 CPU's and you do not need the
advanced OLAP tools, then you can expect the same query performance. The
only documented exception is Advanced Scans which could improve
performance in OLAP type situations.

For a manageability and high availability point of view, there are many
reasons to choose EE, but IMO not from a performance point of view
(given the restrictions above).

If you disagree with me, then please mention a specific feature that
will cause EE to outperform SE (on regular DML statements).

Gert-Jan

[Back to original message]