Skip to content

HammerDB — Database Benchmarking ​

Tool: HammerDBStatus: Not proven on hardware

NOTE

Status: implemented and unit-tested, not proven on hardware. See the implementation status table. Command examples on this page show the intended workflow; the param block of each script is the authority for parameter names. Not proven on a live cluster.

HammerDB benchmarks SQL Server performance on Azure Local VMs using industry-standard TPC-C (OLTP) and TPC-H (OLAP) workloads. It measures transactions per minute (TPM) and new orders per minute (NOPM).


Run This Test ​

Prerequisites ​

  • SQL Server instance deployed on an Azure Local VM
  • HammerDB installed on the management station or target VM
  • WinRM access to the target VM
  • Framework prerequisites completed

Step 1 — Install HammerDB on the target VM ​

powershell
.\tools\hammerdb\scripts\Install-HammerDB.ps1 `
    -ClusterName "hci01.corp.infiniteimprobability.com" `
    -Nodes @("hci01-node1")

Step 2 — Run the TPC-C benchmark ​

powershell
.\tools\hammerdb\scripts\Start-HammerDBTest.ps1 `
    -ClusterName "hci01.corp.infiniteimprobability.com" `
    -PrimaryNode "hci01-node1" `
    -Profile "tpc-c" `
    -Warehouses 100 `
    -VirtualUsers 16

Step 3 — Collect results ​

powershell
.\tools\hammerdb\scripts\Collect-HammerDBResults.ps1 `
    -ClusterName "hci01.corp.infiniteimprobability.com" `
    -PrimaryNode "hci01-node1" `
    -RunId "<run-id-from-previous-step>"

Step 4 — Stop the test (if needed) ​

powershell
.\tools\hammerdb\scripts\Stop-HammerDBTest.ps1 `
    -ClusterName "hci01.corp.infiniteimprobability.com" `
    -PrimaryNode "hci01-node1"

When to Use HammerDB ​

ScenarioHammerDB
Validate SQL Server OLTP performance✅
TPC-C transaction benchmarking✅
TPC-H analytics query benchmarking✅
Combined storage + compute validation✅
Database sizing and capacity planning✅

Key Capabilities ​

  • TPC-C (TPROC-C) — OLTP transaction processing simulation
  • TPC-H (TPROC-H) — Decision support / analytics query workload
  • Supports SQL Server, PostgreSQL, MySQL, Oracle, and more
  • GUI, CLI, and web interfaces for flexibility
  • Docker images available for reproducible CI/CD runs

What You Get ​

After a test completes, you will have:

  • NOPM (New Orders Per Minute) — the primary TPC-C metric
  • TPM (Transactions Per Minute) — total throughput
  • TPC-H query times for analytics workloads
  • Reports in PDF, DOCX, and/or XLSX format

File Locations ​

ComponentPath
Scriptstools/hammerdb/scripts/
Workload Profilestools/hammerdb/config/profiles/
Alert Rulestools/hammerdb/monitoring/alert-rules.yml
Report Templatestools/hammerdb/reports/templates/
Teststools/hammerdb/tests/
Logstools/hammerdb/logs/

Deep Dive ​

TopicPage
Installation via PowerShell remotingInstallation
TPC-C and TPC-H profile configurationWorkload Profiles
Alert rules during test runsMonitoring
Report formats and templatesReporting
Common errors and fixesTroubleshooting

Automate This Test ​

To run HammerDB on a schedule or as part of a CI/CD workflow, see CI/CD Pipelines. The pipeline calls the same scripts listed above.

Released under the MIT License.