SQLSvrStd 2017 SNGL OLP NL

SQLSvrStd 2017 SNGL OLP NL

Category:

Description

Compare SQL Server 2017 editions

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

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

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 Feature included in SQL Server 2017 Enterprise edition Feature included in SQL Server 2017 Standard edition Feature included in SQL Server 2017 Express edition Feature not included in SQL Server 2017 Developer edition
Unlimited virtualization, a software assurance benefit Feature included in SQL Server 2017 Enterprise edition Feature not included in SQL Server 2017 Standard edition Feature not included in SQL Server 2017 Express edition Feature 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 Express SQL Server 2017 Developer
Programmability and developer tools: T-SQL, SQL CLR, Service Broker, JSON, XML, graph data support Feature included in SQL Server 2017 Enterprise edition Feature included in SQL Server 2017 Standard edition Feature included in SQL Server 2017 Express edition Feature 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 Express SQL Server 2017 Developer
Advanced OLTP: in-memory OLTP, operational analytics[1] Feature included in SQL Server 2017 Enterprise edition Feature included in SQL Server 2017 Standard edition Feature included in SQL Server 2017 Express edition Feature included in SQL Server 2017 Developer edition
Manageability: Management Studio, policy-based management Feature included in SQL Server 2017 Enterprise edition Feature included in SQL Server 2017 Standard edition Feature included in SQL Server Express edition Feature included in SQL Server 2017 Developer edition
Basic high availability: two-node single database failover, non-readable secondary Feature included in SQL Server 2017 Enterprise edition Feature included in SQL Server 2017 Standard edition Feature not included in SQL Server 2017 Express edition Feature 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 edition Feature not included in SQL Server 2017 Standard edition Feature not included in SQL Server 2017 Express edition Feature 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 Express SQL Server 2017 Developer
Advanced security: Always Encrypted Row-level security, data masking Feature included in SQL Server 2017 Enterprise edition Feature included in SQL Server 2017 Standard edition Feature included in SQL Server 2017 Express edition Feature included in SQL Server 2017 Developer edition
Compliance reporting with SQL Server audit Feature included in SQL Server 2017 Enterprise edition Feature included in SQL Server 2017 Standard edition Feature included in SQL Server 2017 Express edition Feature included in SQL Server 2017 Developer edition
Transparent data encryption Feature included in SQL Server 2017 Enterprise edition Feature not included in SQL Server 2017 Standard edition Feature not included in SQL Server 2017 Express edition Feature 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 Express SQL Server 2017 Developer
Advanced data integration: fuzzy grouping and look ups Feature included in SQL Server 2017 Enterprise edition Feature not included in SQL Server 2017 Standard edition Feature not included in SQL Server 2017 Express edition Feature 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 Express SQL Server 2017 Developer
Data marts and data warehousing: partitioning, data compression, change data capture, database snapshot Feature included in SQL Server 2017 Enterprise edition Feature included in SQL Server 2017 Standard edition Feature included in SQL Server 2017 Express edition Feature included in SQL Server 2017 Developer edition
In-memory columnstore[1] Feature included in SQL Server 2017 Enterprise edition Feature included in SQL Server 2017 Standard edition Feature included in SQL Server 2017 Express edition Feature included in SQL Server 2017 Developer edition
Adaptive Query Processing[4] Feature included in SQL Server 2017 Enterprise edition Feature not included in SQL Server 2017 Standard edition Feature not included in SQL Server 2017 Express edition Feature included in SQL Server 2017 Developer edition
PolyBase[2],[3] Feature included in SQL Server 2017 Enterprise edition Feature included in SQL Server 2017 Standard edition Feature included in SQL Server 2017 Express edition Feature included in SQL Server 2017 Developer edition
Enterprise data management: Master Data Services, Data Quality Services[3] Feature included in SQL Server 2017 Enterprise edition Feature not included in SQL Server 2017 Standard edition Feature not included in SQL Server 2017 Express edition Feature 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 Express SQL 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 edition Feature not included in SQL Server 2017 Developer edition
Maximum memory utilized per instance of Reporting Services[3] Operating system max 64 GB Express with Advanced Services: 4 GB Feature not included in SQL Server 2017 Developer edition
Basic reporting and analytics[3] Feature included in SQL Server 2017 Enterprise edition Feature included in SQL Server 2017 Standard edition Feature included in SQL Server 2017 Express edition Feature included in SQL Server 2017 Developer edition
Basic data integration: SQL Server Integration Services, built-in connectors Feature included in SQL Server 2017 Enterprise edition Feature included in SQL Server 2017 Standard edition Feature not included in SQL Server 2017 Express edition Feature 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 edition Feature included in SQL Server 2017 Standard edition Feature not included in SQL Server 2017 Express edition Feature included in SQL Server 2017 Developer edition
Mobile reports and KPIs[3] Feature included in SQL Server 2017 Enterprise edition Feature not included in SQL Server 2017 Standard edition Feature not included in SQL Server 2017 Express edition Feature 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 edition Feature not included in SQL Server 2017 Standard edition Feature not included in SQL Server 2017 Express edition Feature included in SQL Server 2017 Developer edition
Access to Power BI Report Server, a software assurance benefit Feature included in SQL Server 2017 Enterprise edition Feature not included in SQL Server 2017 Standard edition Feature not included in SQL Server 2017 Express edition Feature 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 Express SQL Server 2017 Developer
Basic Machine Learning integration: connectivity to open source Python and R, limited parallelism[3] Feature included in SQL Server 2017 Enterprise edition Feature included in SQL Server 2017 Standard edition Feature included in SQL Server 2017 Express edition Feature 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 edition Feature not included in SQL Server 2017 Standard edition Feature not included in SQL Server 2017 Express edition Feature 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 edition Feature not included in SQL Server 2017 Standard edition Feature not included in SQL Server 2017 Express edition Feature 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 Express SQL Server 2017 Developer
Stretch Database[3] Feature included in SQL Server 2017 Enterprise edition Feature not included in SQL Server 2017 Standard edition Feature not included in SQL Server 2017 Express edition Feature not included in SQL Server 2017 Developer edition

Reviews

There are no reviews yet.

Be the first to review “SQLSvrStd 2017 SNGL OLP NL”

Related products