Currently, we use SQL Server 2008 standard edition. We are planning to improve the performance of our application. The application is built by 3<sup>rd</sup> party
and we can’t change/modify database objects and they seem to be designed fine.
The options are spending our budget to upgrade to sql server hardware, or upgrade to SQL Server Enterprise edition.
I am a bit confused over the benefits of SQL Server Enterprise edition. The following chart suggests that SQL EE includes “Parallel Index Operations”
and “Enhanced Read-ahead and Scan”:
How significant are “Parallel Index Operations” and “Enhanced Read-ahead and Scan”?
Considering the fact that new hardware is cheaper than sql enterprise license, Should I spend budget to upgrade enterprise edition instead of buying as server with
faster CPU and RAM?
View Complete Post