Features | SQL Server Standard | SQL Server Enterprise |
---|---|---|
Computer and storage | ||
Maximum number of cores | 24 | OS MAX |
Maximum memory utilized per instance | 128 GB | OS MAX |
Maximum size | 524 PB | 524 PB |
Azure enabled | ||
Azure Synapse Link for SQL | ![]() |
![]() |
Ledger | ![]() |
![]() |
Link feature for Azure SQL Managed Instance | ![]() |
![]() |
Link feature for Azure SQL Managed Instance (basic availability groups) | ![]() |
![]() |
Choice of language and platform | ||
Microsoft Purview policies | ![]() |
![]() |
JSON T-SQL Enhancements | ![]() |
![]() |
Modern T-SQL surface area | ![]() |
![]() |
Query Store by default for new databases | ![]() |
![]() |
Query Store: Read-replica support | ![]() |
![]() |
Industry leading performance and availability | ||
Built-in query intelligence: Parameter Sensitive Plan (PSP) Optimization, Optimized plan forcing | ![]() |
![]() |
Built-in query intelligence: CE Feedback, DOP Feedback, Memory Grant Feedback | ![]() |
![]() |
Contained Availability Group | ![]() |
![]() |
Buffer Pool Parallel Scan | ![]() (limited to 2 threads, over 64GB Mem only) |
![]() |
AVX 512 extension for batch mode | ![]() |
![]() |
Intel QAT Enhancements for Backup | ![]() (SW only) |
![]() (SW + HW) |
Secure and reliable | ||
Timeseries support | ![]() |
![]() |
Always Encrypted with secure enclaves - new features | ![]() |
![]() |
Granular permissions for Dynamic Data Masking | ![]() |
![]() |
Analytics | ||
Data Lake Virtualization | ![]() |
![]() |
Object Storage Integration with S3-compatible storage | ![]() |
![]() |
Contact Us: [email protected]
Our team of experts is at your disposal. We will answer all your questions, select an individual offer and help you implement the product.