2 min read 0 Linux Back to basics – gprof PT1 (generating a profile) gary February 3, 2025 A while ago at work we were discussing the pros and cons of the classic Linux profiler gprof… What are…
2 min read 0 Postgres Database Performance Notes on tuning postgres for cpu and memory benchmarking gary October 18, 2024 Recently I wanted to measure the impact of NUMA placement and Hugepages on the performance of postgres running in a…
1 min read 0 Storage Performance Effect of POSIX_FADV_SEQUENTIAL and POSIX_FADV_RANDOM on IO performance. gary August 22, 2024 Previously we looked at how the POSIX_FADVISE_DONTNEED hint influences the Linux page cache when doing IO via a filesystem. Here…
1 min read 0 fio Storage Performance Using fio to read from Linux buffer-cache gary August 12, 2024 Sometimes we want to read from the Linux cache rather than the underlying device using fio. There are couple of…
1 min read 0 Linux Virtualization Understanding QEMU devices gary June 10, 2024 Not sure where I came across this, but it is an excellent description of QEMU (and virtualization in general). I…
1 min read 1 Telemetry Nutanix Using Prometheus and Grafana to monitor a Nutanix Cluster. gary May 17, 2024 Using a small python script we can liberate data from the “Analysis” page of prism element and send it to…
1 min read 0 Nutanix SQL Server A Nutanix / Prometheus exporter in bash gary May 3, 2024 Overview For a fun afternoon project, how about a retro prometheus exporter using Apache/nginx, cgi-bin and bash!? About prometheus format…
1 min read 0 Linux Linux memory monitoring (allocations Vs usage) gary April 18, 2024 How to use some of Linux’s standard tools and how different types of memory usage shows up. Examples of using…
1 min read 2 Linux Using iperf multi-stream may not work as expected gary April 1, 2024 Running iperf with parallel threads TL;DR – When running iperf with parallel threads/workers the -P option must be specified after…
1 min read 0 Linux mpstat has an option to show utilization per NUMA node gary January 8, 2024 Not sure how long this has been a thing, but I recently discovered that mpstat takes a -N option for…
1 min read 0 Workloads & Benchmarks Running the ML-Perf Storage benchmark on Nutanix files. gary September 15, 2023 Some technical notes on our submission to the benchmark committee. Background For the past few months engineers from Nutanix have…
1 min read 0 Telemetry Nutanix Viewing Nutanix cluster metrics in prometheus/grafana gary July 31, 2023 Using Nutanix API with prometheus push-gateway. Many customers would like to view their cluster metrics alongside existing performance data using…
1 min read 0 Linux Virtualization AHV SQL Server Effects of CPU topology on sqlserver guests with AHV. gary February 28, 2023 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 fio Storage Performance fio versions < 3.3 may show inflated random write performance gary February 15, 2023 TL;DR If your storage system implements inline compression, performance results with small IO size random writes with time_based and runtime…
1 min read 1 fio Specifying Drive letters with fio for Windows. gary December 29, 2022 fio on Windows Download pre-compiled fio binary for Windows Example fio windows file, single drive This will create a 1GB…
1 min read 0 Storage Performance Hunting for bandwidth on a consumer NVMe drive gary December 22, 2022 The Samsung SSD 970 EVO 500GB claims a sequential read bandwidth of 3400 MB/s this is a story of trying…
1 min read 0 Database Performance SQL Server Database sizes for HammerDB TPC-C/ SQLserver gary November 17, 2022 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 Telemetry Database Performance How to monitor SQLServer on Windows with Prometheus gary October 17, 2022 TL;DR
1 min read 0 Database Performance Generate load on Microsoft SQLserver Windows from HammerDB on Linux gary October 14, 2022 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 Linux Virtualization QCOW 3 Ways gary September 13, 2022 How to mount QCOW images as Linux block devices tl;dr guestmount (requires libguestfs-tools) sudo guestmount -d <vm-name> --ro -i <mountpoint>…