edit-icon download-icon

Test approach

Last Updated: Feb 10, 2018

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.

  1. Open HammerDB.

  2. Select SQL SERVER and TPC-C.

    Test step 2

  3. Prepare for building schema.

    Test step 3

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

    Test step 4

  5. Double-click Schema Build/Build.

    Test step 5

  6. Click YES to create a schema.

    Test step 6

  7. Wait until the schema initialization is complete.

    Test step 7

  8. When all initialization items show complete, click the button marked by the red box to stop initialization.

    Test step 8

  9. In the left-side navigation pane, select Driver script/option and verify that the database connection information is correct.

    Test step 9

  10. In the left-side navigation pane, select Driver script/load.

    Test step 10

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

    Test step 11

  12. In the left-side navigation pane, select Virtual User/Create.

    Test step 12

  13. In the left-side navigation pane, select Transactions/Option.

    Test step 13

  14. In the left-side navigation pane, select Transactions/Counter.

    Test step 14

  15. In the left-side navigation pane, select Virtual User/Run.

    Test step 15

Thank you! We've received your feedback.