All things Data Related....

On this site I will be posting entries related to Data platform and analytics that I learn and believe could be valuable learning to others who want insight from their data

SQL Server Standard vs. Enterprise Edition

SQL Server Standard vs. Enterprise Edition

  • Comments 11
  • Likes

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 - 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.

  • This article sucks. Nothing additional , I can access directly to that link and get the same. Why you don't post about prices or some personal comparison based on experience?

  • I am having a standard version of the sql server now ,but need to use the CDC which is not possible with this edition . How is it possible to get this edition changed to Developer or Enterprise Edition . How easy or difficult it is and whats the expense for the same. Also will the existing data and databases get affected if the change happens . Please advise me on these queries .

Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment