This topic provides an overview of the primary instance types that are supported for ApsaraDB RDS for SQL Server. This overview includes the most recent instance types, the earlier instance types, and the specifications for each instance type.
Note
- 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 standard SSDs or enhanced SSDs (ESSDs) 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.
Overview of primary ApsaraDB RDS for SQL Server instance types
| RDS Edition | SQL Server version | Instance family | Instance type | CPU and memory specifications | Maximum number of connections | Maximum IOPS | Storage capacity |
|---|---|---|---|---|---|---|---|
| Basic Edition | SQL Server 2016 EE | Dedicated instance family | mssql.x4.medium.e1 | 2 cores, 8 GB | Unlimited | For more information, see the "IOPS" section in Primary instance types. | 20 GB to 16,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 | 18 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 | ||||
| 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 the "IOPS" section in Primary instance types. | 20 GB to 16,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 | ||||||
| High-availability Edition | 2008 SQL Server 2008 R2 Cloud Disk Edition (This edition is not available.) | General-purpose instance family | rds.mssql.s1.large | 2 cores, 2 GB | Unlimited | For more information, see the "IOPS" section in Primary instance types. | 10 GB to 2,000 GB |
| rds.mssql.s2.large | 2 cores, 4 GB | 1,200 | 2,000 | ||||
| rds.mssql.s2.xlarge | 2 cores, 8 GB | 2,000 | 4,000 | ||||
| rds.mssql.s3.large | 4 cores, 8 GB | 2,000 | 5,000 | ||||
| rds.mssql.m1.medium | 4 cores, 16 GB | 4,000 | 7,000 | ||||
| rds.mssql.c1.large | 8 cores, 16 GB | 4,000 | 8,000 | ||||
| rds.mssql.c1.xlarge | 8 cores, 32 GB | 8,000 | 12,000 | ||||
| rds.mssql.c2.xlarge | 16 cores, 64 GB | 16,000 | 14,000 | ||||
| Dedicated instance family | mssql.x8.medium.2 | 2 cores, 16 GB | 2,500 | 4,500 | 250 GB | ||
| mssql.x8.large.2 | 4 cores, 32 GB | 5,000 | 9,000 | 500 GB | |||
| mssql.x8.xlarge.2 | 8 cores, 64 GB | 10,000 | 18,000 | 1,000 GB | |||
| mssql.x8.2xlarge.2 | 16 cores, 128 GB | 20,000 | 36,000 | 2,000 GB | |||
| Dedicated host instance family | rds.mssql.st.d13 | 30 cores, 220 GB | 64,000 | 20,000 | 2,000 GB | ||
| rds.mssql.st.h43 | 60 cores, 470 GB | 100,000 | 50,000 | 3,000 GB | |||
|
Dedicated instance family | mssql.x4.medium.e2 | 2 cores, 8 GB | Unlimited | For more information, see the "IOPS" section in Primary instance types. | 20 GB to 16,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.x8.7xlarge.e2 | 56 cores, 480 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 | ||||
| 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 | ||||||
| Shared instance family | mssql.mem2.medium.s2 | 2 cores, 4 GB | 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 | ||||||
|
Shared instance family | mssql.mem2.medium.e2 | 2 cores, 4 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 | ||||||
| Cluster Edition |
|
Dedicated instance family | mssql.x4.medium.e2 | 2 cores, 8 GB | Unlimited | For more information, see the "IOPS" section in Primary instance types. | 20 GB to 16,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 |
Phased-out ApsaraDB RDS for SQL Server instance types
The following table lists phased-out ApsaraDB RDS for SQL Server instance types. These instance types are no longer available to new instances.
| Instance type | CPU cores | Memory capacity | Maximum connections | Maximum IOPS |
|---|---|---|---|---|
| rds.mssql.s1.small | 1 | 2 GB | 600 | 1,000 |
| rds.mss1.small | 6 | 1,000 MB | 100 | 500 |
| rds.mss1.mid | 8 | 2,000 MB | 200 | 1,000 |
| rds.mss1.standard | 9 | 4,000 MB | 400 | 2,000 |
| rds.mss1.large | 10 | 6,000 MB | 600 | 3,000 |
| rds.mss1.xlarge | 11 | 8,000 MB | 800 | 4,000 |
| rds.mss1.2xlarge | 12 | 12,000 MB | 1,200 | 6,000 |
| rds.mss1.4xlarge | 13 | 24,000 MB | 2,000 | 12,000 |
| rds.mss1.8xlarge | 13 | 48,000 MB | 2,000 | 14,000 |
| rds.mssql.c2.xlp2 | 16 | 96 GB | 24,000 | 16,000 |
| pg.n1.micro.1 | 1 | 1 GB | 100 | See Maximum IOPS for standard SSDs and ESSDs. |