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 for your database software. These options vary depending on the database chosen. Select a number of warehouses. 10 is a good value for a first test, and set the virtual users for schema build 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 Build in the tree view. You will receive a prompt confirming 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