SQL Server 2016 SP1 editions

Learn about and compare the editions and features of SQL Server 2016 SP1 to find the one that’s right for your organization.

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 download

Compare SQL Server 2016 SP1 editions1
  • Includes consistent programming interface from SQL Server 2016 SP1.

FeaturesSQL Server 2016 SP1 Enterprise SQL Server 2016 SP1 StandardSQL Server 2016 SP1 ExpressSQL Server 2016 SP1 Developer

Scale

Maximum number of coresUnlimited24 cores4 coresUnlimited
Memory: Maximum buffer pool size per instanceOperating system max128 GB1410 MBOperating system max
Memory: Maximum Columnstore segment cache per instanceOperating system max32 GB352 MBOperating system max
Memory: Maximum memory-optimized data per databaseOperating system max32 GB352 MBOperating system max
Maximum database size524 PB524 PB10 GB524 PB
Production use rightsdot-icondot-icondot-icon

Programmability

Programmability and developer tools: T-SQL, SQL CLR, Service Broker, JSON, XML, database snapshot

dot-icondot-icondot-icondot-icon

OLTP performance

Advanced OLTP: in-memory OLTP, operational analytics2

dot-icondot-icondot-icondot-icon

Manageability: Management Studio, policy-based management

dot-icondot-icondot-icondot-icon

Basic high availability: two-node single database failover, non-readable secondary

dot-icondot-icondot-icon

Advanced high availability: AlwaysOn availability groups, multi-database failover, readable secondaries

dot-icondot-icon

Enterprise data management: Master Data Services, Data Quality Services

dot-icondot-icon

Security

Advanced Security: Always Encrypted, row-level security, data masking, fine-grained auditing

dot-icondot-icondot-icondot-icon
Transparent data encryptiondot-icondot-icon
Compliance reporting with SQL Server auditdot-icondot-icon

Data integration

Advanced data integration: fuzzy grouping and look ups

dot-icondot-icon

Data warehousing

Data marts and data warehousing: partitioning, data compression, change data capture

dot-icondot-icondot-icondot-icon
In-memory columnstore2dot-icondot-icondot-icondot-icon
PolyBase3dot-icondot-icondot-icondot-icon

Business intelligence

Maximum memory utilized per instance of Analysis ServicesOperating system max
  • Tabular: 16 GB
  • MOLAP: 64 GB
Maximum memory utilized per instance of Reporting ServicesOperating system max64 GBExpress with Advanced Services: 4 GB
Basic reporting and analyticsdot-icondot-icondot-icondot-icon

Basic data integration: SQL Server Integration Services, built-in connectors

dot-icondot-icondot-icon

Basic corporate business intelligence: basic multi-dimensional models, basic tabular model, in-memory storage mode

dot-icondot-icondot-icon
Mobile reports and KPIsdot-icondot-icon

Advanced corporate business intelligence: advanced multi-dimensional models, advanced tabular model, DirectQuery storage mode, advanced data mining

dot-icondot-icon

Advanced analytics

Basic R integration: connectivity to R open, limited parallelism

dot-icondot-icondot-icondot-icon

Advanced R integration: full parallelism ScaleR

dot-icondot-icon

Hybrid cloud

Stretch Databasedot-icondot-icondot-icondot-icon
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
dot-icon
SQL Server 2016 SP1 Standard
dot-icon
SQL Server 2016 SP1 Express
dot-icon
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
dot-icon
SQL Server 2016 SP1 Standard
dot-icon
SQL Server 2016 SP1 Express
dot-icon
SQL Server 2016 SP1 Developer
dot-icon
Features

OLTP performance

Advanced OLTP: in-memory OLTP, operational analytics2

SQL Server 2016 SP1 Enterprise
dot-icon
SQL Server 2016 SP1 Standard
dot-icon
SQL Server 2016 SP1 Express
dot-icon
SQL Server 2016 SP1 Developer
dot-icon
Features

Manageability: Management Studio, policy-based management

SQL Server 2016 SP1 Enterprise
dot-icon
SQL Server 2016 SP1 Standard
dot-icon
SQL Server 2016 SP1 Express
dot-icon
SQL Server 2016 SP1 Developer
dot-icon
Features

Basic high availability: two-node single database failover, non-readable secondary

SQL Server 2016 SP1 Enterprise
dot-icon
SQL Server 2016 SP1 Standard
dot-icon
SQL Server 2016 SP1 Express
SQL Server 2016 SP1 Developer
dot-icon
Features

Advanced high availability: AlwaysOn availability groups, multi-database failover, readable secondaries

SQL Server 2016 SP1 Enterprise
dot-icon
SQL Server 2016 SP1 Standard
SQL Server 2016 SP1 Express
SQL Server 2016 SP1 Developer
dot-icon
Features

Enterprise data management: Master Data Services, Data Quality Services

SQL Server 2016 SP1 Enterprise
dot-icon
SQL Server 2016 SP1 Standard
SQL Server 2016 SP1 Express
SQL Server 2016 SP1 Developer
dot-icon
Features

Security

Advanced Security: Always Encrypted, row-level security, data masking, fine-grained auditing

SQL Server 2016 SP1 Enterprise
dot-icon
SQL Server 2016 SP1 Standard
dot-icon
SQL Server 2016 SP1 Express
dot-icon
SQL Server 2016 SP1 Developer
dot-icon
Features
Transparent data encryption
SQL Server 2016 SP1 Enterprise
dot-icon
SQL Server 2016 SP1 Standard
SQL Server 2016 SP1 Express
SQL Server 2016 SP1 Developer
dot-icon
Features
Compliance reporting with SQL Server audit
SQL Server 2016 SP1 Enterprise
dot-icon
SQL Server 2016 SP1 Standard
SQL Server 2016 SP1 Express
SQL Server 2016 SP1 Developer
dot-icon
Features

Data integration

Advanced data integration: fuzzy grouping and look ups

SQL Server 2016 SP1 Enterprise
dot-icon
SQL Server 2016 SP1 Standard
SQL Server 2016 SP1 Express
SQL Server 2016 SP1 Developer
dot-icon
Features

Data warehousing

Data marts and data warehousing: partitioning, data compression, change data capture

SQL Server 2016 SP1 Enterprise
dot-icon
SQL Server 2016 SP1 Standard
dot-icon
SQL Server 2016 SP1 Express
dot-icon
SQL Server 2016 SP1 Developer
dot-icon
Features
In-memory columnstore2
SQL Server 2016 SP1 Enterprise
dot-icon
SQL Server 2016 SP1 Standard
dot-icon
SQL Server 2016 SP1 Express
dot-icon
SQL Server 2016 SP1 Developer
dot-icon
Features
PolyBase3
SQL Server 2016 SP1 Enterprise
dot-icon
SQL Server 2016 SP1 Standard
dot-icon
SQL Server 2016 SP1 Express
dot-icon
SQL Server 2016 SP1 Developer
dot-icon
Features

Business intelligence

Maximum memory utilized per instance of Analysis Services
SQL Server 2016 SP1 Enterprise
Operating system max
SQL Server 2016 SP1 Standard
  • Tabular: 16 GB
  • MOLAP: 64 GB
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
dot-icon
SQL Server 2016 SP1 Standard
dot-icon
SQL Server 2016 SP1 Express
dot-icon
SQL Server 2016 SP1 Developer
dot-icon
Features

Basic data integration: SQL Server Integration Services, built-in connectors

SQL Server 2016 SP1 Enterprise
dot-icon
SQL Server 2016 SP1 Standard
dot-icon
SQL Server 2016 SP1 Express
SQL Server 2016 SP1 Developer
dot-icon
Features

Basic corporate business intelligence: basic multi-dimensional models, basic tabular model, in-memory storage mode

SQL Server 2016 SP1 Enterprise
dot-icon
SQL Server 2016 SP1 Standard
dot-icon
SQL Server 2016 SP1 Express
SQL Server 2016 SP1 Developer
dot-icon
Features
Mobile reports and KPIs
SQL Server 2016 SP1 Enterprise
dot-icon
SQL Server 2016 SP1 Standard
SQL Server 2016 SP1 Express
SQL Server 2016 SP1 Developer
dot-icon
Features

Advanced corporate business intelligence: advanced multi-dimensional models, advanced tabular model, DirectQuery storage mode, advanced data mining

SQL Server 2016 SP1 Enterprise
dot-icon
SQL Server 2016 SP1 Standard
SQL Server 2016 SP1 Express
SQL Server 2016 SP1 Developer
dot-icon
Features

Advanced analytics

Basic R integration: connectivity to R open, limited parallelism

SQL Server 2016 SP1 Enterprise
dot-icon
SQL Server 2016 SP1 Standard
dot-icon
SQL Server 2016 SP1 Express
dot-icon
SQL Server 2016 SP1 Developer
dot-icon
Features

Advanced R integration: full parallelism ScaleR

SQL Server 2016 SP1 Enterprise
dot-icon
SQL Server 2016 SP1 Standard
SQL Server 2016 SP1 Express
SQL Server 2016 SP1 Developer
dot-icon
Features

Hybrid cloud

Stretch Database
SQL Server 2016 SP1 Enterprise
dot-icon
SQL Server 2016 SP1 Standard
dot-icon
SQL Server 2016 SP1 Express
dot-icon
SQL Server 2016 SP1 Developer
dot-icon
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

Back To Top