Complete the following operations before you perform a TPC-C test.
Note: We recommend that you use the test result data in the first 30 minutes to 2 hours. With increasing data volumes, the TPC-C mode encounters performance bottlenecks, in which case you must add indexes to tables [dbo].[STOCK], [dbo].[ORDER_LINE], and [dbo].[ORDERS] to guarantee normal testing.
Open HammerDB.
Select SQL SERVER and TPC-C.
Prepare for building schema.
Set the connection information and initialize the repository. The value 10 applies to all specifications. Set and adjust the number of concurrent users based on stress to obtain the optimal test performance. Then double-click Schema Build/Option.
Note: Though a port is specified during testing the RDS instance, you must specify the port on the SQL server, for example, **.sqlserver.rds.aliyuncs.com,3433.
Double-click Schema Build/Build.
Click YES to create a schema.
Wait until the schema initialization is complete.
When all initialization items show complete, click the button marked by the red box to stop initialization.
In the left-side navigation pane, select Driver script/option and verify that the database connection information is correct.
In the left-side navigation pane, select Driver script/load.
In the left-side navigation pane, select the Virtual User configuration, and select the number of users based on specifications. Wait until the database reaches the highest TPM.
Note: We do not recommend selecting the show output option, which may make the client unresponsive.
In the left-side navigation pane, select Virtual User/Create.
In the left-side navigation pane, select Transactions/Option.
In the left-side navigation pane, select Transactions/Counter.
In the left-side navigation pane, select Virtual User/Run.