Your Browser is Out of Date

Nytro.ai uses technology that works best in other browsers.
For a full experience use one of the browsers below
Building Azure Arc-enabled Data Services for a SQL Managed Instance on Dell PowerFlex
Introduction Product overview Solution architecture Test scenarios
Test scenarios
Testing methodology introduction
HammerDB initial configuration
HammerDB configuration
SQL Server VM baseline test
SQL Server MI tests
Azure Arc-enabled data services build versions
SQL MI creation scale - up scenario
Storage class configuration
Scale SQL MI up/down
Node CPU utilization – Azure Arc for Kubernetes | Insights
Test case results Conclusion Appendix A: SQL MI and Hammer DB Test Harness details Appendix B: SQL MI related service management using kubectl Appendix C: Red Hat Linux configuration References

SQL Server VM baseline test

Home > Storage > PowerFlex > White Papers > Building Azure Arc-enabled Data Services for a SQL Managed Instance on Dell PowerFlex > SQL Server VM baseline test

SQL Server VM baseline test

  • To create a comparison point (baseline) before the SQL MI performance testing, a SQL Server VM (sql-vm) is deployed within the same PowerFlex cluster

    The sql-vm had the following virtual hardware profile and specifications:

    • Operating System: Linux (Red Hat Enterprise Linux 8.4 (Ootpa)
    • 16 vCPU
    • 32 GB memory
    • SQL Version: Microsoft SQL Server 2019 (RTM-CU14) (KB5007182) - 15.0.4188.2 (X64)
    • Multiple file system mount points are used:
      • Operating system, SQL binary files
      • SQL system and user databases (data)
      • SQL system and user databases (log)
      • SQL system tempdb (data and log)
    • CPU utilization goal is not to exceed 50 percent

    HammerDB configuration:

    • OLTP database presized similarly to the SQL MI
    • SIMPLE Recovery Model is set

    The initial benchmark TPM numbers for the SQL Server VM are mentioned below. This VM is running on the PowerFlex cluster. This PowerFlex cluster is the same cluster running the Red Hat Enterprise Linux VM worker nodes for the Kubernetes cluster that is used by Azure Arc and SQL MI. This was the only workload running on the cluster during the testing.

    The environment averaged 500,000 TPM metrics, which provide a comparison baseline for the PowerFlex and Azure Arc-enabled data services architecture performance tests.