How to performance test Nutanix on AWS with X-ray
Published: (Updated: ) by . Leave a Comment on How to performance test Nutanix on AWS with X-ray.
End to End Creation of a Nutanix Cluster on AWS and Running X-Ray
Postgres pgbench scale-factors and WSS
Published: (Updated: ) by . Leave a Comment on Postgres pgbench scale-factors and WSS.
Scale factor to workingset size lookup for tiny databases
Nutanix X-Ray video Series
Published: (Updated: ) by . Leave a Comment on Nutanix X-Ray video Series.
A series of videos showing how to install, run, modify and analyze HCI clusters with the Nutanix X-ray tool
How to download and Install Nutanix X-ray on an AHV cluster
Published: (Updated: ) by . Leave a Comment on How to download and Install Nutanix X-ray on an AHV cluster.
Identifying Optane drives in Linux
Published: (Updated: ) by . Leave a Comment on Identifying Optane drives in Linux.
How to identify optane drives in linux OS using lspci.
How to drop tables for HammerDB TPC-H on SQL Server
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.
Microsoft diskspd Part 3. Oddities and FAQ
Published: (Updated: ) by . Leave a Comment on Microsoft diskspd Part 3. Oddities and FAQ.
Tips and tricks for using diskspd especially useful for those familar with tools like fio
Microsoft diskspd. Part 2 How to bypass NTFS Cache.
Published: (Updated: ) by . Leave a Comment on Microsoft diskspd. Part 2 How to bypass NTFS Cache..
How to ensure performance testing with diskspd is stressing the underlying storage devices, not the OS filesystem.
Microsoft diskspd. Part 1 Preparing to test.
Published: (Updated: ) by . Leave a Comment on Microsoft diskspd. Part 1 Preparing to test..
How to install and setup diskspd before starting your first performance tests and avoiding wrong results due to null byte issues.
How to measure database scaling & density on Nutanix HCI platform.
Published: (Updated: ) by . Leave a Comment on How to measure database scaling & density on Nutanix HCI platform..
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.
How to run vdbench benchmark on any HCI with X-Ray
Published: (Updated: ) by . 2 Comments on How to run vdbench benchmark on any HCI with X-Ray.
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. […]
How to identify NVME drive types and test throughput
Published: (Updated: ) by .
Why does my SSD not issue 1MB IO’s?
Published: (Updated: ) by . Leave a Comment on Why does my SSD not issue 1MB IO’s?.
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 […]
How to identify SSD types and measure performance.
Published: (Updated: ) by .
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 […]
Quick & Dirty Prometheus on OS-X
Published: (Updated: ) by .
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 itself does not do much apart from monitor itself, to do anything useful we have to add a scraper/exporter module. The easiest thing to do is add the scraper to monitor OS-X itself. As in […]
SQL Server uses only one NUMA Node with HammerDB
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 […]
HammerDB: Avoiding bottlenecks in client.
Published: (Updated: ) by .
How to avoid bottlenecks in the client generator when measuring database performance with HammerDB
Measuring CPU performance with X-Ray and pgbench.
Published: (Updated: ) by .
An X-ray workload for measuring application density
How to run vertica vioperf tool
Published: (Updated: ) by .
The vertica vioperf tool is used to determine whether the storage you are planning on using is fast enough to feed the vertica database. When I initially ran the tool, the IO performance reported by the tool and confirmed by iostat was much lower than I expected for the storage device (a 6Gbit SATA device […]
Impact of Data locality on DB workloads.
Published: (Updated: ) by .
Do database workloads benefit from data locality?