The first test established a baseline by running an OLTP database workload that we generated by using a TPC-C-like benchmark on both the Oracle and SQL Server databases. Note that a “TPC-C–like” benchmark means that the test results are not certified. The TPC-C Benchmark is a complex OLTP workload. OLTP workloads simulate enterprise applications that businesses use to manage all operational processes. We used the popular HammerDB tool to generate the TPC-C-like workload.

For the OLTP use case test, we ran one Oracle database and two SQL Server databases in parallel to generate an OLTP workload on the system. The performance metrics we captured serve as a baseline to determine how other workloads impact the OLTP workload. The configuration of the TPC-C OLTP workload is shown in the following table:

Table 3.           TPC-C–like benchmark configuration for OLTP workload use case