HammerDB configuration and settings are defined in a number of XML files in the config directory. You may edit these files to change the configuration on startup, however it is recommended to save a copy of the original in case of incompatible changes.
Figure 1.16. XML Configuration Files
By default the databases in the GUI menu are listed in the order that the workloads were added to HammerDB. If you wish to change the order to put a particular database first you can change the rdbms value in generic.xml to the name of the database of your choice. The name entry for a particular database can be found in the database.xml file. For example the following would set SQL Server to be the database at the top of the menu.
<benchmark> <rdbms>MSSQLServer</rdbms> <bm>TPC-C</bm> <first_result>NOPM</first_result> </benchmark>
On startup SQL Server is shown first and already selected meaning it is not required to switch to a preferred database from the default choice.
Figure 1.17. Modified Default Database
Similarly it also possible to change the default workload to TPROC-H by modifying the bm value to TPC-H.