n0derunner

Install a bitnami image to Nutanix AHV cluster.

Published: (Updated: ) in Nutanix, , , , , by .

One of the nice things about using public cloud is the ability to use pre-canned application virtual appliances created by companies like Bitnami. We can use these same appliance images on Nutanix AHV to easily do a Postgres database benchmark Step 1. Get the bitnami image wget  https://bitnami.com/redirect/to/587231/bitnami-postgresql-11.3-0-r56-linux-debian-9-x86_64.zip Step 2. Unzip the file and convert […]

Creating compressible data with fio.

Published: (Updated: ) in fio, , , , by .

Today I used fio to create some compressible data to test on my Nutanix nodes.  I ended up using the following fio params to get what I wanted.   buffer_compress_percentage=50 refill_buffers buffer_pattern=0xdeadbeef buffer_compress_percentage does what you’d expect and specifies how compressible the data is refill_buffers Is required to make the above compress percentage do what you’d […]

Specifying Drive letters with fio for Windows.

Published: (Updated: ) in fio, , , , by .

Simple fio file for using Drive letters on Windows. This will create a file called “fiofile” on the F:\ Drive in Windows.  Notice that the specification is “Driveletter” “Backslash” “Colon” “Filename” In fio terms we are “escaping” the “:” which fio traditionally uses as a file separator. [global] bs=1024k size=1G time_based runtime=30 rw=read direct=1 iodepth=8 […]

SuperScalin’: How I learned to stop worrying and love SQL Server on Nutanix.

Published: (Updated: ) in SQL Server, , , , 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 […]

Multiple devices/jobs in fio

Published: (Updated: ) in fio, , by .

If your underlying filesystem/devices have different response times (e.g. some devices are cached – or are on SSD) and others are on spinning disk, then the behavior of fio can be quite different depending on how the fio config file is specified.  Typically there are two approaches 1) Have a single “job” that has multiple […]