SQL Server 2016 edition comparison

Microsoft has changed a lot of policies with the release of SQL Server 2016. In this post we will get a comparison between SQL Server express, developer, standard and enterprise editions. By the way if you are not aware, SQL Server developer edition is now free for all Visual Studio Dev Essentials members. So we can get our hands-on on enterprise features free of cost.

Specifications Express Developer Standard Enterprise
Price Free Free Link Link
Production use rights Yes No Yes Yes
Cores 4 Unlimited 24 Unlimited
Memory/RAM 1410 MB OS Max 128 GB OS Max
Columnstore segment cache per instance 352 MB OS Max 32 GB OS Max
Memory-optimized data per database 352 MB OS Max 32 GB OS Max
Database size 10 GB 524 PB 524 PB 524 PB
in-memory OLTP Yes Yes Yes Yes
Policy-based management Yes Yes Yes Yes
Two-node single database failover, non-readable secondary No Yes Yes Yes
AlwaysOn availability groups, multi-database failover, readable secondaries No Yes N/A Yes
Master Data Services, Data Quality Services N/A Yes N/A Yes
Always Encrypted, row-level security, data masking, fine-grained auditing Yes Yes Yes Yes
Transparent data encryption (TDE) N/A Yes N/A Yes
fuzzy grouping and look ups N/A Yes N/A Yes
partitioning, data compression, change data capture Yes Yes Yes Yes
In-memory columnstore Yes Yes Yes Yes
PolyBase Yes Yes Yes Yes
Maximum memory utilized per instance of Analysis Services N/A N/A Tabular: 16 GB MOLAP: 64 GB OS max
Maximum memory utilized per instance of Reporting Services 4 GB  N/A 64 GB OS max
Basic reporting and analytics Yes Yes Yes Yes
SQL Server Integration Services, built-in connectors N/A Yes Yes Yes
basic multi-dimensional models, basic tabular model, in-memory storage mode N/A Yes Yes Yes
Mobile reports and KPIs N/A Yes N/A Yes
Advanced multi-dimensional models, advanced tabular model, DirectQuery storage mode, advanced data mining N/A Yes N/A Yes
R integration Yes Yes Yes Yes
Stretch Database Yes Yes Yes Yes

Prasad Sahoo

Prasad Sahoo, is an enthusiast of Microsoft technologies in general and a passionate database professional, mainly focusing on SQL Server performance tuning and business intelligence. He has contributed a long time of his career working on SQL Server and other RDBMS. If he is not busy with SQL stuff then he must be watching some Hollywood movies.

Leave a Reply

%d bloggers like this: