2 min read
0
Notes on tuning postgres for cpu and memory benchmarking
Recently I wanted to measure the impact of NUMA placement and Hugepages on the performance of postgres running in a…
Tag: hammerDB
1 min read
0
A Nutanix / Prometheus exporter in bash
Overview For a fun afternoon project, how about a retro prometheus exporter using Apache/nginx, cgi-bin and bash!? About prometheus format…
1 min read
0
Database sizes for HammerDB TPC-C/ SQLserver
The on disk size for small DB sizes. Taken from SQLserver properties immediately after creating the TPC-C like schema in…
1 min read
0
Generate load on Microsoft SQLserver Windows from HammerDB on Linux
Often it’s nice to be able to drive Windows applications and databases from Linux, especially if you are more comfortable…
1 min read
0
Comparing RDS and Nutanix Cluster performance with HammerDB
tl;dr In a recent experiment using Amazon RDS instance and a VM running in an on-prem Nutanix cluster, both using…
1 min read
0
How to drop tables for HammerDB TPC-C on SQL Server
From the SQL Window of SQL*Server. Issue these commands to drop the tables and procedures created by HammerDB. This will…
1 min read
0
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…
1 min read
0
SQL Server uses only one NUMA Node with HammerDB
Some versions of HammerDB (e.g. 3.2) may induce imbalanced NUMA utilization with SQL Server. This can easily be observed with…
1 min read
0
HammerDB: Avoiding bottlenecks in client.
How to avoid bottlenecks in the client generator when measuring database performance with HammerDB
3 min read
3
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…