Use the following SQL to drop the tables and indexes in the HammerDB TPC-H schema, so that you can re-load it.
Read More →Tag: 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…
Read More →How to avoid bottlenecks in the client generator when measuring database performance with HammerDB
Read More →