All Products
Search
Document Center

:Test procedure

Last Updated:Aug 24, 2023

Procedure

Perform the following steps before the TPC-C test:

We recommend that you use the results between the time range of 30 minutes to 2 hours after the test begins. The data volume changes, and the TPC-C mode may encounter bottlenecks. Consequently, indexes must be created for the [dbo].[STOCK], [dbo].[ORDER_LINE], and [dbo].[ORDERS] tables to complete the test on the tables.

  1. Open HammerDB.
  2. Select MSSQL Server and TPC-C.
  3. Create the architecture.
  4. Configure the connection-related parameters, the Number of Warehouses parameter, and the Virtual Users to Build Schema parameter. In the Benchmark section, expand Schema Build and double-click Options.
    Note When you test the performance of your RDS instance, the port of the RDS instance is specified, but you are still required to specify the port number for SQL Server. Example: **.sqlserver.rds.aliyuncs.com,3433.
  5. In the Benchmark section, expand Schema Build and double-click Build.
  6. Click Yes to create the architecture.
  7. Wait until the architecture is created.
  8. After the architecture is created, click the icon marked in red to stop the progress.
  9. In the Benchmark section, expand Driver Script and double-click Options to confirm that the database connection information is correct.
  10. In the Benchmark section, expand Driver Script and double-click Load.
  11. In the Virtual User Options dialog box, configure the required parameters and adjust the value of the Virtual Users parameter to obtain the highest TPM.
    Note We recommend that you do not select Show Output. If you select Show Output, the client may fail to respond.
  12. In the Benchmark section, expand Virtual User and double-click Create.
  13. In the Benchmark section, expand Transactions and double-click Options.
  14. In the Benchmark section, expand Transactions and double-click Counter.
  15. In the Benchmark section, expand Virtual User and double-click Run.