n0derunner

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

Published: (Updated: ) in SQL Server, Testing & Benchmarking, , , by gary. Leave a Comment on How to drop tables for HammerDB TPC-H on SQL Server.

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

Published: (Updated: ) in SQL Server, , by gary.

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 […]

SuperScalin’: How I learned to stop worrying and love SQL Server on Nutanix.

Published: (Updated: ) in SQL Server, , , , by gary. 3 Comments on SuperScalin’: How I learned to stop worrying and love SQL Server on Nutanix..

TL;DR  It’s pretty easy to get 1M SQL TPM running a TPC-C like workload on a single Nutanix node.  Use 1 vDisk for Log files, and 6 vDisks for data files.  SQL Server  needs enough CPU and RAM to drive it.  I used 16 vCPU’s  and 64G of RAM. Running database servers on Nutanix is an […]