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