Building a Hybrid Database-as-a-Service Platform with Azure Stack HCI
Overview
Solution Architecture
Lab Setup
Performance-Oriented Test Scenarios
Functional Test Scenarios
Conclusion
Appendix A: On-premises monitoring setup
Appendix B: SQL MI and HammerDB Test Harness details
Additional Resources
Test methodology introduction
HammerDB initial configuration
HammerDB CLI Configuration
SQL MI creation and configuration
Test groups defined
Test Group 1 results
Test Group 2 results
Test Group 3 Results
Test Group 4 results
Test Group 5 results
Test Group 6 results
Reporting visualizations
Testing synopsis
Test Group 2 results
Test Group 2 results
-
We started our multi-instance workload testing in Test-2, as shown in the following figure, which included four SQL MIs: sqlmi-01 through sqlmi-04. Each of these ran four vCPUs and 8 Gi memory.
We observed that the TPM numbers for the sqlmi-01 instance when executing as part of a group are slightly lower compared with test one. This was expected behavior. The TPM numbers were still within an acceptable range considering the resources that were allocated and the running workloads.
For SQL MI specifications, see Test groups defined.
Figure 22. Test-2 user count and TPM metrics