Your Browser is Out of Date

ShareDemos uses technology that works best in other browsers.
For a full experience use one of the browsers below
Building a Hybrid Database-as-a-Service Platform with Azure Stack HCI

close

view all chapters

Performance-Oriented Test Scenarios
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