Performance difference between SQL Server Standard & Enterprise Edition 2005

Is there really a pe开发者_如何学编程rformance difference between Standard & Enterprise Edition 2005 if I am not using any of the Enterprise Features ?

The Enterprise edition has a few things that Standard doesn't have:

• support for more than 4 CPU's
• partitioning
• parallel index operations
• indexed views

So if your apps would make use of those features, then yes - there can be a performance difference. But if you only manage a couple hundred items in a table - no difference....

See here for a complete feature comparison

Probably not in your case - since you know you're not using the Enterprise features.

Key performance difference affecting features would be indexed views (an optimization consideration), number of processors (need more than 4?), and table partitioning (can give performance boost, but primary purpose is not performance, but management - also an execution plan bug in 2005 which results in some partitioned table plans to be slower than non-partitioned table plans)