Features | SQL Server 2017 Enterprise | SQL Server 2017 Standard | SQL Server 2017 Express | SQL Server 2017 Developer |
---|
View the comprehensive feature comporation of SQL Server 2017 editions for feature details and limitations.
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 |
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 |
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 |
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 |
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 |
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] |
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 |
||
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 |
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 |
Features | SQL Server 2017 Enterprise | SQL Server 2017 Standard | SQL Server 2017 Express | SQL Server 2017 Developer |
---|---|---|---|---|
Stretch Database[3] |
Average Star Rating: 0.0 out of 5 (0 vote)
If you finish the payment today, your order will arrive within the estimated delivery time.You must be logged in to post a review.
Reviews
There are no reviews yet.