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 →