Help Center/ SAP Cloud/ Best Practices/ Best Practice of SAP Disaster Recovery with SDRS/ SDRS Performance Test/ HammerDB Performance Test
Updated on 2023-05-29 GMT+08:00
View PDF
Share

HammerDB Performance Test

HammerDB is a graphical open-source database load testing and benchmarking tool for Linux and Windows to test databases running on any operating system. HammerDB is automated, multithreaded, and extensible with dynamic scripting support. You can use HammerDB to create a test schema, load data, and simulate the database workload of multiple virtual users in online transaction processing (OLTP) and online analytical processing (OLAP) scenarios.

HammerDB 3.3 is used in this document. Download HammerDB of the latest version.

  1. Click Enable Protection on the Storage Disaster Recovery Service page.

  2. Install and run the HammerDB performance test tool. For details, see Test Method.

  3. Select SQL Server and TORPC-C and click OK.

  4. Choose SQL Server > TPROC-C > Schema Build, and double-click Options to configure parameters. Configure SQL Server, SQL Server ODBC Driver, Number of Warehouses, Virtual Users to Build Schema, and click OK.

  5. Double-click Build and click Yes.

  6. Wait until the schema is created. The duration depends on the number of warehouses and schemata.

  7. Click the stop button.

  8. Choose Driver Script, double-click Options to confirm the parameters, and click OK.

  9. Double-click Load.

  10. Choose Virtual User and double-click Options. In the Virtual User Options dialog box, set Virtual Users to the number of virtual users, that is, 20 in this test, deselect Show Output, and click OK.

  11. Double-click Run.

  12. Click the icon for starting transactions.

  13. Wait until the TPM reaches the peak value.

  14. Disable SDRS protection.

  15. Test the HammerDB performance again.

  16. Continue the HammerDB performance test until the TPM peak value is stable.

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

Conclusion: By comparing the TPM values before and after SDRS protection is enabled, performance of the SQL Server database decreases by about 3.39% after SDRS protection is enabled.

Parent topic: SDRS Performance Test