Home > Workload Solutions > SQL Server > White Papers > Scaling SQL Server 2022 VMs on Dell Integrated System for Microsoft Azure Stack HCI > Document purpose
The purpose of this document is to test SQL Server 2022 performance and scalability on Azure Stack HCI and validate platform management tools such as Dell OpenManage Integration with Microsoft Windows Admin Center. To address these objectives, we deployed a Dell Integrated System for Microsoft Azure Stack HCI running Microsoft SQL Server 2022 VMs. We used HammerDB, an open-source tool for performing synthetic benchmarking against SQL Server, to discover the average and maximum Transactions Per Minutes (TPM) on a single VM. We tested TPM scalability as more SQL Server VMs were created on the cluster to understand the impact of a common consolidation scenario in which more VMs are added to the platform over time.
We also observed the behavior of the integrated system under failover conditions. We examined high availability and recoverability at both the infrastructure and SQL Server application layer. We also carried out proactive lifecycle management tasks to prove the operational efficiency aspects of the integrated system using Dell OpenManage Integration with Microsoft Windows Admin Center.