Tag: sqlserver

How to drop tables for HammerDB TPC-H on SQL Server

By: gary Date: June 9, 2020 Categories: SQL Server,Testing & Benchmarking Tags: hammerDB, sqlserver, tpc-h

Use the following SQL to drop the tables and indexes in the HammerDB TPC-H schema, so that you can re-load it.

SQL Server uses only one NUMA Node with HammerDB

By: gary Date: October 7, 2019 Categories: SQL Server Tags: hammerDB, sqlserver

Some versions of HammerDB (e.g. 3.2) may induce imbalanced NUMA utilization with SQL Server. This can easily be observed with Resource monitor. When NUMA imbalance occurs one of the NUMA nodes will show much larger utilization than the other. E.g. The cause and fix is well documented on this blog. In short HammerDB issues a…

HammerDB: Avoiding bottlenecks in client.

By: gary Date: October 4, 2019 Categories: Databases,Testing & Benchmarking Tags: benchmarking, database, hammerDB, sqlserver

HammerDB is a great tool for running Database benchmarks. However it is very easy to create an artificial bottleneck which will give a very poor benchmark result. When setting up HammerDB to run against even a moderate modern server, it is important to avoid displaying the client transaction outputs in the HammerDB UI. In my…