This topic provides an overview of the instance types that are supported for primary ApsaraDB RDS for SQL Server instances. This overview includes the most recent instance types, the earlier instance types, and the specifications for each instance type.
The memory capacity that is supported by an instance type includes the memory that is occupied by the RDS-related management services, the database service, and the underlying operating system. For example, the memory capacity includes the memory reserved for BIOS, the memory occupied by the kernel of the operating system, and the memory occupied by the hypervisor. Therefore, the available memory that you can view may be less than the memory capacity that is supported by the instance type.
RDS instances that use cloud disks are deployed on Elastic Compute Service (ECS) instances. The performance of these RDS instances varies based on the instance families of the ECS instances. For more information, see Instance family.
Standard RDS instances that run RDS Basic Edition can be created only in regions outside China.
Instance types for primary RDS instances
RDS Cluster Edition
RDS edition | Instance family | Instance type | Number of CPU cores and memory capacity | Maximum number of connections | Maximum IOPS | Storage capacity |
| Dedicated instance family | mssql.x4.medium.e2 | 2 cores, 8 GB | Unlimited | For more information, see IOPS. | 20 GB to 32,000 GB |
mssql.x4.large.e2 | 4 cores, 16 GB | |||||
mssql.x4.xlarge.e2 | 8 cores, 32 GB | |||||
mssql.x4.2xlarge.e2 | 16 cores, 64 GB | |||||
mssql.x4.4xlarge.e2 | 32 cores, 128 GB | |||||
mssql.x4.8xlarge.e2 | 64 cores, 256 GB | |||||
mssql.x8.medium.e2 | 2 cores, 16 GB | |||||
mssql.x8.large.e2 | 4 cores, 32 GB | |||||
mssql.x8.xlarge.e2 | 8 cores, 64 GB | |||||
mssql.x8.2xlarge.e2 | 16 cores, 128 GB | |||||
mssql.x8.4xlarge.e2 | 32 cores, 256 GB | |||||
mssql.x8.8xlarge.e2 | 64 cores, 512 GB |
RDS High-availability Edition
RDS edition | Instance family | Instance type | Number of CPU cores and memory capacity | Maximum number of connections | Maximum IOPS | Storage capacity |
SQL Server 2008 R2 with local disks (phased out) | General-purpose instance family | rds.mssql.s1.small | 1 core, 2 GB | 600 | For more information, see IOPS. | 10 GB to 2,000 GB |
rds.mssql.s1.large | 2 cores, 2 GB | 600 | ||||
rds.mssql.s2.large | 2 cores, 4 GB | 1,200 | ||||
rds.mssql.s2.xlarge | 2 cores, 8 GB | 2,000 | ||||
rds.mssql.s3.large | 4 cores, 8 GB | 2,000 | ||||
rds.mssql.m1.medium | 4 cores, 16 GB | 4,000 | ||||
rds.mssql.c1.large | 8 cores, 16 GB | 4,000 | ||||
rds.mssql.c1.xlarge | 8 cores, 32 GB | 8,000 | ||||
rds.mssql.c2.xlarge | 16 cores, 64 GB | 16,000 | ||||
Dedicated instance family | mssql.x8.medium.2 | 2 cores, 16 GB | 2,500 | For more information, see IOPS. | 250 GB | |
mssql.x8.large.2 | 4 cores, 32 GB | 5,000 | 500 GB | |||
mssql.x8.xlarge.2 | 8 cores, 64 GB | 10,000 | 1,000 GB | |||
mssql.x8.2xlarge.2 | 16 cores, 128 GB | 20,000 | 2,000 GB | |||
Dedicated host instance family | rds.mssql.st.d13 | 30 cores, 220 GB | 64,000 | For more information, see IOPS. | 2,000 GB | |
rds.mssql.st.h43 | 60 cores, 470 GB | 100,000 | 3,000 GB | |||
| Dedicated instance family | mssql.x4.medium.e2 | 2 cores, 8 GB | Unlimited | For more information, see IOPS. | 20 GB to 32,000 GB |
mssql.x8.medium.e2 | 2 cores, 16 GB | |||||
mssql.x4.large.e2 | 4 cores, 16 GB | |||||
mssql.x8.large.e2 | 4 cores, 32 GB | |||||
mssql.x4.xlarge.e2 | 8 cores, 32 GB | |||||
mssql.x8.xlarge.e2 | 8 cores, 64 GB | |||||
mssql.x4.2xlarge.e2 | 16 cores, 64 GB | |||||
mssql.x8.2xlarge.e2 | 16 cores, 128 GB | |||||
mssql.x4.3xlarge.e2 | 24 cores, 96 GB | |||||
mssql.x4.4xlarge.e2 | 32 cores, 128 GB | |||||
mssql.x8.4xlarge.e2 | 32 cores, 256 GB | |||||
mssql.x4.8xlarge.e2 | 64 cores, 256 GB | |||||
mssql.x8.8xlarge.e2 | 64 cores, 512 GB | |||||
| Dedicated instance family | mssql.x4.medium.s2 | 2 cores, 8 GB | Unlimited | For more information, see IOPS. | 20 GB to 32,000 GB |
mssql.x4.large.s2 | 4 cores, 16 GB | |||||
mssql.x4.xlarge.s2 | 8 cores, 32 GB | |||||
mssql.x4.2xlarge.s2 | 16 cores, 64 GB | |||||
mssql.x4.3xlarge.s2 | 24 cores, 96 GB | |||||
mssql.x8.medium.s2 | 2 cores, 16 GB | |||||
mssql.x8.large.s2 | 4 cores, 32 GB | |||||
mssql.x8.xlarge.s2 | 8 cores, 64 GB | |||||
mssql.x8.2xlarge.s2 | 16 cores, 128 GB | |||||
Shared instance family | mssql.mem2.medium.s2 | 2 cores, 4 GB | Unlimited | For more information, see IOPS. | 20 GB to 4,000 GB | |
mssql.mem2.large.s2 | 4 cores, 8 GB | |||||
mssql.mem2.xlarge.s2 | 8 cores, 16 GB | |||||
mssql.mem2.2xlarge.s2 | 12 cores, 24 GB | |||||
mssql.mem2.3xlarge.s2 | 16 cores, 32 GB | |||||
mssql.mem2.4xlarge.s2 | 24 cores, 48 GB | |||||
SQL Server 2022 SE | Dedicated instance family | mssql.x4.medium.s2 | 2 cores, 8 GB | Unlimited | For more information, see IOPS. | 20 GB to 32,000 GB |
mssql.x4.large.s2 | 4 cores, 16 GB | |||||
mssql.x4.xlarge.s2 | 8 cores, 32 GB | |||||
mssql.x4.2xlarge.s2 | 16 cores, 64 GB | |||||
mssql.x4.3xlarge.s2 | 24 cores, 96 GB | |||||
mssql.x8.medium.s2 | 2 cores, 16 GB | |||||
mssql.x8.large.s2 | 4 cores, 32 GB | |||||
mssql.x8.xlarge.s2 | 8 cores, 64 GB | |||||
mssql.x8.2xlarge.s2 | 16 cores, 128 GB | |||||
| Shared instance family | mssql.mem2.medium.e2 | 2 cores, 4 GB | Unlimited | For more information, see IOPS. | 20 GB to 4,000 GB |
mssql.mem4.medium.e2 | 2 cores, 8 GB | |||||
mssql.mem2.large.e2 | 4 cores, 8 GB | |||||
mssql.mem4.large.e2 | 4 cores, 16 GB | |||||
mssql.mem2.xlarge.e2 | 8 cores, 16 GB | |||||
mssql.mem4.xlarge.e2 | 8 cores, 32 GB | |||||
mssql.mem2.2xlarge.e2 | 16 cores, 32 GB | |||||
mssql.mem4.2xlarge.e2 | 16 cores, 64 GB | |||||
mssql.mem2.3xlarge.e2 | 24 cores, 48 GB | |||||
mssql.mem4.3xlarge.e2 | 24 cores, 96 GB | |||||
mssql.mem2.4xlarge.e2 | 32 cores, 64 GB | |||||
mssql.mem4.4xlarge.e2 | 32 cores, 128 GB |
RDS Basic Edition
RDS edition | Instance family | Instance type | Number of CPU cores and memory capacity | Maximum number of connections | Maximum IOPS | Storage capacity |
SQL Server 2016 EE | Dedicated instance family | mssql.x4.medium.e1 | 2 cores, 8 GB | Unlimited | For more information, see IOPS. | 20 GB to 32,000 GB |
mssql.x4.large.e1 | 4 cores, 16 GB | |||||
mssql.x4.xlarge.e1 | 8 cores, 32 GB | |||||
mssql.x4.2xlarge.e1 | 16 cores, 64 GB | |||||
mssql.x4.4xlarge.e1 | 32 cores, 128 GB | |||||
mssql.x4.8xlarge.e1 | 64 cores, 256 GB | |||||
mssql.x8.medium.e1 | 2 cores, 16 GB | |||||
mssql.x8.large.e1 | 4 cores, 32 GB | |||||
mssql.x8.xlarge.e1 | 8 cores, 64 GB | |||||
mssql.x8.2xlarge.e1 | 16 cores, 128 GB | |||||
mssql.x8.4xlarge.e1 | 32 cores, 256 GB | |||||
mssql.x8.8xlarge.e1 | 64 cores, 512 GB | |||||
| Dedicated instance family | mssql.x4.medium.s1 | 2 cores, 8 GB | Unlimited | For more information, see IOPS. | 20 GB to 32,000 GB |
mssql.x4.large.s1 | 4 cores, 16 GB | |||||
mssql.x4.xlarge.s1 | 8 cores, 32 GB | |||||
mssql.x4.2xlarge.s1 | 16 cores, 64 GB | |||||
mssql.x4.3xlarge.s1 | 24 cores, 96 GB | |||||
mssql.x8.medium.s1 | 2 cores, 16 GB | |||||
mssql.x8.large.s1 | 4 cores, 32 GB | |||||
mssql.x8.xlarge.s1 | 8 cores, 64 GB | |||||
mssql.x8.2xlarge.s1 | 16 cores, 128 GB | |||||
| Dedicated instance family | mssql.x2.medium.w1 | 2 cores, 4 GB | Unlimited | For more information, see IOPS. | 20 GB to 32,000 GB |
mssql.x4.medium.w1 | 2 cores, 8 GB | |||||
mssql.x2.large.w1 | 4 cores, 8 GB | |||||
mssql.x4.large.w1 | 4 cores, 16 GB | |||||
mssql.x2.xlarge.w1 | 8 cores, 16 GB | |||||
mssql.x4.xlarge.w1 | 8 cores, 32 GB | |||||
mssql.x2.2xlarge.w1 | 16 cores, 32 GB | |||||
mssql.x4.2xlarge.w1 | 16 cores, 64 GB | |||||
SQL Server 2012 EE Basic | General-purpose instance family | rds.mssql.s2.large | 2 cores, 4 GB | Unlimited | For more information, see IOPS. | 20 GB to 32,000 GB |
rds.mssql.s2.xlarge | 2 cores, 8 GB | |||||
rds.mssql.s3.large | 4 cores, 8 GB | |||||
rds.mssql.m1.medium | 4 cores, 16 GB | |||||
rds.mssql.c1.large | 8 cores, 16 GB | |||||
rds.mssql.c1.xlarge | 8 cores, 32 GB | |||||
rds.mssql.c2.xlarge | 16 cores, 64 GB |
Phased-out ApsaraDB RDS for SQL Server instance types
The following table lists phased-out ApsaraDB RDS for SQL Server instance types. The phased-out instance types are no longer available to new RDS instances. We recommend that you select most recent instance types for new RDS instances.
Instance type | Number of CPU cores | Memory capacity | Maximum number of connections |
rds.mssql.s1.small | 1 | 2GB | 600 |
rds.mss1.small | 6 | 1,000 MB | 100 |
rds.mss1.mid | 8 | 2,000 MB | 200 |
rds.mss1.standard | 9 | 4,000 MB | 400 |
rds.mss1.large | 10 | 6,000 MB | 600 |
rds.mss1.xlarge | 11 | 8,000 MB | 800 |
rds.mss1.2xlarge | 12 | 12,000 MB | 1,200 |
rds.mss1.4xlarge | 13 | 24,000 MB | 2,000 |
rds.mss1.8xlarge | 13 | 48,000 MB | 2,000 |
rds.mssql.c2.xlp2 | 16 | 96 GB | 24,000 |