7. Configure Virtual Users

Select Virtual User Options from the tree-view.

Figure 11.20. Virtual User Options

Virtual User Options

This displays the Virtual User Options dialog. For Analytic workloads it is recommended that only one Virtual User is selected for initial testing. If you wish to see the times for individual queries rather than just the query set you will also need to write to the log.

Figure 11.21. Virtual User Options

Virtual User Options

The values have the following meaning.

Table 11.7. Virtual User Options

OptionDescription
Virtual UsersThe number of Virtual Users to create. Note that when running a Timed Workload HammerDB will automatically create an additional Virtual User to monitor the workload.
User Delay(ms)User Delay(ms) defines the time to wait a Virtual User will wait behind the previous Virtual User before starting its test, this is to prevent a login storm with all Virtual Users attempting to login at the same time.
Repeat Delay(ms)Repeat Delay(ms) is the time that each Virtual User will wait before running its next Iteration of the Driver Script. For TPC-H this is an external loop before running another query set, however should not be more than 1 when the refresh function is enabled.
IterationsIterations is the number of times that the Driver Script is run in its entirety.
Show OutputShow Output will report Virtual User Output to the Virtual User Output Window, For TPC-H tests this should be enabled.
Log Output to TempWhen enabled this appends all Virtual User Output to a text file in an available temp directory named hammerdb.log
Use Unique Log NameUse a unique identifier for the Log Name.
No Log BufferBy default text log output is buffered in memory before being written, this option writes the log output immediately.
Log TimestampsAdd an additional line of output with a timestamp every time that the log is written to.


Select the Virtual User options, Press OK.