2 min read
0
Notes on tuning postgres for cpu and memory benchmarking
Recently I wanted to measure the impact of NUMA placement and Hugepages on the performance of postgres running in a…
Category: Database Performance
Database performance and benchmarking
1 min read
0
A Nutanix / Prometheus exporter in bash
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
Effects of CPU topology on sqlserver guests with AHV.
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
Database sizes for HammerDB TPC-C/ SQLserver
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
1 min read
0
Generate load on Microsoft SQLserver Windows from HammerDB on Linux
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
How to generate a new hostid for a Cassandra node.
If you clone a Cassandra VM with the goal of creating a cassandra cluster – you may find that every…
1 min read
0
How to drop tables for HammerDB TPC-C on SQL Server
From the SQL Window of SQL*Server. Issue these commands to drop the tables and procedures created by HammerDB. This will…
1 min read
0
Understanding Concurrency Parameters in pgbench
How to use the “jobs” and “clients” parameters in pgbench without going crazy.
1 min read
0
Postgres pgbench scale-factors and WSS
Scale factor to workingset size lookup for tiny databases
1 min read
0
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…
1 min read
0
SQL Server uses only one NUMA Node with HammerDB
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
HammerDB: Avoiding bottlenecks in client.
How to avoid bottlenecks in the client generator when measuring database performance with HammerDB
4 min read
0
How to run vertica vioperf tool
The vertica vioperf tool is used to determine whether the storage you are planning on using is fast enough to…
2 min read
0
View from Nutanix storage during Postgres DB benchmark
Following on from the previous [1] [2] experiments with Postgres & pgbench. A quick look at how the workload is…
1 min read
0
Benchmarking with Postgres PT2
In this example we run pgbench with a scale factor of 1000 which equates to a database size of around…
2 min read
0
Benchmarking with Postgres PT1
In this example, we use Postgres and the pgbench workload generator to drive some load in a virtual machine. Assume…
2 min read
0
Performance gains for postgres on Linux with hugepages
For this experiment I am using Postgres v11 on Linux 3.10 kernel. The goal was to see what gains can…
3 min read
3
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…