SQL Server benchmarking HammerDb TPM = 0

Sir Swears-a-lot 08/16/2018. 2 answers, 73 views
sql-server hammerdb

I'm trying to use HammerDb 3.0 to get a baseline to compare my servers.

I can create the Db, schema, data and items required no problem. I can execute the test and see that it's running.

When the script completes it give me a NOPM number but says TPM is zero. When it's running the Transaction counter doesn't graph anything either.

Is this a known or common problem?

enter image description here

2 Answers


user131743 08/20/2018.

The size of the value returned from the query is the issue. HammerDB is using the TCL command "string is integer" to check the value returned from SQL Server. This command checks for a 32-bit integer and as your value exceeds this is returning an error. To correct this in the graphical transaction counter from the home directory edit the file in src\mssqlserver\mssqlsotc.tcl and find and change the line "string is integer" to "string is entier", it will look like this:

if { [ string is entier -strict $tc_trans ] } {

Similarly to correct this in the output of the OLTP/TPC-C test

edit the file in src\mssqlserver\mssqlsoltp.tcl

if { [ string is entier -strict $end_trans ] && [ string is entier -strict $start_trans ] } {

This will permit the larger values to be displayed.


user131743 08/16/2018.

The error is in the output as "SQL Server returned non-numeric transaction count data". TPM is the same as the transaction count in the SSMS activity monitor ie "Batches/sec". NOPM is queried directly from the schema under test. (TPM is a database specific metric NOPM is database independent). It appears that workload is running OK but SQL Server is not returning transaction counter data. The first thing to check is whether SQL Server has been started with the "-X" option. This disables all performance statistics and would result in this effect. Secondly run the following SQL:

select cntr_value from sys.dm_os_performance_counters where counter_name = 'Batch Requests/sec'

This is what HammerDB runs (you can see it i nthe source code) - when this query works HammerDB should be able to monitor and report transactions.

For saving details more information is required.


HighResolutionMusic.com - Download Hi-Res Songs

1 The Chainsmokers

Beach House flac

The Chainsmokers. 2018. Writer: Andrew Taggart.
2 (G)I-DLE

POP/STARS flac

(G)I-DLE. 2018. Writer: Riot Music Team;Harloe.
3 Ariana Grande

​Thank U, Next flac

Ariana Grande. 2018. Writer: Crazy Mike;Scootie;Victoria Monét;Tayla Parx;TBHits;Ariana Grande.
4 Anne-Marie

Rewrite The Stars flac

Anne-Marie. 2018. Writer: Benj Pasek;Justin Paul.
5 Clean Bandit

Baby flac

Clean Bandit. 2018. Writer: Jack Patterson;Kamille;Jason Evigan;Matthew Knott;Marina;Luis Fonsi.
6 Nicki Minaj

No Candle No Light flac

Nicki Minaj. 2018. Writer: Denisia “Blu June” Andrews;Kathryn Ostenberg;Brittany "Chi" Coney;Brian Lee;TJ Routon;Tushar Apte;ZAYN;Nicki Minaj.
7 BlackPink

Kiss And Make Up flac

BlackPink. 2018. Writer: Soke;Kny Factory;Billboard;Chelcee Grimes;Teddy Park;Marc Vincent;Dua Lipa.
8 Imagine Dragons

Bad Liar flac

Imagine Dragons. 2018. Writer: Jorgen Odegard;Daniel Platzman;Ben McKee;Wayne Sermon;Aja Volkman;Dan Reynolds.
9 BTS

Waste It On Me flac

BTS. 2018. Writer: Steve Aoki;Jeff Halavacs;Ryan Ogren;Michael Gazzo;Nate Cyphert;Sean Foreman;RM.
10 Halsey

Without Me flac

Halsey. 2018. Writer: Halsey;Delacey;Louis Bell;Amy Allen;Justin Timberlake;Timbaland;Scott Storch.
11 Little Mix

Woman Like Me flac

Little Mix. 2018. Writer: Nicki Minaj;Steve Mac;Ed Sheeran;Jess Glynne.
12 Brooks

Limbo flac

Brooks. 2018.
13 Fitz And The Tantrums

HandClap flac

Fitz And The Tantrums. 2017. Writer: Fitz And The Tantrums;Eric Frederic;Sam Hollander.
14 Backstreet Boys

Chances flac

Backstreet Boys. 2018.
15 Lady Gaga

I'll Never Love Again flac

Lady Gaga. 2018. Writer: Benjamin Rice;Lady Gaga.
16 Diplo

Close To Me flac

Diplo. 2018. Writer: Ellie Goulding;Savan Kotecha;Peter Svensson;Ilya;Swae Lee;Diplo.
17 Rita Ora

Velvet Rope flac

Rita Ora. 2018.
18 Bradley Cooper

Always Remember Us This Way flac

Bradley Cooper. 2018. Writer: Lady Gaga;Dave Cobb.
19 Imagine Dragons

Machine flac

Imagine Dragons. 2018. Writer: Wayne Sermon;Daniel Platzman;Dan Reynolds;Ben McKee;Alex Da Kid.
20 Erika Sirola

Speechless flac

Erika Sirola. 2018. Writer: Teemu Brunila;Stefan Dabruck;Jürgen Dohr;Guido Kramer;Dennis Bierbrodt;Chris Braide;Robin Schulz.

Related questions

Hot questions

Language

Popular Tags