Chapter 4. How to Run a TPROC-C Workload

Table of Contents

1. Test Network Configuration
1.1. SUT Database Server Configuration
1.2. Load Generation Server Configuration
1.3. CPU Single-Threaded Performance Calibration
1.4. Administrator PC Configuration
2. Installation and Configuration
2.1. Oracle
2.2. Microsoft SQL Server
2.3. Db2
2.4. MySQL
2.5. PostgreSQL
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
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
5. Configuring Driver Script options
6. Advanced Driver Script Options
6.1. Use All Warehouses for increased I/O
6.2. Time Profile for measuring Response Times
6.3. Event Driven Scaling for Keying and Thinking Times
6.4. XML Connect Pool for Cluster Testing
6.5. Step Testing with Variable Load
7. Additional Driver Script Options for Stored Procedures and Server Side Reports: PostgreSQL, MySQL, Oracle, Db2 and EnterpriseDB PostgreSQL
7.1. PostgreSQL Stored Procedures
7.2. MySQL Prepare Statements
7.3. Oracle AWR Reports
7.4. Db2 MONREPORT
7.5. EnterpriseDB PostgreSQL DRITA
8. Loading the Driver Script
9. Configure Virtual Users
10. Create and Run Virtual Users

This Chapter provides a general overview on the HammerDB TPROC-C 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.