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.

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
  • SQL Server 2019 SE
  • SQL Server 2017 SE
  • SQL Server 2016 SE
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
  • 2019 SQL Server 2019 Web
  • 2017 SQL Server 2017 Web
  • 2016 SQL Server 2016 Web
  • 2012 SQL Server 2012 Web
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
  • SQL Server 2016 EE
  • SQL Server 2012 EE
  • 2008 SQL Server 2008 R2 Cloud Disk 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.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
  • SQL Server 2019 SE
  • SQL Server 2017 SE
  • SQL Server 2016 SE
  • SQL Server 2012 SE
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
  • SQL Server 2016 EE
  • SQL Server 2012 EE
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
  • SQL Server 2019 EE
  • SQL Server 2017 EE
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.