Help Center> Relational Database Service> Performance White Paper> RDS for SQL Server> Test Data
Updated on 2022-04-01 GMT+08:00
View PDF

Test Data

Concepts

Transactions per minute (TPM): Number of simulated orders processed by the system in the TPCC standard model per minute.

TPS: Number of simulated orders processed by the system in the TPCC standard model per second.

Input/output operations per second (IOPS): Number of disk read/write operations per second. IOPS in this document refers to the IOPS displayed when the performance reaches the peak in the stress testing, instead of the maximum IOPS capability.

TPM reflects more comprehensive performance than TPS. IOPS indicates the disk read/write capability in the current stress testing, which is for reference only.

Test Result

Table 1 Test results

DB Instance Type

Edition

vCPUs

Memory (GB)

TPM

TPS

IOPS

Primary/Standby

2008 R2 Enterprise

2

8

300,000

5,500

4,000

2008 R2 Enterprise

4

16

530,000

9,700

7,000

2008 R2 Enterprise

8

32

930,000

17,050

15,000

2008 R2 Enterprise

16

64

1,250,000

23,000

20,000

2008 R2 Enterprise

2

16

290,000

5,300

4,000

2008 R2 Enterprise

4

32

540,000

9,900

7,000

2008 R2 Enterprise

8

64

960,000

17,600

15,000

2008 R2 Enterprise

16

128

1350000

24750

20000

Single

2014 Enterprise and 2014 Standard

4

16

550,000

10,083

7,000

2014 Enterprise and 2014 Standard

8

32

1,100,000

20,166

16,000

2014 Enterprise and 2014 Standard

16

64

1,500,000

27,500

22,000

Primary/Standby

2014 Enterprise and 2014 Standard

4

32

500,000

9,000

7,000

2014 Enterprise and 2014 Standard

8

64

1,000,000

18,333

16,000

2014 Enterprise and 2014 Standard

16

128

1,400,000

24,000

21,000

Single

2014 Web

4

16

550,000

10,000

6,000

2014 Web

8

32

1,100,000

20,000

12,000

2014 Web

16

64

1,500,000

27,000

18,000
Parent topic: RDS for SQL Server