As businesses grow, the amount of data and data transactions grows as well. Therefore, data infrastructure needs to be able to handle this growth, ideally in a predictable fashion. To assess this, a test was run using the HammerDB TPROC-C workload on 12 Arc-enabled SQL MI GP instances simultaneously. The workload ramped up the number of users over time, increasing the workload in a controlled fashion to demonstrate business growth.
The following Grafana chart demonstrates the scalability of the environment. Each layer in the chart represents the compute resources consumed by each Arc-enabled SQL MI GP instance. The instances are balanced, consuming roughly the same amount of compute resources.