SQL Server 2017 on Windows and Linux | Microsoft

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

Unlimited virtualization, a software assurance benefit

Programmability

Programmability and developer tools: T-SQL, SQL CLR, Service Broker, JSON, XML, graph data support

OLTP performance

Advanced OLTP: in-memory OLTP, operational analytics[3]

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

Advanced security: Always Encrypted Row-level security, data masking

Compliance reporting with SQL Server audit

Transparent data encryption

Data integration

Advanced data integration: fuzzy grouping and look ups

Data warehousing

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

Adaptive Query Processing[6]

Enterprise data management: Master Data Services, Data Quality Services[5]

Business intelligence

Maximum memory utilized per instance of Analysis Services[5]

Operating system max

Tabular: 16 GB

MOLAP: 64 GB

Operating system max

Maximum memory utilized per instance of Reporting Services[5]

Operating system max

64 GB

Express with Advanced Services: 4 GB

Operating system max

Basic reporting and analytics[5]

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[5]

Mobile reports and KPIs[5]

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

Access to Power BI Report Server, a software assurance benefit

Advanced analytics

Basic Machine Learning integration: connectivity to open source Python and R, limited parallelism[5]

Advanced Machine Learning integration: full parallelism of R and Python analytics and the ability to run on GPUs[5]

Machine Learning for Hadoop/Spark and Machine Learning for Linux, a software assurance benefit

Hybrid cloud

Stretch Database[5]