Posted by Erland Sommarskog on 12/15/06 12:42

Nishant Saini (nishant.saini@gmail.com) writes:
> We have a database which contains many tables which have millions of
> records. When We attach the database with MS SQL Server 2005 Standard
> Edition Server and run some queries (having joins, filters etc.) then
> they take very long time to execute while when We execute same queries
> on Enterprise Edition then they run 10 times faster than on standard
> edition.
>
> Our database does not use any features which are present in Enterprise
> Edition and not present in Standard Edition. We want to know what are
> the differences between Standard Edition and Enterprise Edition for
> performance. Why should we go for Enterprise Edition when Standard
> Edition has all the features required.

There is a topic that covers this in Books Online. On the top of my head
I don't recall anything immediate, but I'm off to other things right now,
and don't want to look around.

Could you post one of your queries you've been testing with and the
query plan on Standard and Enterprise?

I presume that you are running the two editions on the same hardware?


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]