Posted by Gert-Jan Strik on 12/15/06 18:52

Although Enterprise Edition is more aggresive when it comes to
read-aheads, and has some features that can improves performance in some
very specific situations (such a parallel index creation, Advanced
Scanning, etc.), if both systems have the same amount of memory, then I
would not expect a 10-fold performance difference.

How much memory does the system have, and have you assigned this memory
to SQL Server?

You could copy the "fast" database to the "slow" configuration with
detach/attach and see if that makes a difference. This way you can rule
out any database differences (such as one database with up-to-date
statistics and another with unusable or no statistics).

HTH,
Gert-Jan


Nishant Saini wrote:
>
> Dear All,
>
> 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.
>
> We are presently using evaluation versions of SQL Server 2005 Standard
> and Enterprise Editions.
>
> Thanks and regards,
> Nishant Saini
> http://www.simplyjava.com

[Back to original message]