From the SQL Window of SQL*Server. Issue these commands to drop the tables and procedures created by HammerDB. This will allow you (for instance) to re-create the database, or create a new database with more warehouses (larger size) while retaining the same name/DB layout.
Continue readingCategory: Workloads & Benchmarks
Understanding Concurrency Parameters in pgbench
A Generalized workload generator for storage IO
With help from the Nutanix X-Ray team I have created an IO “benchmark” which simulates a “General Server Virtualization” workload. I call it the “Mixed Workload Simulator“
Continue readingCross rack network latency in AWS
I have VMs running on bare-metal instances. Each bare-metal instance is in a separate rack by design (for fault tolerance). The bandwidth is 25GbE however, the response time between the hosts is so high that I need multiple streams to consume that bandwidth.
Compared to my local on-prem lab I need many more streams to get the observed throughput close to the theoretical bandwidth of 25GbE
| # iperf Streams | AWS Throughput | On-Prem Throughput |
| 1 | 4.8 Gbit | 21.4 Gbit |
| 2 | 9 Gbit | 22 Gbit |
| 4 | 18 Gbit | 22.5 |
| 8 | 23 Gbit | 23 Gbit |
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
Continue reading