1 min read 0 X-Ray Nutanix X-Ray video Series gary August 10, 2020 A series of videos showing how to install, run, modify and analyze HCI clusters with the Nutanix X-ray tool
1 min read 0 Storage Performance Identifying Optane drives in Linux gary July 15, 2020 How to identify optane drives in linux OS using lspci.
1 min read 0 SQL Server How to drop tables for HammerDB TPC-H on SQL Server gary June 9, 2020 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 diskspd Microsoft diskspd Part 3. Oddities and FAQ gary April 22, 2020 Tips and tricks for using diskspd especially useful for those familar with tools like fio
1 min read 0 diskspd Microsoft diskspd. Part 2 How to bypass NTFS Cache. gary April 7, 2020 How to ensure performance testing with diskspd is stressing the underlying storage devices, not the OS filesystem.
1 min read 0 diskspd Microsoft diskspd. Part 1 Preparing to test. gary March 30, 2020 How to install and setup diskspd before starting your first performance tests and avoiding wrong results due to null byte…
1 min read 0 Nutanix How to measure database scaling & density on Nutanix HCI platform. gary March 27, 2020 How can database density be measured? How does database performance behave as more DBs are consolidated? What impact does running…
1 min read 2 X-Ray How to run vdbench benchmark on any HCI with X-Ray gary March 23, 2020 Many storage performance testers are familiar with vdbench, and wish to use it to test Hyper-Converged (HCI) performance. To accurately…
1 min read 0 Storage Performance How to identify NVME drive types and test throughput gary March 17, 2020
1 min read 0 Storage Performance Why does my SSD not issue 1MB IO’s? gary March 13, 2020 First things First Why do we tend to use 1MB IO sizes for throughput benchmarking? To achieve the maximum throughput…
2 min read 0 Storage Performance How to identify SSD types and measure performance. gary March 9, 2020 The real-world achievable SSD performance will vary depending on factors like IO size, queue depth and even CPU clock speed.…
1 min read 0 Miscellaneous Quick & Dirty Prometheus on OS-X gary February 7, 2020 How to install Prometheus on OS-X Install prometheus $ cd /Users/gary.little/Downloads/prometheus-2.16.0-rc.0.darwin-amd64$ ./prometheus Add a collector/scraper to monitor the OS Prometheus…
1 min read 0 SQL Server SQL Server uses only one NUMA Node with HammerDB gary October 7, 2019 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 Database Performance HammerDB: Avoiding bottlenecks in client. gary October 4, 2019 How to avoid bottlenecks in the client generator when measuring database performance with HammerDB
1 min read 0 X-Ray Measuring CPU performance with X-Ray and pgbench. gary October 1, 2019 An X-ray workload for measuring application density
4 min read 0 Database Performance How to run vertica vioperf tool gary September 6, 2019 The vertica vioperf tool is used to determine whether the storage you are planning on using is fast enough to…
1 min read 0 Nutanix Impact of Data locality on DB workloads. gary July 23, 2019 Do database workloads benefit from data locality?
2 min read 0 Linux Virtualization Duplicate IP issues with Linux and virtual machine cloning. gary July 10, 2019 TL;DR – Some modern Linux distributions use a newer method of identification which, when combined with DHCP can result in…
2 min read 0 Postgres Nutanix View from Nutanix storage during Postgres DB benchmark gary June 28, 2019 Following on from the previous [1] [2] experiments with Postgres & pgbench. A quick look at how the workload is…