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 1 results
Test Group 1 results
-
In Test-1, which we used as a baseline, we deployed and ran our HammerDB test harness against a single SQL MI, sqlmi01. The TPM results are shown in the following figure. TPM scaled at a near linear fashion without saturating the underlying infrastructure as we incrementally added HammerDB virtual users. We observed about a 40,000 TPM increase as we progressed through our first three user sets. TPM increased by about 20,000 for the last user set.
For SQL MI specifications, see Test groups defined.
Figure 21. Test-1 user count and TPM metrics