Test tool
HammerDB is an open source benchmarking and load testing tool for databases. Use it to test the performance of an ApsaraDB RDS for SQL Server instance by running TPC-C-compliant workloads that simulate concurrent OLTP transactions.
HammerDB overview
HammerDB runs on Linux and Windows and supports a wide range of database systems, including Oracle, SQL Server, Db2, TimesTen, MySQL, MariaDB, PostgreSQL, Greenplum, Postgres Plus Advanced Server, Redis, and Apache Trafodion.
Key capabilities:
| Capability | Description |
|---|---|
| Automated testing | Run tests without manual intervention. |
| Multithreaded support | Simulate concurrent workloads across multiple threads. |
| Dynamic scripts | Customize test behavior at runtime using Tcl scripts. |
| Extensions | Extend built-in test scenarios to fit your environment. |
HammerDB includes a built-in baseline load that is compliant with the TPC-C benchmark standard.
Install HammerDB
The following steps use HammerDB 2.19 as an example.
Before you begin, ensure that you have:
An ApsaraDB RDS for SQL Server instance that is running and accessible
The host name (or endpoint), port, and login credentials for your RDS instance
A Windows or Linux machine from which to run HammerDB
To install HammerDB:
Download HammerDB 2.19 from the HammerDB download page.
Run the installer and complete the installation wizard. Accept the license agreement and choose an installation directory when prompted.
After installation completes, the following window appears.
