This topic describes the results of a performance test on an ApsaraDB RDS instance that runs SQL Server 2008 R2 on RDS High-availability Edition.

Note The test is based on the TPC-C benchmarks. However, the test is not an official TPC-C benchmark test. Therefore, the test results that are provided in this topic cannot be compared with the test results of the official TPC-C benchmarks.

Tested instance types

Instance type Number of cores Memory (GB) IOPS
rds.mssql.s1.small 1 2 1,000
rds.mssql.s2.large 2 4 2,000
rds.mssql.s2.xlarge 2 8 4,000
rds.mssql.s3.large 4 8 5,000
rds.mssql.m1.medium 4 16 7,000
rds.mssql.c1.large 8 16 8,000
rds.mssql.c1.xlarge 8 32 12,000
rds.mssql.c2.xlarge 16 64 14,000
rds.mssql.c2.xlp2 16 96 16,000
rds.mssql.c2.2xlarge 16 128 16,000

Test results

No. Instance type TPM Batch Request TPS
1 rds.mssql.s1.small 162,000 2,680 3,100
2 rds.mssql.s2.large 273,000 4,370 4,980
3 rds.mssql.s2.xlarge 293,000 4,600 5,400
4 rds.mssql.s3.large 483,000 7,450 8,970
5 rds.mssql.m1.medium 517,800 8,260 9,640
6 rds.mssql.c1.large 630,000 9,950 11,400
7 rds.mssql.c1.xlarge 647,000 10,300 11,600
8 rds.mssql.c2.xlarge 769,000 11,700 13,900
9 rds.mssql.c2.xlp2 810,000 13,300 14,200
10 rds.mssql.c2.2xlarge 840,000 13,100 14,800