Posted by Russ Rose on 12/15/06 21:54

"Nishant Saini" <nishant.saini@gmail.com> wrote in message
news:1166180480.672397.223250@73g2000cwn.googlegroups.com...
> 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.

Assuming identical hardware, a 10x speed difference is usually the
difference between memory and disk access. Clear the procedure and memory
cache prior to side by side testing.

>
> 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.

I only consider EE if the hardware requires the use.

>
> 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]