A Misleading Error While Testing HammerDB On Hekaton

Safe Words

This a short post about a sort of quirky error message I got while trying to run the TPC-C load test against SQL Server’s in-memory tables.

Error in Virtual User1: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The integer value XXXXXXXXXXXX is out of range.


A few of the tables would get created, but not all of them. It wasn’t obvious where that number was coming from, until I thought back to the setup.

In the build script, there’s a helpful looking line for you to adjust the hash bucket count that your indexes get created with.

tinker tailor

I had set mine to a higher number, thinking it would help load speeds to have a bunch of buckets ready in there.

But the thing is, buried way down in the script, there’s already some math to pad the hash buckets for you.

the salty bucket

If you’re in the mood to be totally underwhelmed, you should also run this test against Hekaton.

Thanks for reading!

A Word From Our Sponsors

First, a huge thank you to everyone who has bought my training so far. You all are incredible, and I owe all of you a drink.

Your support means a lot to me, and allows me to do nice stuff for other people, like give training away for free.

So far, I’ve donated $45k (!!!) worth of training to folks in need, no questions asked.

Next year, I’d like to keep doing the same thing. I’d also like to produce a whole lot more training to add value to the money you spend. In order to do that, I need to take time off from consulting, which isn’t easy to do. I’m not crying poor, but saying no to work for chunks of time isn’t easy for a one-person party.

I’m hoping that I can make enough in training bucks to make that possible.

Because this sale is extra sale-y, I’ve decided to name it after the blackest black known to man.

From today until December 31st, you can get all 25 hours of my recorded training content for just $100.00. If you click the link below to add everything to your cart, and use the discount code AllFor100 to apply a discount to your cart.




Some fine print: It only works if you add EVERYTHING. It’s a fixed amount discount code that you need to spend a certain amount to have kick in.

Thank for reading, and for your support.

2 thoughts on “A Misleading Error While Testing HammerDB On Hekaton

  1. Finally got around to running HammerDB 4.1
    Tried the flashy Hekaton switch and it failed to create the tables at your hash buckets value of 64 above
    1 works just fine

    I think ill call Hekaton “όχι εκατόn”
    Or, in the immortal word of Riddick “Not Furya”

    My Disk-Based Database score on a HP Z5 was [388,000]
    Hekaton on the same hardware was [45,500 to about 90,000] – Jamie’s Cryin’
    On an Azure SQL G5 8Core 32GB 200GB instance (the default): [33,402] 10x slower- Not Gonna Cloud much

    Plus on Hekaton, I got lots of error 701 – not enough memory to run this query

Leave a Reply

Your email address will not be published. Required fields are marked *