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.