Bhakti Hinduja

Hi Steve. This is useful. I was able to validate the result shown by HammerDB using select cntr_value from sys.dm_os_performance_counters where counter_name = 'Batch Requests/sec' But the Tx counter value still seems different. How can i get intermediate values to print a nice graph for the run? The Tx counter matches the SQL Server statistics perfmon counter. Can you help debug this more? I can setup a meeting to discuss more. Thanks!

Hello I am using TPCC HammerDB 3.2 on a windows client (Driver 17) with SQL server 2017. I am seeing different values reported by HammerDB results in virtual user output(5.5M) but the Tx counter reports a different TPM (3.3M). The delta between the two values is huge. I also veriffied the counter batch requests/sec from SQL Statistics in Perfmon, it matches the value of the Tx counter. In this case what is the correct TPM for my test? Thank you

Hello, is there a way to log out the output when you run in the transaction counter mode? I want to log out timestamp and TPM?

Hi, I am trying to run SQL server in a 64vpu cloud instance with hammerdb (master-slave model -1 slave), with 1024 virtual users each. I see two different TPMs and NOPMs on the master and salve. Please let me know how can I aggregate the TPM and NOPM for a master slave config. Thanks!