Editions overview
Enterprise
Comprehensive, mission-critical in-memory performance with unparalleled security, mission critical high availability, an end-to-end enterprise business intelligence solution with mobile BI built in, in-database advanced analytics at scale, and unlimited virtualization with software assurance. Enterprise edition provides the highest scale and performance for Tier-1 workloads.
Learn more
Standard
Find rich programming capabilities, security innovations, and fast performance for applications and data marts. Easily upgrade to the Enterprise edition without having to change any code.
Learn more
Express
Deploy small databases in production environments with this free, entry-level database that’s ideal for building small, data-driven applications up to 10 GB of disk size.
Learn moreDownload
Developer
Build, test, and demonstrate applications in a non-production environment with this free, full-featured set of SQL Server 2016 SP1 Enterprise edition software.
Learn moreSign up for Visual Studio Dev Essentials and downloadCompare SQL Server 2016 SP1 editions1- Includes consistent programming interface from SQL Server 2016 SP1.
| Features | SQL Server 2016 SP1 Enterprise | SQL Server 2016 SP1 Standard | SQL Server 2016 SP1 Express | SQL Server 2016 SP1 Developer | |
|---|---|---|---|---|---|
Scale | Maximum number of cores | Unlimited | 24 cores | 4 cores | Unlimited |
| Memory: Maximum buffer pool size per instance | Operating system max | 128 GB | 1410 MB | Operating system max | |
| Memory: Maximum Columnstore segment cache per instance | Operating system max | 32 GB | 352 MB | Operating system max | |
| Memory: Maximum memory-optimized data per database | Operating system max | 32 GB | 352 MB | Operating system max | |
| Maximum database size | 524 PB | 524 PB | 10 GB | 524 PB | |
| Production use rights |  | | | ||
Programmability | Programmability and developer tools: T-SQL, SQL CLR, Service Broker, JSON, XML, database snapshot | | | | |
OLTP performance | Advanced OLTP: in-memory OLTP, operational analytics2 | | | | |
Manageability: Management Studio, policy-based management | | | | | |
Basic high availability: two-node single database failover, non-readable secondary | | | | ||
Advanced high availability: AlwaysOn availability groups, multi-database failover, readable secondaries | | | |||
Enterprise data management: Master Data Services, Data Quality Services | | | |||
Security | Advanced Security: Always Encrypted, row-level security, data masking, fine-grained auditing | | | | |
| Transparent data encryption | | | |||
| Compliance reporting with SQL Server audit | | | |||
Data integration | Advanced data integration: fuzzy grouping and look ups | | | ||
Data warehousing | Data marts and data warehousing: partitioning, data compression, change data capture | | | | |
| In-memory columnstore2 | | | | | |
| PolyBase3 | | | | | |
Business intelligence | Maximum memory utilized per instance of Analysis Services | Operating system max |
| ||
| Maximum memory utilized per instance of Reporting Services | Operating system max | 64 GB | Express with Advanced Services: 4 GB | ||
| Basic reporting and analytics | | | | | |
Basic data integration: SQL Server Integration Services, built-in connectors | | | | ||
Basic corporate business intelligence: basic multi-dimensional models, basic tabular model, in-memory storage mode | | | | ||
| Mobile reports and KPIs | | | |||
Advanced corporate business intelligence: advanced multi-dimensional models, advanced tabular model, DirectQuery storage mode, advanced data mining | | | |||
Advanced analytics | Basic R integration: connectivity to R open, limited parallelism | | | | |
Advanced R integration: full parallelism ScaleR | | | |||
Hybrid cloud | Stretch Database | | | | |
Features Scale | Maximum number of cores | SQL Server 2016 SP1 Enterprise
Unlimited | SQL Server 2016 SP1 Standard 24 cores | SQL Server 2016 SP1 Express 4 cores | SQL Server 2016 SP1 Developer Unlimited |
Features | Memory: Maximum buffer pool size per instance | SQL Server 2016 SP1 Enterprise
Operating system max | SQL Server 2016 SP1 Standard 128 GB | SQL Server 2016 SP1 Express 1410 MB | SQL Server 2016 SP1 Developer Operating system max |
Features | Memory: Maximum Columnstore segment cache per instance | SQL Server 2016 SP1 Enterprise
Operating system max | SQL Server 2016 SP1 Standard 32 GB | SQL Server 2016 SP1 Express 352 MB | SQL Server 2016 SP1 Developer Operating system max |
Features | Memory: Maximum memory-optimized data per database | SQL Server 2016 SP1 Enterprise
Operating system max | SQL Server 2016 SP1 Standard 32 GB | SQL Server 2016 SP1 Express 352 MB | SQL Server 2016 SP1 Developer Operating system max |
Features | Maximum database size | SQL Server 2016 SP1 Enterprise
524 PB | SQL Server 2016 SP1 Standard 524 PB | SQL Server 2016 SP1 Express 10 GB | SQL Server 2016 SP1 Developer 524 PB |
Features | Production use rights | SQL Server 2016 SP1 Enterprise
| SQL Server 2016 SP1 Standard | SQL Server 2016 SP1 Express | SQL Server 2016 SP1 Developer |
Features Programmability | Programmability and developer tools: T-SQL, SQL CLR, Service Broker, JSON, XML, database snapshot | SQL Server 2016 SP1 Enterprise
| SQL Server 2016 SP1 Standard | SQL Server 2016 SP1 Express | SQL Server 2016 SP1 Developer |
Features OLTP performance | Advanced OLTP: in-memory OLTP, operational analytics2 | SQL Server 2016 SP1 Enterprise
| SQL Server 2016 SP1 Standard | SQL Server 2016 SP1 Express | SQL Server 2016 SP1 Developer |
Features | Manageability: Management Studio, policy-based management | SQL Server 2016 SP1 Enterprise
| SQL Server 2016 SP1 Standard | SQL Server 2016 SP1 Express | SQL Server 2016 SP1 Developer |
Features | Basic high availability: two-node single database failover, non-readable secondary | SQL Server 2016 SP1 Enterprise
| SQL Server 2016 SP1 Standard | SQL Server 2016 SP1 Express | SQL Server 2016 SP1 Developer |
Features | Advanced high availability: AlwaysOn availability groups, multi-database failover, readable secondaries | SQL Server 2016 SP1 Enterprise
| SQL Server 2016 SP1 Standard | SQL Server 2016 SP1 Express | SQL Server 2016 SP1 Developer |
Features | Enterprise data management: Master Data Services, Data Quality Services | SQL Server 2016 SP1 Enterprise
| SQL Server 2016 SP1 Standard | SQL Server 2016 SP1 Express | SQL Server 2016 SP1 Developer |
Features Security | Advanced Security: Always Encrypted, row-level security, data masking, fine-grained auditing | SQL Server 2016 SP1 Enterprise
| SQL Server 2016 SP1 Standard | SQL Server 2016 SP1 Express | SQL Server 2016 SP1 Developer |
Features | Transparent data encryption | SQL Server 2016 SP1 Enterprise
| SQL Server 2016 SP1 Standard | SQL Server 2016 SP1 Express | SQL Server 2016 SP1 Developer |
Features | Compliance reporting with SQL Server audit | SQL Server 2016 SP1 Enterprise
| SQL Server 2016 SP1 Standard | SQL Server 2016 SP1 Express | SQL Server 2016 SP1 Developer |
Features Data integration | Advanced data integration: fuzzy grouping and look ups | SQL Server 2016 SP1 Enterprise
| SQL Server 2016 SP1 Standard | SQL Server 2016 SP1 Express | SQL Server 2016 SP1 Developer |
Features Data warehousing | Data marts and data warehousing: partitioning, data compression, change data capture | SQL Server 2016 SP1 Enterprise
| SQL Server 2016 SP1 Standard | SQL Server 2016 SP1 Express | SQL Server 2016 SP1 Developer |
Features | In-memory columnstore2 | SQL Server 2016 SP1 Enterprise
| SQL Server 2016 SP1 Standard | SQL Server 2016 SP1 Express | SQL Server 2016 SP1 Developer |
Features | PolyBase3 | SQL Server 2016 SP1 Enterprise
| SQL Server 2016 SP1 Standard | SQL Server 2016 SP1 Express | SQL Server 2016 SP1 Developer |
Features Business intelligence | Maximum memory utilized per instance of Analysis Services | SQL Server 2016 SP1 Enterprise
Operating system max | SQL Server 2016 SP1 Standard
| SQL Server 2016 SP1 Express | SQL Server 2016 SP1 Developer |
Features | Maximum memory utilized per instance of Reporting Services | SQL Server 2016 SP1 Enterprise
Operating system max | SQL Server 2016 SP1 Standard 64 GB | SQL Server 2016 SP1 Express Express with Advanced Services: 4 GB | SQL Server 2016 SP1 Developer |
Features | Basic reporting and analytics | SQL Server 2016 SP1 Enterprise
| SQL Server 2016 SP1 Standard | SQL Server 2016 SP1 Express | SQL Server 2016 SP1 Developer |
Features | Basic data integration: SQL Server Integration Services, built-in connectors | SQL Server 2016 SP1 Enterprise
| SQL Server 2016 SP1 Standard | SQL Server 2016 SP1 Express | SQL Server 2016 SP1 Developer |
Features | Basic corporate business intelligence: basic multi-dimensional models, basic tabular model, in-memory storage mode | SQL Server 2016 SP1 Enterprise
| SQL Server 2016 SP1 Standard | SQL Server 2016 SP1 Express | SQL Server 2016 SP1 Developer |
Features | Mobile reports and KPIs | SQL Server 2016 SP1 Enterprise
| SQL Server 2016 SP1 Standard | SQL Server 2016 SP1 Express | SQL Server 2016 SP1 Developer |
Features | Advanced corporate business intelligence: advanced multi-dimensional models, advanced tabular model, DirectQuery storage mode, advanced data mining | SQL Server 2016 SP1 Enterprise
| SQL Server 2016 SP1 Standard | SQL Server 2016 SP1 Express | SQL Server 2016 SP1 Developer |
Features Advanced analytics | Basic R integration: connectivity to R open, limited parallelism | SQL Server 2016 SP1 Enterprise
| SQL Server 2016 SP1 Standard | SQL Server 2016 SP1 Express | SQL Server 2016 SP1 Developer |
Features | Advanced R integration: full parallelism ScaleR | SQL Server 2016 SP1 Enterprise
| SQL Server 2016 SP1 Standard | SQL Server 2016 SP1 Express | SQL Server 2016 SP1 Developer |
Features Hybrid cloud | Stretch Database | SQL Server 2016 SP1 Enterprise
| SQL Server 2016 SP1 Standard | SQL Server 2016 SP1 Express | SQL Server 2016 SP1 Developer |
Features | SQL Server 2016 SP1 Enterprise
| SQL Server 2016 SP1 Standard | SQL Server 2016 SP1 Express | SQL Server 2016 SP1 Developer | |
Features | SQL Server 2016 SP1 Enterprise
| SQL Server 2016 SP1 Standard | SQL Server 2016 SP1 Express | SQL Server 2016 SP1 Developer | |
Features | SQL Server 2016 SP1 Enterprise
| SQL Server 2016 SP1 Standard | SQL Server 2016 SP1 Express | SQL Server 2016 SP1 Developer | |
Features | SQL Server 2016 SP1 Enterprise
| SQL Server 2016 SP1 Standard | SQL Server 2016 SP1 Express | SQL Server 2016 SP1 Developer |
1View the comprehensive feature comparison of SQL Server 2016 SP1 editions for feature details and limitations.
2In-memory OLTP and in-memory columnstore are limited to the amount of memory specified by edition in the Scale Limits section. Columnstore and Real-time Operational Analytics are also limited to two degrees of parallelism (two cores/query) in SQL Server Standard edition and one degree of parallelism (one core/query) in SQL Server Web and Express editions.
3Scaling out queries using PolyBase requires using SQL Server SP1 Enterprise edition as a head node.
Other SQL Server 2016 SP1 editions
Compact
Free, embedded database app for building ASP.NET websites and Windows desktop applications.
Download the app
Web
Secured, cost effective, and highly scalable data platform for public websites—available to third-party hosting service providers only.
Learn more
