8. Logging Transaction Counter Output

HammerDB also provides the option to log the output of the transaction counter to a separate logfile. This enables the recording of transactions throughout the test that can be used to verify the transaction rate across time. To enable transaction counter logging select Log Output to Temp. There are also options to use a unique log name and to generate timestamps. With the following options selected.

Figure 6.12. Log Transaction Counter Output

Log Transaction Counter Output

The following output in a logfile called hdbtcount.log will be produced in the defined temporary directory.

Hammerdb Transaction Counter Log @ Mon Apr 12 15:06:00 BST 2021
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+
0 MSSQLServer tpm @ Mon Apr 12 15:06:03 BST 2021
317814 MSSQLServer tpm @ Mon Apr 12 15:06:13 BST 2021
316860 MSSQLServer tpm @ Mon Apr 12 15:06:23 BST 2021
300186 MSSQLServer tpm @ Mon Apr 12 15:06:33 BST 2021
298410 MSSQLServer tpm @ Mon Apr 12 15:06:44 BST 2021
282222 MSSQLServer tpm @ Mon Apr 12 15:06:54 BST 2021
275118 MSSQLServer tpm @ Mon Apr 12 15:07:04 BST 2021
263574 MSSQLServer tpm @ Mon Apr 12 15:07:14 BST 2021
283950 MSSQLServer tpm @ Mon Apr 12 15:07:24 BST 2021
276912 MSSQLServer tpm @ Mon Apr 12 15:07:34 BST 2021
278562 MSSQLServer tpm @ Mon Apr 12 15:07:44 BST 2021
272130 MSSQLServer tpm @ Mon Apr 12 15:07:54 BST 2021
269208 MSSQLServer tpm @ Mon Apr 12 15:08:05 BST 2021
290556 MSSQLServer tpm @ Mon Apr 12 15:08:15 BST 2021
245502 MSSQLServer tpm @ Mon Apr 12 15:08:25 BST 2021
278718 MSSQLServer tpm @ Mon Apr 12 15:08:35 BST 2021
279438 MSSQLServer tpm @ Mon Apr 12 15:08:45 BST 2021
245094 MSSQLServer tpm @ Mon Apr 12 15:08:55 BST 2021
267156 MSSQLServer tpm @ Mon Apr 12 15:09:05 BST 2021
278580 MSSQLServer tpm @ Mon Apr 12 15:09:15 BST 2021
260592 MSSQLServer tpm @ Mon Apr 12 15:09:25 BST 2021
290712 MSSQLServer tpm @ Mon Apr 12 15:09:36 BST 2021
275400 MSSQLServer tpm @ Mon Apr 12 15:09:46 BST 2021
304038 MSSQLServer tpm @ Mon Apr 12 15:09:56 BST 2021
302268 MSSQLServer tpm @ Mon Apr 12 15:10:06 BST 2021
251604 MSSQLServer tpm @ Mon Apr 12 15:10:16 BST 2021
256410 MSSQLServer tpm @ Mon Apr 12 15:10:26 BST 2021
273306 MSSQLServer tpm @ Mon Apr 12 15:10:36 BST 2021

Equivalent functionality exists in the CLI to enable transaction counter logging with the tcset command.