Documentation

Documentation Index

Table of Contents

1. Installation Guide
1. HammerDB v3.3 New Features
2. Test Matrix
3. Checksum Verification
4. Installing and Starting HammerDB on Windows
4.1. Self Extracting Installer
4.2. Zip File
4.3. Starting HammerDB
4.4. Uninstalling HammerDB
5. Installing and Starting HammerDB on Linux
5.1. Self Extracting Installer
5.2. Tar.gz File
5.3. Starting HammerDB
5.4. Uninstalling HammerDB
6. Verifying Client Libraries
6.1. Oracle Client
6.2. SQL Server
6.3. Db2
6.4. MySQL
6.5. PostgreSQL
6.6. Redis
2. Quick Start
1. Building the Schema
2. Run a Test Workload
3. Run a Timed Workload
4. Using the Transaction Counter
3. Introduction to OLTP Testing (TPC-C)
1. What is a Transactional Workload
2. What is the TPC and TPC-C?
3. HammerDB Transactional TPC-C based workloads
4. Comparing HammerDB results
5. Understanding the TPC-C workload
6. Generating Performance Profiles
7. Generating Time Profiles
8. Publishing database performance results
4. How to Run an OLTP Workload
1. Test Network Configuration
1.1. SUT Database Server Configuration
1.2. Load Generation Server Configuration
1.3. Administrator PC Configuration
2. Installation and Configuration
2.1. Oracle
2.2. Microsoft SQL Server
2.3. Db2
2.4. MySQL
2.5. PostgreSQL
2.6. Redis
3. Configuring Schema Build Options
3.1. Oracle Schema Build Options
3.2. Microsoft SQL Server Schema Build Options
3.2.1. In-Memory Optimized Tables
3.2.2. Build Options
3.3. Db2 Schema Build Options
3.4. MySQL Schema Build Options
3.5. PostgreSQL Schema Build Options
3.6. Redis Schema Build Options
4. Creating the Schema
4.1. Deleting or Verifying the Oracle Schema
4.2. Deleting or Verifying the SQL Server Schema and In-memory Schema
4.3. Deleting or Verifying the Db2 Schema
4.4. Deleting or Verifying the MySQL Schema
4.5. Deleting or Verifying the PostgreSQL Schema
4.6. Deleting or Verifying the Redis Schema
5. Configuring Driver Script options
6. Additional Driver Script Options for Server Side Reports: Oracle, Db2 and EnterpriseDB PostgreSQL
6.1. Oracle AWR Reports
6.2. Db2 MONREPORT
6.3. EnterpriseDB PostgreSQL DRITA
7. Loading the Driver Script
8. Configure Virtual Users
9. Create and Run Virtual Users
5. Autopilot
1. Configure and Run Autopilot
2. Autopilot Troubleshooting
3. Extending Autopilot
6. Transactions
1. Oracle Transaction Counter
2. SQL Server Transaction Counter
3. Db2 Transaction Counter
4. MySQL Transaction Counter
5. PostgreSQL Transaction Counter
6. Redis Transaction Counter
7. Running the Transaction Counter
7. CPU and Database Metrics
1. Start the Agent
2. Configure Metrics
3. Monitor Metrics
4. Oracle Database Metrics
8. Command Line Interface (CLI)
1. Start the CLI
2. CLI Commands
3. Configure Schema Build
4. Building the Schema
5. Configure Driver
6. Configure Virtual Users
7. Run the workload
8. CLI Scripting
9. Web Service Interface (WS)
1. Web Service Configuration
2. Starting the Web Service and Help Screen
3. Retrieving Output
4. Running Jobs
5. Query Job Output
10. Introduction to Analytic Testing (TPC-H) and Cloud Queries
1. What is TPC-H?
2. Running the Power and Throughput Test and Calculating the Geometric Mean
3. Choosing a Database for running TPC-H workloads
3.1. Oracle
3.2. Microsoft SQL Server
3.3. Db2
3.4. PostgreSQL
3.5. MySQL / MariaDB
3.6. Redis
4. Benchmarking Database Cloud Services
4.1. Redshift Cloud Analytic Workload
11. How to Run an Analytic Workload
1. SUT Database Server Configuration
2. Installation and Configuration
2.1. Oracle
2.2. SQL Server
2.3. Db2
2.4. PostgreSQL
2.5. MySQL / MariaDB
3. Configuring Schema Build Options
3.1. Oracle Schema Build Options
3.2. SQL Server Schema Build Options
3.3. Db2 Schema Build Options
3.4. MySQL Schema Build Options
3.5. PostgreSQL Schema Build Options
4. Creating the Schema
4.1. Verifying and Backing-Up the Oracle Schema
4.2. Verifying and Backing Up the SQL Server Schema
4.3. Verifying and Backing up the Db2 Schema
4.4. Verifying and Backing up the MySQL Schema
4.5. Verifying and Backing up the PostgreSQL Schema
5. Configuring Driver Script Options
6. Loading the Driver Script
7. Configure Virtual Users
8. Run a Single Virtual User Test
8.1. Changing the Query Order
9. Run a Power Test
10. Run a Throughput Test
10.1. SQL Server Snapshot Isolation
11. Calculate the Geometric Mean
12. Remote Modes
1. Master Mode
2. Slave Mode
3. Master Distribution
13. Generating and Loading Bulk Datasets
1. Generate the Dataset
2. Generate the Dataset with the CLI
3. Generate the template database
3.1. Capture and run the table creation DDL
3.1.1. Oracle
3.1.2. SQL Server
3.1.3. Db2
3.1.4. MySQL
3.1.5. PostgreSQL/Amazon Redshift
4. Run the bulk data load
4.1. Oracle
4.2. SQL Server
4.3. Db2
4.4. MySQL
4.5. PostgreSQL/Amazon Redshift
14. Oracle Trace File Replay
1. Generating Trace Files
2. Converting Oracle Trace Files
3. Replaying Oracle Trace Files
4. Capturing Errors from Trace File Workloads
15. Copyright

Updated November 2019  •