Posted by Greg D. Moore \(Strider\) on 12/18/06 13:10

<nitin.goel@daffodildb.com> wrote in message
news:1166429585.200709.298530@80g2000cwy.googlegroups.com...
> As Nishant said we are not using any special features of Enterprise
> Edition. Indexed views are not being used and data is taken directly
> from tables.
>
> Regarding the execution plan, it may be different due to different
> sizes of both databases. We are right now trying to check execution
> plan for similar databases on both editions. We will post our findings
> as soon as we get them.
>
> 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 ?

The query engine is the same.


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

Not specifically.

However, Enterprise Edition supports more physical RAM which can make some
queries faster.

In addition, it can support things like parellelized query builds.

In general EE is more for specific features (like clustering beyond 2 nodes)
than pure size.

If you have a mission critical database that's 1 gig, but you want an N+2
architecture, you'll want EE.

If you have a datawarehouse that 500 gig that can be down for periods of
time during restores, etc, Standard Edition may be fine.

Check out MS's page on feature differences.

>
> Thanks in advance
> Nitin Goyal
>
>
> On Dec 16, 4:39 pm, Erland Sommarskog <esq...@sommarskog.se> wrote:
>> Nishant Saini (nishant.sa...@gmail.com) writes:
>> > Thanks for the responses...
>>
>> > Yes, The execution plans are different in both the databases.
>> > Why the execution plans are so different in both the versions of SQL
>> > Server 2005?There could be many reasons for that. Roy Harvey mentioned
>> > indexed views
>> for instance.
>>
>> If you want a better answer, please post the query and the two plans,
>> so that we know what we are talking about.
>>
>> > Can we control the execution plans?Yes. SQL 2005 actually permit you to
>> > specify the plan exactly to using
>> plan guides. This is definitely an advance feature, and nothing you
>> should use at a whim.
>>
>> --
>> Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se
>>
>> Books Online for SQL Server 2005
>> athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
>> Books Online for SQL Server 2000
>> athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
>

[Back to original message]