TPC-Council / HammerDB

HammerDB Database Load Testing and Benchmarking Tool
http://www.hammerdb.com
GNU General Public License v3.0
589 stars 119 forks source link

Add database version number to job db command for TPROC-C timed tests #684

Closed sm-shaw closed 6 months ago

sm-shaw commented 6 months ago

Is your feature request related to a problem? Please describe. Currently the jobs repository stores the database type from the database setting in HammerDB, however there is no way to susequently query the database version for a timed test that was run.

Describe the solution you'd like For a timed test, query the database version from the monitor vuser so that the version number is in the output. This can then be retrieved and displayed when the database is queried with the job db command or in the webservice. For example:

hammerdb>job 6601BCF63E8403E263532363 db
[
 "MSSQLServer",
 "16.0.1000.6"
]

For other jobs it will continue just to display the HammerDB database name:

hammerdb>job 6601BC06B00403E203936343 db
["MSSQLServer"]

Describe alternatives you've considered As the version number is most relevant to a timed test, this should be stored initially just for TPROC-C timed tests with potential to extend to TPROC-H at a later point.

Additional context Add any other context or screenshots about the feature request here.