Run SQL Server on your favorite platform
It's all about choice. Now, you can get SQL Server 2017's industry-leading performance and security on Windows, Linux, and Docker containers.
Try now
Watch now

Run SQL Server on your favorite platform

It's all about choice. Now, you can get SQL Server 2017's industry-leading performance and security on Windows, Linux, and Docker containers.

SQL Server 2017 Editions

Available SQL Server 2017 editions

Compare SQL Server 2017 editions

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

Feature availability

Not supported
Fully supported

Features

Scale

Scaling feature comparison by SQL Server edition
Features	SQL Server 2017 Enterprise	SQL Server 2017 Standard	SQL Server 2017 Express	SQL Server 2017 Developer
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
Unlimited virtualization, a software assurance benefit

Programmability

Programmability feature comparison by SQL Server edition
Features	SQL Server 2017 Enterprise	SQL Server 2017 Standard	SQL Server 2017 Express	SQL Server 2017 Developer
Programmability and developer tools: T-SQL, SQL CLR, Service Broker, JSON, XML, graph data support

OLTP performance

OLTP performance feature comparison by SQL Server edition
Features	SQL Server 2017 Enterprise	SQL Server 2017 Standard	SQL Server 2017 Express	SQL Server 2017 Developer
Advanced OLTP: in-memory OLTP, operational analytics^[1]
Manageability: Management Studio, policy-based management
Basic high availability: two-node single database failover, non-readable secondary
Advanced high availability: Always On Availability Groups, multi-database failover, readable secondaries

Security

Security feature comparison by SQL Server edition
Features	SQL Server 2017 Enterprise	SQL Server 2017 Standard	SQL Server 2017 Express	SQL Server 2017 Developer
Advanced security: Always Encrypted Row-level security, data masking
Compliance reporting with SQL Server audit
Transparent data encryption

Data integration

Data integration feature comparison by SQL Server edition
Features	SQL Server 2017 Enterprise	SQL Server 2017 Standard	SQL Server 2017 Express	SQL Server 2017 Developer
Advanced data integration: fuzzy grouping and look ups

Data warehousing

Data warehousing feature comparison by SQL Server edition
Features	SQL Server 2017 Enterprise	SQL Server 2017 Standard	SQL Server 2017 Express	SQL Server 2017 Developer
Data marts and data warehousing: partitioning, data compression, change data capture, database snapshot
In-memory columnstore^[1]
Adaptive Query Processing^[4]
PolyBase^[2]^,^[3]
Enterprise data management: Master Data Services, Data Quality Services^[3]

Business intelligence

Business intelligence feature comparison by SQL Server edition
Features	SQL Server 2017 Enterprise	SQL Server 2017 Standard	SQL Server 2017 Express
Maximum memory utilized per instance of Analysis Services^[3]	Operating system max	Tabular: 16 GB MOLAP: 64 GB
Maximum memory utilized per instance of Reporting Services^[3]	Operating system max	64 GB	Express with Advanced Services: 4 GB
Basic reporting and analytics^[3]
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^[3]
Mobile reports and KPIs^[3]
Advanced corporate business intelligence: advanced multi-dimensional models, advanced tabular model, DirectQuery storage mode, advanced data mining^[3]
Access to Power BI Report Server, a software assurance benefit

Advanced analytics

Advanced analytics feature comparison by SQL Server edition
Features	SQL Server 2017 Enterprise	SQL Server 2017 Standard	SQL Server 2017 Express	SQL Server 2017 Developer
Basic Machine Learning integration: connectivity to open source Python and R, limited parallelism^[3]
Advanced Machine Learning integration: full parallelism of R and Python analytics and the ability to run on GPUs^[3]
Machine Learning for Hadoop/Spark and Machine Learning for Linux, a software assurance benefit

Hybrid cloud

Hybrid cloud feature comparison by SQL Server edition
Features	SQL Server 2017 Enterprise	SQL Server 2017 Standard	SQL Server 2017 Express	SQL Server 2017 Developer
Stretch Database^[3]


Features	SQL Server 2017 Enterprise	SQL Server 2017 Standard	SQL Server 2017 Express	SQL 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.