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 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 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 . 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 […]
