SQL Server 2017 Standard vs Enterprise Edition? [closed]

Question

I'm looking for a good resource that gives a breakdown of the feature differences between SQL Server 2017 Enterprise and Standard editions? I want to make sure there are no gotchas or I miss anything truly beneficial by going with Standard. I've read over the licensing guide from Microsoft, but is there any other notable feature differences it doesn't cover? What are the vaguely described feature differences like "Advanced Adaptive Query Processing", "Enterprise Data Management", and "Advanced Security", etc?

Ankit Chauhan · Accepted Answer

What ALL of the differences you are asking? You should ask individually specific questions about each of the feature/edition restrictions. For example, if you want to know what "Advanced Adaptive Query Processing" is, read the documentation pages on Adaptive Query Processing, and then ask questions specific to that feature. In my experience, the features that usually cause folks to jump to Enterprise Edition are:

Leveraging more than 24 CPU cores
Leveraging more than 128GB memory
Transparent Database Encryption (TDE) - if you're storing personally identifiable data that could put you on the front page of the paper if someone got a snapshot of your database, then the Enterprise Edition costs just kinda are what they are

SQL Server 2017 Standard vs Enterprise Edition With the SQL Server Standard Edition, you'll get basic data management and a business intelligence database designed with the smaller business in mind. Whereas the Enterprise Edition can provide the solution for businesses that demand high service levels for their workloads and also require end-user access to data insights.

SQL Server 2017 Standard vs Enterprise Edition? [closed]

About this question

Your answer

1 Answer

More Salesforce discussions

Learn & Explore

Salesforce Tutorials

Salesforce Interview Q&A

Latest Salesforce Blogs

Want answers to more Salesforce questions?

Stay in the loop — it’s free

You’re on the list!