Skip to main content

Available SQL Server 2016 SP1 editions

SQL Server 2016 Enterprise edition
Enterprise

Access mission-critical capabilities to achieve unparalleled scale, security, high availability, and leading performance for your Tier 1 database, business intelligence, and advanced analytics workloads.

Download the datasheet
SQL Server 2016 Enterprise edition
Enterprise

Access mission-critical capabilities to achieve unparalleled scale, security, high availability, and leading performance for your Tier 1 database, business intelligence, and advanced analytics workloads.

SQL Server 2016 Standard edition
Standard

Find rich programming capabilities, security innovations, and fast performance for mid-tier applications and data marts. Easily upgrade to the Enterprise edition without having to change any code.

Get SQL Server SP1 Standard edition
SQL Server 2016 Standard edition
Standard

Find rich programming capabilities, security innovations, and fast performance for mid-tier applications and data marts. Easily upgrade to the Enterprise edition without having to change any code.

SQL Server 2016 Express edition
Express

Build small, data-driven web and mobile applications up to 10 GB in size with this entry-level database. Available for free.

Download SQL Server 2016 SP1 Express
SQL Server 2016 Express edition
Express

Build small, data-driven web and mobile applications up to 10 GB in size with this entry-level database. Available for free.

SQL Server 2016 Developer edition
Developer

Build, test, and demonstrate applications in a non-production environment with this full-featured edition of SQL Server 2016 SP1.

Download now
SQL Server 2016 Developer edition
Developer

Build, test, and demonstrate applications in a non-production environment with this full-featured edition of SQL Server 2016 SP1.

SQL Server 2016 SP1 edition comparison

Includes consistent programming interface from SQL Server 2016 SP1. View the comprehensive feature comparison of SQL Server 2016 SP1 editions for feature details and limitations.

FeaturesSQL Server 2016 SP1 EnterpriseSQL Server 2016 SP1     StandardSQL Server 2016 SP1      ExpressSQL Server 2016 SP1 Developer
Scale
Maximum number of cores Unlimited24 cores4 coresUnlimited
Memory: Maximum buffer pool size per instanceOperating system max128 GB1410 MB Operating system max
Memory: Maximum Columnstore segment cache per instanceOperating system max32 GB352 MBOperating system max
Memory: Maximum memory-optimised 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 analytics1dot-icondot-icondot-icondot-icon
Manageability: Management Studio, policy-based managementdot-icondot-icondot-icondot-icon
Basic high availability: two-node single database failover, non-readable secondarydot-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 Servicesdot-icondot-icon
Security
Advanced Security: Always Encrypted, row-level security, data masking, fine-grained auditingdot-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 upsdot-icondot-icon
Data warehousing
Data marts and data warehousing: partitioning, data compression, change data capture dot-icondot-icondot-icondot-icon
In-memory columnstore1dot-icondot-icondot-icondot-icon
PolyBase2dot-icondot-icondot-icondot-icon
Business intelligence
Maximum memory utilised per instance of Analysis ServicesOperating system max
  • Tabular: 16 GB
  • MOLAP: 64 GB
Maximum memory utilised 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 connectorsdot-icondot-icondot-icon
Basic corporate business intelligence: basic multi-dimensional models, basic tabular model, in-memory storage modedot-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 miningdot-icondot-icon
Advanced analytics
Basic R integration: connectivity to R open, limited parallelismdot-icondot-icondot-icondot-icon
Advanced R integration: full parallelism ScaleRdot-icondot-icon
Hybrid cloud
Stretch Databasedot-icondot-icondot-icondot-icon

1In-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.

2Scaling out queries using PolyBase requires using SQL Server SP1 Enterprise edition as a head node.

Other SQL Server 2016 SP1 editions

Web

Use a secured, cost-effective, highly scalable data platform for public websites—available to third-party hosting service providers only.

Learn more

Compact

Build ASP.NET websites and Windows desktop applications with a free, embedded database app.

Download the app

Back To Top