1

I know that for SharePoint 2016 version we can go for either SQL server 2016 standard or enterprise. But just wanted to know are there any disadvantages of going for SQL server standard edition instead of enterprise?

My question is in particular to the SharePoint features we might be missing if we go for Standard SQL server.

migrated from stackoverflow.com Jan 22 at 23:47

This question came from our site for professional and enthusiast programmers.

1

Are there any disadvantages of going for SQL server standard edition instead of enterprise

The disadvantage is you can't use enterprise features, like AlwaysOn AG among others (see below). If you aren't going to use these features, then you don't need Enterprise generally speaking. The advantage is you'd save some money. Both are licensed per core, and enterprise costs more per core.... like 4X more than standard.

Here are features that come in Enterprise that don't come in Standard:

  • Unlimited memory (max of OS)
  • Online Page restore
  • Online index rebuilds
  • Mirrored backups
  • Automatic tuning
  • Transparent database encryption
  • Parallel index operations
  • etc...

See the data sheets, and the full comparisons for the differences. Generally speaking, unless you really need those enterprise features, I'd would opt for standard for the HUGE cost savings.

Microsoft also has a guide to help you decide which one you need.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy