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 5 results

Test Group 5 results

  • In the next two tests, as shown in the following figure, we deployed larger SQL MIs and observed the results. These two SQL MIs had our highest deployed vCPU requested count of 8 and memory request of 16 Gi.

    For Test-5, we only had two of the larger SQL MIs running a workload.  

    Chart, bar chart Description automatically generated

    Figure 25.    Test-5 user count and TPM metrics

    For SQL MI specifications, see Test groups defined.