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.
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.
If you’re in the mood to be totally underwhelmed, you should also run this test against Hekaton.
Thanks for reading!
If this is the kind of SQL Server stuff you love learning about, you’ll love my training. I’m offering a 75% discount on to my blog readers if you click from here. I’m also available for consulting if you just don’t have time for that and need to solve performance problems quickly.