DocsICP FilingConsole
Documentation
Home Page ApsaraDB RDS RDS SQL Server Database Support Performance whitepapers Test methods Test procedure

Test procedure

Updated at:
Copy as MD
Product
My Favorites

This topic explains how to test the performance of an RDS for SQL Server instance.

Note

When you run the test described in this topic, we recommend that you limit the test duration to 30 minutes to 2 hours. This is because as the data volume increases, the TPC-C model encounters a performance bottleneck, and you must add an Index to the [dbo].[STOCK], [dbo].[ORDER_LINE], and [dbo].[ORDERS] tables to successfully complete the test.

Procedure

  1. Open HammerDB.

  2. Select SQL Server and TPC-C.

  3. Prepare the schema build.

    In HammerDB, expand the Benchmark pane on the left and select SQL Server > TPC-C. After initialization is complete, the console at the bottom displays the message The xml in config.xml is well-formed, applying variables and the (HammerDB-2.16) 2 % prompt, indicating that the tool is ready.

  4. Double-click Schema Build/Options to set the connection information, initialize the warehouses (set to 10 for all specifications), and configure the number of concurrent users (adjust this value to achieve optimal performance). For SQL Server, enter (local)\SQLEXPRESS. For SQL Server Port, enter 1433. For SQL Server ODBC Driver, select SQL Server Native Client 11.0. For Authentication, select Windows Authentication. For Schema, select Updated. Set Virtual Users to Build Schema to 8.

    Note

    When testing an RDS for SQL Server instance, you must append the port number to the server name. For example: .sqlserver.rds.aliyuncs.com,3433.

  5. Double-click Schema Build/Build.

  6. Click Yes to create the schema.

    A dialog box appears, confirming that a SQL Server TPC-C schema with 10 warehouses will be created in the TPCC database on the host (LOCAL)\SQLEXPRESS:1433.

  7. Wait for the schema initialization to complete.

    On the Virtual User Output tab, Virtual User 1 sequentially displays the messages CREATING TPCC SCHEMA, CREATING DATABASE tpcc, CREATING TPCC TABLES, and Loading Item. The other Virtual Users load warehouse data in parallel. The status table at the bottom shows that all users are running (Complete = 0).

  8. When the initialization is complete for all Virtual Users, click the red stop button to stop the run.

    In the status table, the Complete column for all Virtual Users shows 1. The red stop button is in the upper-left corner of the HammerDB toolbar.

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

  10. In the left-side navigation pane, select Driver Script/Load, as shown in the following figure.

  11. Set the Virtual User parameters. Adjust the number of users based on your instance specification until the database achieves the maximum Transactions Per Minute (TPM), as shown in the following figure.

    Note

    We recommend not selecting the Show Output option. This may cause the client to become unresponsive.

  12. In the left-side navigation pane, select Virtual User/Create, as shown in the following figure.

  13. In the left-side navigation pane, select Transactions/Options, as shown in the following figure.

  14. In the left-side navigation pane, select Transactions/Counter, as shown in the following figure.

  15. In the left-side navigation pane, select Virtual User/Run, as shown in the following figure.

Previous：Test toolNext：Test models