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.

Azure Arc-enabled SQL Managed Instance General Purpose deployment

Figure 7.   K8s pods deployed via Azure CLI

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. 

CPU usage while increasing user workload

Figure 8.   Equal CPU resources consumed by each of the 12 Azure Arc-enabled SQL Managed Instances