Published: (Updated: ) by . Leave a Comment on 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 VM on a Nutanix node. To do this I needed to drive postgres to do real transactions but have very little jitter/noise from the filesystem and storage. After reading a lot of blogs I came […]
Published: (Updated: ) by . Leave a Comment on 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 A Prometheus exporter simply has to return a page with metric names and metric values in a particular format like below. When you configure prometheus via prometheus.yml you’re telling prometheus to visit a particular IP:Port […]
Published: (Updated: ) by . Leave a Comment on 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 HammerDB and then using server and then using Tasks->Shrink->Database. Warehouse Count Database size 10 826 MB 100 8,057 MB
Published: (Updated: ) by . Leave a Comment on 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 in a Unix environment. This post will show you how to drive a Microsoft SQL Server database running on a Windows server from a remote Linux machine. In this example I am using Ubuntu 22.04, […]
Published: (Updated: ) by . Leave a Comment on 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 Skylake class processors with similar clock speeds and vCPU count. The SQLServer database on Nutanix delivered almost 2X the transaction rate as the same workload running on Amazon RDS. It turns out that migrating an […]
Published: (Updated: ) by . Leave a Comment on 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 allow you (for instance) to re-create the database, or create a new database with more warehouses (larger size) while retaining the same name/DB layout.
Published: (Updated: ) by . 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.
Published: (Updated: ) by .
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 […]
Published: (Updated: ) by .
How to avoid bottlenecks in the client generator when measuring database performance with HammerDB
Published: (Updated: ) by . 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 […]
