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…
Category: SQL Server
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
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
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…
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…