SQL Server 2017—Editions | Microsoft
Skip to main content

SQL Server 2017 Editions

Available SQL Server 2017 editions

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

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.

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.

Download the datasheet

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.

Express

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

Download the datasheet

Express

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

Developer

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

Download the datasheet

Developer

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

Compare SQL Server 2017 editions

View the comprehensive feature comparison of SQL Server 2017 editions for feature details and limitations.

Feature availability
  • Feature not supported Not supported   
  • Feature supported Fully supported   

Features

Scaling feature comparison by SQL Server edition
Features SQL Server 2017 Enterprise SQL Server 2017 Standard SQL Server 2017 ExpressSQL Server 2017 Developer
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-optimized data per databaseOperating system max32 GB352 MBOperating system max
Maximum database size524 PB524 PB10 GB524 PB
Production use rightsFeature included in SQL Server 2017 Enterprise editionFeature included in SQL Server 2017 Standard editionFeature included in SQL Server 2017 Express editionFeature not included in SQL Server 2017 Developer edition
Unlimited virtualization, a software assurance benefitFeature included in SQL Server 2017 Enterprise editionFeature not included in SQL Server 2017 Standard editionFeature not included in SQL Server 2017 Express editionFeature not included in SQL Server 2017 Developer edition
Programmability feature comparison by SQL Server edition
Features SQL Server 2017 Enterprise SQL Server 2017 Standard SQL Server 2017 ExpressSQL Server 2017 Developer
Programmability and developer tools: T-SQL, SQL CLR, Service Broker, JSON, XML, graph data supportFeature included in SQL Server 2017 Enterprise editionFeature included in SQL Server 2017 Standard editionFeature included in SQL Server 2017 Express editionFeature included in SQL Server 2017 Developer edition
OLTP performance feature comparison by SQL Server edition
Features SQL Server 2017 Enterprise SQL Server 2017 Standard SQL Server 2017 ExpressSQL Server 2017 Developer
Advanced OLTP: in-memory OLTP, operational analytics[1]Feature included in SQL Server 2017 Enterprise editionFeature included in SQL Server 2017 Standard editionFeature included in SQL Server 2017 Express editionFeature included in SQL Server 2017 Developer edition
Manageability: Management Studio, policy-based managementFeature included in SQL Server 2017 Enterprise editionFeature included in SQL Server 2017 Standard editionFeature included in SQL Server Express editionFeature included in SQL Server 2017 Developer edition
Basic high availability: two-node single database failover, non-readable secondaryFeature included in SQL Server 2017 Enterprise editionFeature included in SQL Server 2017 Standard editionFeature not included in SQL Server 2017 Express editionFeature included in SQL Server 2017 Developer edition
Advanced high availability: Always On Availability Groups, multi-database failover, readable secondaries Feature included in SQL Server 2017 Enterprise editionFeature not included in SQL Server 2017 Standard editionFeature not included in SQL Server 2017 Express editionFeature included in SQL Server 2017 Developer edition
Security feature comparison by SQL Server edition
Features SQL Server 2017 Enterprise SQL Server 2017 Standard SQL Server 2017 ExpressSQL Server 2017 Developer
Advanced security: Always Encrypted Row-level security, data masking Feature included in SQL Server 2017 Enterprise editionFeature included in SQL Server 2017 Standard editionFeature included in SQL Server 2017 Express editionFeature included in SQL Server 2017 Developer edition
Compliance reporting with SQL Server auditFeature included in SQL Server 2017 Enterprise editionFeature included in SQL Server 2017 Standard editionFeature included in SQL Server 2017 Express editionFeature included in SQL Server 2017 Developer edition
Transparent data encryptionFeature included in SQL Server 2017 Enterprise editionFeature not included in SQL Server 2017 Standard editionFeature not included in SQL Server 2017 Express editionFeature included in SQL Server 2017 Developer edition
Data integration feature comparison by SQL Server edition
Features SQL Server 2017 Enterprise SQL Server 2017 Standard SQL Server 2017 ExpressSQL Server 2017 Developer
Advanced data integration: fuzzy grouping and look upsFeature included in SQL Server 2017 Enterprise editionFeature not included in SQL Server 2017 Standard editionFeature not included in SQL Server 2017 Express editionFeature included in SQL Server 2017 Developer edition
Data warehousing feature comparison by SQL Server edition
Features SQL Server 2017 Enterprise SQL Server 2017 Standard SQL Server 2017 ExpressSQL Server 2017 Developer
Data marts and data warehousing: partitioning, data compression, change data capture, database snapshot Feature included in SQL Server 2017 Enterprise editionFeature included in SQL Server 2017 Standard editionFeature included in SQL Server 2017 Express editionFeature included in SQL Server 2017 Developer edition
In-memory columnstore[1]Feature included in SQL Server 2017 Enterprise editionFeature included in SQL Server 2017 Standard editionFeature included in SQL Server 2017 Express editionFeature included in SQL Server 2017 Developer edition
Adaptive Query Processing[4]Feature included in SQL Server 2017 Enterprise editionFeature not included in SQL Server 2017 Standard editionFeature not included in SQL Server 2017 Express editionFeature included in SQL Server 2017 Developer edition
PolyBase[2],[3]Feature included in SQL Server 2017 Enterprise editionFeature included in SQL Server 2017 Standard editionFeature included in SQL Server 2017 Express editionFeature included in SQL Server 2017 Developer edition
Enterprise data management: Master Data Services, Data Quality Services[3]Feature included in SQL Server 2017 Enterprise editionFeature not included in SQL Server 2017 Standard editionFeature not included in SQL Server 2017 Express editionFeature included in SQL Server 2017 Developer edition
Business intelligence feature comparison by SQL Server edition
Features SQL Server 2017 Enterprise SQL Server 2017 Standard SQL Server 2017 ExpressSQL Server 2017 Developer
Maximum memory utilized per instance of Analysis Services[3]Operating system max

Tabular: 16 GB

MOLAP: 64 GB 		Feature not included in SQL Server 2017 Express editionFeature not included in SQL Server 2017 Developer edition
Maximum memory utilized per instance of Reporting Services[3]Operating system max64 GBExpress with Advanced Services: 4 GBFeature not included in SQL Server 2017 Developer edition
Basic reporting and analytics[3]Feature included in SQL Server 2017 Enterprise editionFeature included in SQL Server 2017 Standard editionFeature included in SQL Server 2017 Express editionFeature included in SQL Server 2017 Developer edition
Basic data integration: SQL Server Integration Services, built-in connectorsFeature included in SQL Server 2017 Enterprise editionFeature included in SQL Server 2017 Standard editionFeature not included in SQL Server 2017 Express editionFeature included in SQL Server 2017 Developer edition
Basic corporate business intelligence: basic multi-dimensional models, basic tabular model, in-memory storage mode[3]Feature included in SQL Server 2017 Enterprise editionFeature included in SQL Server 2017 Standard editionFeature not included in SQL Server 2017 Express editionFeature included in SQL Server 2017 Developer edition
Mobile reports and KPIs[3]Feature included in SQL Server 2017 Enterprise editionFeature not included in SQL Server 2017 Standard editionFeature not included in SQL Server 2017 Express editionFeature included in SQL Server 2017 Developer edition
Advanced corporate business intelligence: advanced multi-dimensional models, advanced tabular model, DirectQuery storage mode, advanced data mining[3]Feature included in SQL Server 2017 Enterprise editionFeature not included in SQL Server 2017 Standard editionFeature not included in SQL Server 2017 Express editionFeature included in SQL Server 2017 Developer edition
Access to Power BI Report Server, a software assurance benefitFeature included in SQL Server 2017 Enterprise editionFeature not included in SQL Server 2017 Standard editionFeature not included in SQL Server 2017 Express editionFeature not included in SQL Server 2017 Developer edition
Advanced analytics feature comparison by SQL Server edition
Features SQL Server 2017 Enterprise SQL Server 2017 Standard SQL Server 2017 ExpressSQL Server 2017 Developer
Basic Machine Learning integration: connectivity to open source Python and R, limited parallelism[3]Feature included in SQL Server 2017 Enterprise editionFeature included in SQL Server 2017 Standard editionFeature included in SQL Server 2017 Express editionFeature included in SQL Server 2017 Developer edition
Advanced Machine Learning integration: full parallelism of R and Python analytics and the ability to run on GPUs[3]Feature included in SQL Server 2017 Enterprise editionFeature not included in SQL Server 2017 Standard editionFeature not included in SQL Server 2017 Express editionFeature included in SQL Server 2017 Developer edition
Machine Learning for Hadoop/Spark and Machine Learning for Linux, a software assurance benefit Feature included in SQL Server 2017 Enterprise editionFeature not included in SQL Server 2017 Standard editionFeature not included in SQL Server 2017 Express editionFeature not included in SQL Server 2017 Developer edition
Hybrid cloud feature comparison by SQL Server edition
Features SQL Server 2017 Enterprise SQL Server 2017 Standard SQL Server 2017 ExpressSQL Server 2017 Developer
Stretch Database[3]Feature included in SQL Server 2017 Enterprise editionFeature not included in SQL Server 2017 Standard editionFeature not included in SQL Server 2017 Express editionFeature not included in SQL Server 2017 Developer edition
Features SQL Server 2017 Enterprise SQL Server 2017 Standard SQL Server 2017 ExpressSQL Server 2017 Developer

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

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

[3] Certain features including SQL Server Reporting Services, SQL Server Analysis Services, Machine Learning Services, PolyBase, and Stretch Database are not available in SQL Server 2017 on Linux.

[4] Interleaved Execution is available in all editions.

Other SQL Server 2017 editions

SQL Server Web edition

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

Learn more

SQL Server Compact edition

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

Download the app

Back To Top