Figure 2.1. Benchmark Options

Click on the Benchmark tree view, under TPROC-C select TPROC-C Schema Build Options to display the TPROC-C Schema Options window. Within this window enter the connection details of your database software. These options will vary depending on the database chosen. Select a number of warehouses, 10 is good for a first test and set the Virtual Users to build schema to the number of CPU cores on your system. Click OK.

Figure 2.2. Build Options Connections

Figure 2.3. Build Options Settings

Double-click on Build in the tree view and you will receive a prompt on the settings chosen to build the schema. Click Yes.

Figure 2.4. Create Schema

Observe that HammerDB begins to build the schema with multiple users.

Figure 2.5. Building Schema

Wait until the schema build completes and then click on the red button, tagged with Destroy Virtual Users.

Figure 2.6. Schema build complete