HammerDB Documentation

List of Figures

1.1. Verified Publisher

1.2. HammerDB Version

1.3. GPL v3 License

1.4. Choose the Installation Directory

1.5. Files copying

1.6. Complete

1.7. Complete the Setup Wizard

1.8. HammerDB Started

1.9. Zip File

1.10. hammerdb batch file

1.11. Uninstall

1.12. Uninstall database files

1.13. Docker Sponsored OSS

1.14. Docker File Download

1.15. docker build

1.16. Successfully built

1.17. docker run

1.18. IBM client

1.19. Dependencies MySQL

1.20. LIBMYSQL.DLL Properties

1.21. Environment Variables

1.22. Path environment variable

1.23. XML Configuration Files

1.24. Database Files

1.25. Modified Default Database

1.26. Scaling Graphics

1.27. Linux Theme Awlight

1.28. Windows Theme Breeze

1.29. Download Source

1.30. Windows build

2.1. Benchmark Options

2.2. Build Options

2.3. Create Schema

2.4. Building Schema

2.5. Schema build complete

2.6. Driver Options

2.7. Driver Script Loaded

2.8. Virtual User Options

2.9. Virtual Users Created

2.10. Virtual Users Running

2.11. Driver Options

2.12. Virtual Users

2.13. Virtual User and Monitor Created

2.14. Timed Workload Running

2.15. Test Result

2.16. Transaction Counter

2.17. Delete Schema

2.18. Confirm Deletion

2.19. Schema deleted

3.1. WAL Test

3.2. TPROC-C Schema

4.1. ODBC Drivers

4.2. Benchmark Options

4.3. Schema Build Options

4.4. Oracle Build Options

4.5. SQL Server Build Options

4.6. Db2 Build Options

4.7. MySQL Build Options

4.8. MariaDB Build Options

4.9. PostgreSQL Build Options

4.10. Build

4.11. Create Schema

4.12. Schema Build Start

4.13. Schema complete

4.14. Delete Schema Option

4.15. Delete Schema Dialog

4.16. Schema Deleted

4.17. SQL Server in-Memory

4.18. In-memory report

4.19. Driver Script Options

4.20. Driver Script Options

4.21. Use All Warehouses Option

4.22. Use All Warehouses

4.23. Time Profile

4.24. graphical response times

4.25. Excel Warning

4.26. Highlighted Rows

4.27. Response Time Graph

4.28. Asynchronous Options

4.29. Session Count

4.30. Logging In Asynchronous Clients

4.31. Asynchronous Workload Running

4.32. Steady State

4.33. Asynchronous Workload Complete

4.34. Connect Pooling

4.35. XML Connect Pool

4.36. Connections Comment

4.37. Step Test

4.38. Step Load

4.39. No Stored Procedures Option

4.40. Driver Script Loaded

4.41. Virtual User Options

4.42. Virtual User

4.43. Virtual Users Create

4.44. Virtual Users Running

4.45. Virtual Users Complete

5.1. Autopilot Options

5.2. Autopilot Options

5.3. Run Autopilot

5.4. Autopilot Running

5.5. Autopilot Continuing

5.6. Autopilot Complete

5.7. Autopilot Error

6.1. Transaction Counter Options

6.2. Oracle TX Counter Options

6.3. SQL Server TX Counter Options

6.4. Db2 TX Counter Options

6.5. MySQL TX Counter Options

6.6. MariaDB TX Counter Options

6.7. PostgreSQL TX Counter Options

6.8. Start Transaction Counter

6.9. Transaction Counter Starting

6.10. Transaction Counter Running

6.11. Transaction Counter standalone.

6.12. Transaction Counter Window Resize

6.13. Log Transaction Counter Output

7.1. agent.bat

7.2. Security Alert

7.3. Windows agent

7.4. Metrics Options

7.5. Agent Options

7.6. Display

7.7. Agent connected

7.8. Display connected

7.9. Metrics running

7.10. Large Core count

7.11. Oracle Metrics Options

7.12. Oracle Metrics Display Linux

7.13. Oracle Metrics Display Windows

7.14. Oracle Metrics Event

7.15. Oracle Database CPU Metrics

7.16. PostgreSQL Metrics Options

7.17. PostgreSQL Metrics Display Linux

7.18. PostgreSQL Metrics Display Expanded

7.19. PostgreSQL Metrics Event

8.1. Mode

8.2. Mode Options

8.3. Mode Options Select

8.4. Primary Mode Select

8.5. Mode Confirmation

8.6. Mode Active

8.7. Replica Mode

8.8. Primary Distribution

8.9. Operating in Replica Mode

8.10. Replica Mode terminated

9.1. hammerdbcli.bat

9.2. CLI Windows

9.3. CLI Python

10.1. Jobs Option

10.2. Jobs and Web Service Configuration

10.3. Web Service Status

10.4. Running Jobs

10.5. Browse Results

10.6. Job Index

10.7. JSON data

10.8. Result Chart

10.9. Transaction Count

10.10. Response Times

10.11. TPROC-H Timing

11.1. TPROC-H Schema.

11.2. Power Query

11.3. Clustered Columnstore

11.4. Db2 Organize By

11.5. PostgreSQL TPROC-H

11.6. MySQL TPROC-H

11.7. MariaDB TPROC-H

11.8. Redshift console

11.9. Create Security Group

12.1. Max Degree of Parallelism

12.2. Benchmark Options

12.3. TPROC-H Schema Build Options

12.4. Oracle TPROC-H Build Options

12.5. SQL Server Build Options

12.6. Db2 Build Options

12.7. MySQL Build Options

12.8. MariaDB Build Options

12.9. PostgreSQL Build Options

12.10. Build TPROC-H Schema

12.11. Create Schema

12.12. Schema Build Start

12.13. Schema Build Complete

12.14. Backup SQL Server

12.15. Backup successful

12.16. Restore SQL Server

12.17. Restore successful

12.18. Driver Script Options

12.19. TPROC-H Driver Options

12.20. Driver Script Loaded

12.21. Virtual User Options

12.22. Virtual User Options

12.23. Modified Options

12.24. Run a single Virtual User Test

12.25. Single Virtual User Complete

12.26. Power Test Options

12.27. TPROC-H refresh on

12.28. Power Test

12.29. Power Test Complete

12.30. Throughput Test

12.31. Enable Snapshot Isolation

12.32. SQL Server with Snapshot Isolation

12.33. Throughput test complete

13.1. Data Directory

13.2. Benchmark Options

13.3. Datagen Options

13.4. Data Generation Options

13.5. Multiple files

13.6. Generate

13.7. Generate Data Confirmation

13.8. Generating Data

13.9. CPU Utilisation 100%

13.10. Schema Generated

13.11. Pipe Delimited Data

13.12. SQL Server Create Table

13.13. SQL Server Bulk Insert

13.14. Upload to S3

13.15. Postgres User Access Keys

13.16. S3 Permissions

14.1. Doc 39817.1

14.2. Open File

14.3. Trace Loaded

14.4. Convert Trace

14.5. Trace Converted

14.6. Run Trace

14.7. Multiuser Test