|
| Licentiemodel | Server+CAL / Per Core | Per Core |
| Maximaal aantal cores | 24 cores | onbeperkt |
| Maximale buffer pool grootte per instance | 128 GB | OS maximum |
| Maximale Columnstore segment cache per instance | 32 GB | OS maximum |
| Maximum aan memory-optimized data per database | 32 GB | OS maximum |
| Maximum geheugen per Analysis Services instance (Tabular) | 16 GB | OS maximum |
| Maximum geheugen per Analysis Services instance (MOLAP) | 64 GB | OS maximum |
| Maximum geheugen per Reporting Services instance | 64 GB | OS maximum |
| Maximale databasegrootte | 524 PB | 524 PB |
| Programmeerbaarheid & ontwikkeltools (T-SQL, CLR, Data Types, FileTable², JSON, Graph Data support) | • | • |
| Beheerbaarheid (Management Studio, Policy-Based Management) | • | • |
| Geavanceerde OLTP (In-memory OLTP¹, Operational analytics¹) | • | • |
| Data warehousing (In-Memory ColumnStore¹, partitioning, data compression, change data capture², database snapshot) | • | • |
| Standaard security (Always Encrypted, row-level security, data masking, basic auditing, separation of duties) | • | • |
| Standaard corporate business intelligence (Multi-dimensional models, Basic tabular model, enhanced connectors, new transformations, object-level security, ragged hierarchies)² | • | • |
| Standaard R en Python integratie (Connectiviteit met R Open en Python, beperkte mogelijkheden voor parallel processing met Machine Learning Services)² | • | • |
| Standaard High Availability (2-node single database failover, non-readable secondary) | • | • |
| Standaard Adaptive Query Processing (Interleaved execution) | • | |
| Geavanceerde Advanced High Availability (Always On Availability Groups, multi-node, multi-DB failover, readable secondaries) | | • |
| Geavanceerde Adaptive Query Processing (Batch mode memory grant feedback, Batch mode adaptive joins), Automatic Plan Correction | | • |
| Geavanceerde security (Transparent Data Encryption) | | • |
| Geavanceerde corporate business intelligence² (Advanced tabular model, direct query, in-memory analytics, Mobile BI) | | • |
| Geavanceerde R en Python integratie (beschikbaar voor GPUs en de volledige mogelijkheden van parallel processing met Machine Learning Services)² | | • |
|
|