As our final test, we ran the same HammerDB TPC-C workload across all ten Azure Arc-enabled SQL Managed Instances. We observed that our overall TPM numbers were lower, but we saw impressive results on the first four quad-vCPU instances when compared to the rest of the instances, as shown in the following figure.
With the previous test, the TPM ramp-up and user step-up workload jumped in 40,000 TPM increments. With this denser workload profile of ten SQL MIs, the TPM increased to averages around 20,000 TPM for each stepped user increase.
Note: We never observed CPU, memory, or storage performance saturation at any level of the solution stack. This means that we could have pushed the system even harder if wanted.
Figure 26. Test-6 user count and TPM metrics
For SQL MI specifications, see Test groups defined.