features sql server 2016 versus sql server 2016 express

Compression (Data since 2016SP1 and Backups a lot longer).Availability Groups (with some limitations, starting in SQL Server 2016).

Two node (single instance) Failover Cluster for High Availability (more on this tomorrow – including how we do that with many clients in the clouds).24 Cores (or 4 sockets, whichever is lower) – Up from 16 cores in SQL Server 2014.128GB RAM – up from 64GB in SQL Server 2012 and below.Here are just some of the things we get with SQL Server standard nowadays in SQL Server 2019: Let me phrase it this way – “Why not?” Sure there are some reasons to stay on Enterprise (See below), but many of the reasons we used to give without much thought aren’t good reasons anymore. And that’s without software assurance (which is a whole other topic for another post – navigating Software Assurance and licensing) On an 8 core server – that’s $40,000 reasons. Saving $10,000 for each 2 core pack is a good starter reason. Why Downgrade from Enterprise to Standard Edition in SQL Server? Some folks should be on the fast track to “downgrade” from SQL Server Enterprise to SQL Server Standard. Some folks need to stay on SQL Server enterprise. The answers here are not one size fits all. Tomorrow I’ll share the link to the webinar and talk a bit more about achieving HA with SQL Server standard in the cloud.

I’ll share the video from MSSQLTIPS here tomorrow when we have the link, and once I get the list of questions asked we didn’t get to – I’ll answer them here in a post tomorrow.įor now, a brief post where I’ll cover some things to think about, some reasons to consider downgrading to standard, some reasons to stay Enterprise. I just hosted a webinar today with SIOS Technologies and David Bermingham talking about that. I’ve lost track of the number of clients we’ve helped downgrade from SQL Server Enterprise to SQL Server Standard during our SQL Server Upgrades, take advantage of new features, and fairly dramatically reduce their costs. Lately, we’ve been finding more and more folks who can answer that probably not.

This blog post will help you figure out if you can make the move from SQL Server Enterprise Edition to SQL Server Standard. Do you need SQL Server Enterprise Edition? Maybe.

Features sql server 2016 versus sql server 2016 express