Chapter 7. System Discovery, CPU, I/O and Database Metrics

Table of Contents

1. Start the Agent Manually
2. Configure Metrics Manually
3. Configure Metrics Automatically
4. Monitor Metrics
5. Viewing Job Metrics Data
6. Oracle Database Metrics - Active Session History
7. PostgreSQL Database Metrics - Active Session History
8. MySQL and MariaDB Database Metrics

HammerDB has a built in operating system agent that discovers the system configuration and monitors CPU and I/O activity on both Windows and Linux.

By default HammerDB metrics displays the CPU utilisation per core across the target system. HammerDB has also introduced a database metrics display for the Oracle, PostgreSQL, MySQL and MariaDB Databases based on their Active Session History feature. The user has the option to run CPU and I/O metrics only or the full Active Session History. HammerDB Metrics uses an agent and display configuration meaning that the agent must be installed on the SUT. This can be accomplished by installing HammerDB or just the agent (and mpstat on Windows) on the SUT as well as the server. When HammerDB is run on the SUT there is also functionality to start the agent and display at the same time. On Linux the sysstat package must be pre-installed where the agent is running. On Windows HammerDB includes a Windows API. An agent on Linux can communicate with the HammerDB display running on Windows and vice versa.

$ mpstat -V
sysstat version 12.5.2
(C) Sebastien Godard (sysstat <at> orange.fr

On Windows a version of mpstat is included with HammerDB.