View a markdown version of this page

DB instance class support for Microsoft SQL Server - Amazon Relational Database Service

DB instance class support for Microsoft SQL Server

The computation and memory capacity of a DB instance is determined by its DB instance class. The DB instance class you need depends on your processing power and memory requirements. For more information, see DB instance classes.

The following list of DB instance classes supported for Microsoft SQL Server is provided here for your convenience. For the most current list, see the RDS console: https://console.aws.amazon.com/rds/.

Not all DB instance classes are available on all supported SQL Server minor versions. For example, some newer DB instance classes such as db.r6i aren't available on older minor versions. You can use the describe-orderable-db-instance-options AWS CLI command to find out which DB instance classes are available for your SQL Server edition and version.

SQL Server edition 2022 support range 2019 support range 2017 and 2016 support range

Enterprise Edition

db.t3.xlarge–db.t3.2xlarge

db.r5.xlarge–db.r5.24xlarge

db.r5b.xlarge–db.r5b.24xlarge

db.r5d.xlarge–db.r5d.24xlarge

db.r6i.xlarge–db.r6i.32xlarge

db.r7i.xlarge–db.r7i.48xlarge

db.r8a.xlarge–db.r8a.16xlarge

db.r8i.xlarge–db.r8i.96xlarge

db.m5.xlarge–db.m5.24xlarge

db.m5d.xlarge–db.m5d.24xlarge

db.m6i.xlarge–db.m6i.32xlarge

db.m7i.xlarge–db.m7i.48xlarge

db.m8a.xlarge–db.m8a.16xlarge

db.m8i.xlarge–db.m8i.96xlarge

db.x2iedn.xlarge–db.x2iedn.32xlarge

db.x2m.xlarge–db.x2m.32xlarge

db.z1d.xlarge–db.z1d.12xlarge

db.t3.xlarge–db.t3.2xlarge

db.r5.xlarge–db.r5.24xlarge

db.r5b.xlarge–db.r5b.24xlarge

db.r5d.xlarge–db.r5d.24xlarge

db.r6i.xlarge–db.r6i.32xlarge

db.r7i.xlarge–db.r7i.48xlarge

db.r8a.xlarge–db.r8a.16xlarge

db.r8i.xlarge–db.r8i.96xlarge

db.m5.xlarge–db.m5.24xlarge

db.m5d.xlarge–db.m5d.24xlarge

db.m6i.xlarge–db.m6i.32xlarge

db.m7i.xlarge–db.m7i.48xlarge

db.m8a.xlarge–db.m8a.16xlarge

db.m8i.xlarge–db.m8i.96xlarge

db.x2iedn.xlarge–db.x2iedn.32xlarge

db.x2m.xlarge–db.x2m.32xlarge

db.z1d.xlarge–db.z1d.12xlarge

db.t3.xlarge–db.t3.2xlarge

db.r5.xlarge–db.r5.24xlarge

db.r5b.xlarge–db.r5b.24xlarge

db.r5d.xlarge–db.r5d.24xlarge

db.r6i.xlarge–db.r6i.32xlarge

db.r7i.xlarge–db.r7i.48xlarge

db.r8a.xlarge–db.r8a.16xlarge

db.r8i.xlarge–db.r8i.96xlarge

db.m5.xlarge–db.m5.24xlarge

db.m5d.xlarge–db.m5d.24xlarge

db.m6i.xlarge–db.m6i.32xlarge

db.m7i.xlarge–db.m7i.48xlarge

db.m8a.xlarge–db.m8a.16xlarge

db.m8i.xlarge–db.m8i.96xlarge

db.x2iedn.xlarge–db.x2iedn.32xlarge

db.x2m.xlarge–db.x2m.32xlarge

db.z1d.xlarge–db.z1d.12xlarge

Standard Edition

db.t3.xlarge–db.t3.2xlarge

db.r5.large–db.r5.24xlarge

db.r5b.large–db.r5b.8xlarge

db.r5d.large–db.r5d.24xlarge

db.r6i.large–db.r6i.8xlarge

db.r7i.large–db.r7i.12xlarge

db.r8a.large–db.r8a.12xlarge

db.r8i.large–db.r8i.12xlarge

db.m5.large–db.m5.24xlarge

db.m5d.large–db.m5d.24xlarge

db.m6i.large–db.m6i.8xlarge

db.m7i.large–db.m7i.12xlarge

db.m8a.large–db.m8a.12xlarge

db.m8i.large–db.m8i.12xlarge

db.x2iedn.xlarge–db.x2iedn.8xlarge

db.x2m.xlarge–db.x2m.8xlarge

db.z1d.large–db.z1d.12xlarge

db.t3.xlarge–db.t3.2xlarge

db.r5.large–db.r5.24xlarge

db.r5b.large–db.r5b.24xlarge

db.r5d.large–db.r5d.24xlarge

db.r6i.large–db.r6i.8xlarge

db.r7i.large–db.r7i.12xlarge

db.r8a.large–db.r8a.12xlarge

db.r8i.large–db.r8i.12xlarge

db.m5.large–db.m5.24xlarge

db.m5d.large–db.m5d.24xlarge

db.m6i.large–db.m6i.8xlarge

db.m7i.large–db.m7i.12xlarge

db.m8a.large–db.m8a.12xlarge

db.m8i.large–db.m8i.12xlarge

db.x2iedn.xlarge–db.x2iedn.32xlarge

db.x2m.xlarge–db.x2m.8xlarge

db.z1d.large–db.z1d.12xlarge

db.t3.xlarge–db.t3.2xlarge

db.r5.large–db.r5.24xlarge

db.r5b.large–db.r5b.24xlarge

db.r5d.large–db.r5d.24xlarge

db.r6i.large–db.r6i.8xlarge

db.r7i.large–db.r7i.12xlarge

db.r8a.large–db.r8a.12xlarge

db.r8i.large–db.r8i.12xlarge

db.m5.large–db.m5.24xlarge

db.m5d.large–db.m5d.24xlarge

db.m6i.large–db.m6i.8xlarge

db.m7i.large–db.m7i.12xlarge

db.m8a.large–db.m8a.12xlarge

db.m8i.large–db.m8i.12xlarge

db.x2iedn.xlarge–db.x2iedn.32xlarge

db.x2m.xlarge–db.x2m.8xlarge

db.z1d.large–db.z1d.12xlarge

Web Edition

db.t3.small–db.t3.xlarge

db.r5.large–db.r5.4xlarge

db.r5b.large–db.r5b.4xlarge

db.r5d.large–db.r5d.4xlarge

db.r6i.large–db.r6i.4xlarge

db.r7i.large–db.r7i.4xlarge

db.r8a.large–db.r8a.8xlarge

db.r8i.large–db.r8i.8xlarge

db.m5.large–db.m5.4xlarge

db.m5d.large–db.m5d.4xlarge

db.m6i.large–db.m6i.4xlarge

db.m7i.large–db.m7i.4xlarge

db.m8a.large–db.m8a.8xlarge

db.m8i.large–db.m8i.8xlarge

db.z1d.large–db.z1d.13xlarge

db.t3.small–db.t3.2xlarge

db.r5.large–db.r5.4xlarge

db.r5b.large–db.r5b.4xlarge

db.r5d.large–db.r5d.4xlarge

db.r6i.large–db.r6i.4xlarge

db.r7i.large–db.r7i.4xlarge

db.r8a.large–db.r8a.8xlarge

db.r8i.large–db.r8i.8xlarge

db.m5.large–db.m5.4xlarge

db.m5d.large–db.m5d.4xlarge

db.m6i.large–db.m6i.4xlarge

db.m7i.large–db.m7i.4xlarge

db.m8a.large–db.m8a.8xlarge

db.m8i.large–db.m8i.8xlarge

db.z1d.large–db.z1d.3xlarge

db.t3.small–db.t3.2xlarge

db.r5.large–db.r5.4xlarge

db.r5b.large–db.r5b.4xlarge

db.r5d.large–db.r5d.4xlarge

db.r6i.large–db.r6i.4xlarge

db.r7i.large–db.r7i.4xlarge

db.r8a.large–db.r8a.8xlarge

db.r8i.large–db.r8i.8xlarge

db.m5.large–db.m5.4xlarge

db.m5d.large–db.m5d.4xlarge

db.m6i.large–db.m6i.4xlarge

db.m7i.large–db.m7i.4xlarge

db.m8a.large–db.m8a.8xlarge

db.m8i.large–db.m8i.8xlarge

db.z1d.large–db.z1d.3xlarge

Express Edition

db.t3.micro–db.t3.xlarge

db.t3.micro–db.t3.xlarge

db.t3.micro–db.t3.xlarge
Developer Edition

db.m6i.xlarge–db.m6i.32xlarge

db.m8a.xlarge–db.m8a.16xlarge

db.m8i.xlarge–db.m8i.96xlarge

db.r6i.xlarge–db.r6i.32xlarge

db.r8a.xlarge–db.r8a.16xlarge

db.r8i.xlarge–db.r8i.96xlarge

db.x2m.xlarge–db.x2m.32xlarge

db.m6i.xlarge–db.m6i.32xlarge

db.m8a.xlarge–db.m8a.16xlarge

db.m8i.xlarge–db.m8i.96xlarge

db.r6i.xlarge–db.r6i.32xlarge

db.r8a.xlarge–db.r8a.16xlarge

db.r8i.xlarge–db.r8i.96xlarge

db.x2m.xlarge–db.x2m.32xlarge
Note

  • Starting with the 7th generation instance class, hyper-threading is disabled on RDS SQL Server for instance sizes 2xlarge and above. This results in the total number of vCPUs available being half of that supported by the corresponding EC2 instance. For example, the EC2 instance type m7i.2xlarge by default supports 4 cores and 2 threadsPerCore, resulting in a total of 8 vCPUs. In contrast, the RDS for SQL Server db.m7i.2xlarge instance, with hyper-threading disabled, results in 4 cores and 1 threadsPerCore, overall 4 vCPUs.

  • Amazon RDS for SQL Server launched memory-optimized X2M database instances, based on the Amazon EC2 X2iedn instance. Hyper-threading is disabled on RDS SQL Server for instance sizes 2xlarge and above for X2m database instances. This results in the total number of vCPUs available being half of that supported by the corresponding EC2 instance. For example, the EC2 instance type x2m.2xlarge (x2iedn.2xlarge) by default supports 4 cores and 2 threadsPerCore, resulting in a total of 8 vCPUs. In contrast, the RDS for SQL Server x2m.2xlarge (x2iedn.2xlarge) instance, with hyper-threading disabled, results in 4 cores and 1 threadsPerCore, overall 4 vCPUs.

  • Starting with the 7th generation instances and X2M instances, your billing provides a detailed breakdown of RDS DB instance and third-party licensing fees. For more details, refer to RDS SQL Server pricing.

  • For AMD instances, each vCPU corresponds to a physical CPU core, designed to deliver consistent per-core performance. For AMD instances that are 2xlarge and larger, Amazon RDS disables 50% of the CPU cores by default. This configuration helps reduce Windows and SQL Server software licensing costs while maintaining workload performance. To enable additional CPU capacity, you can use optimize CPU to enable up to 100% of the available cores. Because the instance price remains the same regardless of the core configuration, you can customize the vCPU count to balance performance requirements against licensing costs without impacting your compute charges. For AMD instances that are xlarge and smaller, those with 4 vCPU or fewer, 100% of the cores are enabled by default and core count customization is not available. This is because Microsoft charges for a minimum of 4 vCPUs for SQL Server licenses, so you are unable to reduce the number of vCPUs for these instances.