Skip to content
Harga dapat berubah-ubah , langsung hubungi kami untuk mendapatkan penawaran terbaik Dismiss
SQLSvrStd 2017 SNGL OLP NL
Description
Compare SQL Server 2017 editions
View the comprehensive feature comporation of SQL Server 2017 editions for feature details and limitations.
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 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 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 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 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 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] |
 |
 |
 |
 |
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 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] |
 |
 |
 |
 |
Reviews
There are no reviews yet.