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…
Tag: sqlserver
1 min read
0
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…
1 min read
0
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
1
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…
1 min read
0
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…
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