A preview is not available for this record, please engage by choosing from the available options ‘download’ or ‘view’ to engage with the material
Description
This document provides guidance for setting up and running the HammerDB benchmark on Oracle Database within a VMware vSphere and VMware vSAN environment, to replicate Intel’s performance testing and results.
The benchmarking environment consists of five servers, divided into two categories, test and support. The benchmarking process consists of the following steps:
- Prepare the VMware Environment. The VMware environment consists of a vCenter Server Appliance (VCSA), ESXi hosts (hypervisors), vSAN and VMs. It is assumed that the reader has experience with VMware deployments; this document focuses primarily on preparing vSAN and the VMs. Deployment of the VCSA, networking and installation of ESXi are not covered in detail.
- Prepare the Oracle Environment. The Oracle environment consists of the OEL OS, Oracle Grid, ASM and Oracle Database. It is assumed the reader has experience installing and configuring OEL, and while briefly covered, the primary focus is on Oracle Grid and Database configurations.
- Prepare the HammerDB Environment. HammerDB can test many different databases with TPC-C or TPC-H-inspired benchmarks (TPROC-C and TPROC-H, respectively). This section covers the installing HammerDB, configuring to connect to Oracle Databases and building TPROC-C schema on Oracle Databases.
- Execute the Benchmark. Execute the TPROC-C benchmark from the GUI or the CLI. The testing performed in this guide used PowerShell and the HammerDB CLI to automate repeated testing in a controlled and repeatable fashion.
For customers, please share this link.