Aside from features like partioning, indexed views and parallel indexing, are there any actual performance differences between the Standard and Enterprise editions of SQL Server 2008?
Also, is the limitation of 4 CPUs relate to 4 cores or 4 physical CPUs?
In our environment we host a number of databases (same schema, different sizes) ranging up to 100GB. We host between 50 to 100 instances on a fail-over cluster.
Our architecture uses NHibernate between our application and the database.
I very much doubt any single database will grow more than 1000GB for the next few years.
The reason I ask is we about to scale out to a second cluster and I want to know whether it is worth the extra money for Enterprise (it is about 5 times more expensive). We currently are able to do all of the maintenance we need to on the previous version.
The only feature I can see that might be useful is the Resource Governor to ensure some queries don't take too much resource.
Best Answer
Other than the potential benefits you list plus the extra CPU capabilities there's no direct performance differences - it's not like MS 'throttle down' Standard.
Physical sockets/CPUs - not cores.
Only you can decide whether Enterprises additional features are worth the cost. I tend to put more than 64GB of memory in my MSSQL boxes so my hands are tied but you may not have that problem. And of course DB snapshots and encryption can come in handy, a lot of people but Enterprise purely for the data-mining tools too.