|
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)² | | • |
|
|