A question I often get asked by customers is which edition of SQL Server do I use? I then based on the workload, high availability/disaster recovery, scalability, BI and other requirements do walk the customer down to the decision.
You can also work through this using the edition comparison tool on the web at the following link - http://www.microsoft.com/sqlserver/en/us/product-info/compare.aspx. In the below example I am showing the comparison between Enterprise and Standard for the area of scalability and performance.
One thing that the tool doesn’t cover and is probably not as well known is that apart from features that you choose to use or not to use, Enterprise Edition has some built in optimizations that would enable better performance for an Enterprise workload. Including but not limited to:
Most of the time I end up recommending Enterprise Edition as it provides a platform that can grow with the solution.
Re "Most of the time I end up recommending Enterprise Edition as it provides a platform that can grow with the solution."
Do you take license recommendation?
@rj What is the recommendation?
The fact that it costs 10x as much obviously doesn't factor in your considerations...
Remind me again, who do you work for?
If I have a system with 192 gb of ram with a system running standard. How come I see SQL use over 150gb? If it only support 64gb then why is it using more than that and what is it being used for?
This link was removed, for those who still need this information can access this link I found
It's not mentioned anywhere, but you need the destination server to be Enterprise Edition for SSAS DB synchronisation.