SQL Server 2017 Standard vs Enterprise Edition? [closed]
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?
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.