# Compare SQL Server Enterprise and Standard edition features
<a name="compare"></a>

The following table is a short version of the list of Microsoft SQL Server Enterprise edition features and possible alternatives in the Standard edition. For additional information, see a more extensive [feature comparison](samples/edition-comparison.zip).



- ** **Scale limits** **
  - **Feature:** Maximum number of processors or cores per instance / **Enterprise edition:** OS maximum / **Standard edition:** 4 sockets or 24 cores / **Notes:** See [DB instance class support for SQL Server](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_SQLServer.html#SQLServer.Concepts.General.InstanceClasses) on Amazon RDS for SQL.
  - **Feature:** Maximum memory used per instance / **Enterprise edition:** OS maximum / **Standard edition:** 128 GB (SQL Server 2016 and later)
  - **Feature:** Maximum memory-optimized data size per database / **Enterprise edition:** Unlimited memory (SQL Server 2014 and later) / **Standard edition:** 32 GB (SQL Server 2016 and later) / **Notes:**  

- ** **High availability** **
  - **Feature:** Always On availability groups / **Enterprise edition:** Yes / **Standard edition:** Basic availability groups (SQL Server 2016 and later) / **Notes:** The Multi-AZ feature of Amazon RDS replicates database updates across two Availability Zones to increase durability and availability. For planned maintenance and unplanned disruptions, Amazon RDS automatically fails over to the standby.
  - **Feature:** Online indexing / **Enterprise edition:** Yes / **Standard edition:** No / **Notes:** Where possible, plan for these activities during a downtime window.
  - **Feature:** Online schema change / **Enterprise edition:** Yes / **Standard edition:** No
  - **Feature:** Resumable online index rebuilds / **Enterprise edition:** Yes (SQL Server 2017 and later) / **Standard edition:** No
  - **Feature:** Accelerated database recovery (ADR) / **Enterprise edition:** Yes (SQL Server 2019) / **Standard edition:** Yes (SQL Server 2019) / **Notes:** Both SQL Server editions support ADR in SQL Server 2019.

- ** **Scalability and performance** **
  - **Feature:** Table and index partitioning / **Enterprise edition:** Yes / **Standard edition:** Yes (SQL Server 2016 SP1 and later) / **Notes:**  
  - **Feature:** Data compression / **Enterprise edition:** Yes / **Standard edition:** Yes (SQL Server 2016 SP1 and later) / **Notes:**  
  - **Feature:** Partition table parallelism / **Enterprise edition:** Yes / **Standard edition:** Yes (SQL Server 2016 SP1 and later) / **Notes:**  
  - **Feature:** In-Memory OLTP / **Enterprise edition:** Yes (SQL 2014 and later) / **Standard edition:** Yes (SQL Server 2016 SP1 and later) / **Notes:**  
  - **Feature:** Delayed durability / **Enterprise edition:** Yes (SQL 2014 and later) / **Standard edition:** Yes (SQL 2014 and later) / **Notes:**  
  - **Feature:** Columnstore / **Enterprise edition:** Yes (SQL Server 2016 SP1 and later) / **Standard edition:** Yes (SQL Server 2016 SP1 and later) / **Notes:**  
  - **Feature:** Interleaved execution for multi-statement table valued functions / **Enterprise edition:** Yes (SQL Server 2017 and later) / **Standard edition:** Yes (SQL Server 2017 and later) / **Notes:**  
  - **Feature:** Intelligent Database: batch mode on rowstore / **Enterprise edition:** Yes (SQL Server 2019) / **Standard edition:** No / **Notes:** Not available in Standard edition, but you can take advantage of the other features of Intelligent Database.
  - **Feature:** Intelligent Database: approximate count distinct / **Enterprise edition:** Yes (SQL Server 2019) / **Standard edition:** Yes (SQL Server 2019) / **Notes:**  
  - **Feature:** Intelligent Database: table variable deferred compilation / **Enterprise edition:** Yes (SQL Server 2019) / **Standard edition:** Yes (SQL Server 2019) / **Notes:**  
  - **Feature:** Intelligent Database: scalar UDF inlining / **Enterprise edition:** Yes (SQL Server 2019) / **Standard edition:** Yes (SQL Server 2019) / **Notes:**  

- ** **Security** **
  - **Feature:** Transparent database encryption (TDE) / **Enterprise edition:** Yes / **Standard edition:** Yes (SQL Server 2019) / **Notes:**  
  - **Feature:** Contained database / **Enterprise edition:** Yes / **Standard edition:** Yes / **Notes:**