Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [hammerdb]

Use this tag for questions about the HammerDB database load testing and benchmarking tool.

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, multi-threaded and extensible with dynamic scripting support.

HammerDB is supported on Oracle, SQL Server, DB2, TimesTen, PostgreSQL, Greenplum, Postgres Plus Advanced Server, MySQL, Redis and Trafodion SQL on Hadoop.

5 questions
2
votes
2 answers

SQL Server benchmarking HammerDb TPM = 0

I'm trying to use HammerDb 3.0 to get a baseline to compare my servers. I can create the Db, schema, data and items required no problem. I can execute the test and see that it's running. When the script completes it give me a NOPM number but says…
Sir Swears-a-lot
  • 3,253
  • 3
  • 30
  • 48
0
votes
1 answer

DB2 AS400, Hammer DB setup issue

I am working with Hammer DB to connect to remote DB2 AS400. However, I am running into issue in build schema. [IBM][CLI Driver][AS] SQL0204N "QSYS.ANAND" is an undefined name. SQLSTATE=42704 user ANAND is present as I am able to connect to it…
Anand
  • 3
  • 3
0
votes
2 answers

HammerDB says about 0 Oracle TPM

Have a good day, guys and girls!) Using HammerDB for Oracle benchmarking, I have this connection settings: diset connection instance IP_of_server:1521/XEPDB1 ... this messages from start and end snapshots: Vuser 1:Start Snapshot 30 taken at 06…
user254908
0
votes
1 answer

Oracle XE fails on HammerDB benchmark

I have Oracle XE 21c and HammerDB 4.4. The task is to benchmark database. Oracle Database 21c Express Edition Release 21.0.0.0.0 - Production Version 21.3.0.0.0 Well, because of that I've done the command below after 'sqlplus…
user254908
0
votes
1 answer

Is it possible to generate workload for hammerora (hammerdb for oracle) from AWR tables?

I'm trying to generate workload from our production databases but rather than running a trace file in production, I would prefer using the AWR tables since we have a license for it. Is it possible? Thank you.
Nicolas de Fontenay
  • 1,875
  • 2
  • 18
  • 37