pgbench paramaters for concurrency control pgbench offers two parameters for controlling the concurrency in the benchmark. Namely: -j for ‘jobs’. The number of pgbench threads to run. -j, –jobs=NUM number of threads (default: 1) -c for ‘clients’. The number of “postgres” processes to run. -c, –client=NUM number of concurrent database clients (default: 1) Here are…
Read More →With help from the Nutanix X-Ray team I have created an IO “benchmark” which simulates a “General Server Virtualization” workload. I call it the “Mixed Workload Simulator“ Mixed Workload Simulator The goals of this benchmark/generator are : Closely simulate 10’s to 100’s of VM’s all acting independently Actually deploy 100’s or 1000’s of VMs to…
Read More →
How to speed up your X-ray benchmark development cycle by re-using/re-cycling benchmark VMs and more importantly data-sets.
Read More →I have VMs running on bare-metal instances. Each bare-metal instance is in a separate rack by design (for fault tolerance). The bandwidth is 25GbE however, the response time between the hosts is so high that I need multiple streams to consume that bandwidth. Compared to my local on-prem lab I need many more streams to…
Read More →
End to End Creation of a Nutanix Cluster on AWS and Running X-Ray
Read More →
Scale factor to workingset size lookup for tiny databases
Read More →
A series of videos showing how to install, run, modify and analyze HCI clusters with the Nutanix X-ray tool
Read More →
Use the following SQL to drop the tables and indexes in the HammerDB TPC-H schema, so that you can re-load it.
Read More →
Tips and tricks for using diskspd especially useful for those familar with tools like fio
Read More → How to ensure performance testing with diskspd is stressing the underlying storage devices, not the OS filesystem.
Read More → How to install and setup diskspd before starting your first performance tests and avoiding wrong results due to null byte issues.
Read More →
How can database density be measured? How does database performance behave as more DBs are consolidated? What impact does running the CVM have on available host resources? tl;dr The cluster was able to achieve ~90% of the theoretical maximum. CVM overhead was 5% for this workload. Experiment setup The goal was to establish how database…
Read More →
Many storage performance testers are familiar with vdbench, and wish to use it to test Hyper-Converged (HCI) performance. To accurately performance test HCI you need to deploy workloads on all HCI nodes. However, deploying multiple VMs and coordinating vdbench can be tricky, so with X-ray we provide an easy way to run vdbench at scale….
Read More →
First things First Why do we tend to use 1MB IO sizes for throughput benchmarking? To achieve the maximum throughput on a storage device, we will usually use a large IO size to maximize the amount of data is transferred per IO request. The idea is to make the ratio of data-transfers to IO requests…
Read More →
The real-world achievable SSD performance will vary depending on factors like IO size, queue depth and even CPU clock speed. It’s useful to know what the SSD is capable of delivering in the actual environment in which it’s used. I always start by looking at the performance claimed by the manufacturer. I use these figures…
Read More →
How to install Prometheus on OS-X Install prometheus Download the compiled prometheus binaries from prometheus.io Unzip the binary and cd into the directory. Run the prometheus binary, from the command line, it will listen on port 9090 $ cd /Users/gary.little/Downloads/prometheus-2.16.0-rc.0.darwin-amd64$ ./prometheus From a local browser, point to localhost:9090 Add a collector/scraper to monitor the OS…
Read More →
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…
Read More →