All Products
Search
Document Center

ApsaraDB RDS:Instance types for primary ApsaraDB RDS for SQL Server instances

Last Updated:Sep 12, 2024

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.

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 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

  • SQL Server 2022 EE on RDS Cluster Edition

  • SQL Server 2019 EE on RDS Cluster Edition

  • SQL Server 2017 EE on RDS Cluster Edition

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

  • SQL Server 2016 EE

  • SQL Server 2014 EE

  • SQL Server 2012 EE

  • SQL Server 2008 R2 with cloud disks

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

  • SQL Server 2019 SE

  • SQL Server 2017 SE

  • SQL Server 2016 SE

  • SQL Server 2014 SE

  • SQL Server 2012 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.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

  • SQL Server 2016 EE

  • SQL Server 2014 EE

  • SQL Server 2012 EE

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

  • SQL Server 2022 SE

  • SQL Server 2019 SE

  • SQL Server 2017 SE

  • SQL Server 2016 SE

  • SQL Server 2014 SE

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

  • SQL Server 2022 Web

  • SQL Server 2019 Web

  • SQL Server 2017 Web

  • SQL Server 2016 Web

  • SQL Server 2012 Web

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