Chapter 4. How to Run an OLTP Workload

Table of Contents


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

This Chapter provides a general overview on the HammerDB OLTP workload and gives you an introduction to conducting OLTP (Online Transaction Processing) workloads on all of the supported databases. This will equip you with the essentials for assessing the ability of any system for processing transactional workloads.