Category: Databases

HammerDB: Avoiding bottlenecks in client.
By: Date: October 4, 2019 Categories: Databases,Testing & Benchmarking Tags: , , ,

HammerDB is a great tool for running Database benchmarks. However it is very easy to create an artificial bottleneck which will give a very poor benchmark result. When setting up HammerDB to run against even a moderate modern server, it is important to avoid displaying the client transaction outputs in the HammerDB UI. In my…

Read More →
Benchmarking with Postgres PT1
By: Date: June 28, 2019 Categories: Postgres Tags: , ,

In this example, we use Postgres and the pgbench workload generator to drive some load in a virtual machine. ¬†Assume a Linux virtual machine that has Postgres installed. Specifically using a Bitnami virtual appliance. Once the VM has been started, connect to the console Allow access to postgres port 5432 – which is the postgres…

Read More →