CODEWITHSUNDEEP
sqlsql-server-2005
nevhirion
nevhirion

Reputation: 11

Performance difference between SQL Server Standard & Enterprise Edition 2005

Is there really a performance difference between Standard & Enterprise Edition 2005 if I am not using any of the Enterprise Features ?

Upvotes: 1

Views: 3450

Answers (2)

Cade Roux
Cade Roux

Reputation: 89651

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)

Upvotes: 1

marc_s
marc_s

Reputation: 754258

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

Upvotes: 6

Related Questions