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 Effects of CPU topology on sqlserver guests with AHV..
VM CPU Topology The topology (layout) that AHV presents virtual Sockets/CPU to the guest operating system will usually be different than the physical topology. This is expected because we typically present a subset of all cores to the guest VMs. Usually it is the total number of vCPU given to the VM that matters, not […]
Published: (Updated: ) by . Leave a Comment on How to monitor SQLServer on Windows with Prometheus.
TL;DR
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 . 1 Comment on Single threaded DB performance on Nutanix HCI.
tl;dr A Nutanix cluster can persist a replicated write across two nodes in around 250 uSec which is critical for single-threaded DB write workloads. The performance compares very well with hosted cloud database instances using the same class of processor (db.r5.4xlarge in the figure below). The metrics below are for SQL insert transactions not the […]
Published: (Updated: ) by . Leave a Comment on AOS 6.1 Improvements for Day-2 database operations..
AOS 6.1 greatly improved database performance on Nutanix especially when the guest VM uses just a single disk for all the database files. The underlying change is known as vdisk sharding. Basically it allows the Nutanix CVM to scale up the number of threads used to service a single virtual disk under heavy load.
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
