SQL Server 2019 is offered in two main commercial editions to accommodate the unique feature, performance and price requirements of organizations and individuals:
The editions are offered in a straightforward, tiered model that creates greater consistency across the product editions, features and licensing. Enterprise Edition includes all the capabilities available in SQL Server 2019.
Through a consistent programming interface across all editions, it is easier than ever for developers and partners to build and upgrade applications that take advantage of advanced performance, security, and data mart or data warehouse features – regardless of scale, from Express to Enterprise.
SQL Server edition | Server + Client Access License (CAL)3 | Per Core license2 |
---|---|---|
Enterprise1 | ||
Standard |
1 Customers who require a massively parallel processing data warehouse have access to a parallel data warehouse through their Enterprise Edition core licenses with Software Assurance.
2 Editions sold in the per-core licensing model and Big Data Nodes are sold as 2 core packs.
Feature | Enterprise | Standard |
---|---|---|
Maximum compute capacity used by a single instance - SQL Server Database Engine1 | Operating system maximum | Limited to lesser of 4 sockets or 24 cores |
Maximum compute capacity used by a single instance - Analysis Services or Reporting Services | Operating system maximum | Limited to lesser of 4 sockets or 24 cores |
Maximum memory for buffer pool per instance of SQL Server Database Engine | Operating system maximum | 128 GB |
Maximum memory for Columnstore segment cache per instance of SQL Server Database Engine | Unlimited memory | 32 GB |
Maximum memory-optimized data size per database in SQL Server Database Engine | Unlimited memory | 32 GB |
Maximum memory utilized per instance of Analysis Services | Operating System Maximum | 16 GB2 64 GB3 |
Maximum memory utilized per instance of Reporting Services | Operating System Maximum | 64 GB |
Maximum relational database size | 524 PB | 524 PB |
1 Enterprise Edition with Server + Client Access License (CAL) based licensing (not available for new agreements) is
limited to a maximum of 20 cores per SQL Server instance.
2 Tabular
3 MOLAP