





| 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.
