Home > Workload Solutions > SQL Server > White Papers > Scaling SQL Server 2022 VMs on Dell Integrated System for Microsoft Azure Stack HCI > Transactions Per Minute (TPM) and New Orders Per Minute (NOPM)
We were able to deploy and achieve linear performance for 12 VMs running our benchmarking tests. During these tests, we scaled VMs from 1, 2, 4, 8, and to 12. Each of these benchmarking tests was conducted while the TPROC-C transaction load from HammerDB was running concurrently on the respective number of VMs running SQL Server. For example, for our final tests, 12 VMs running SQL Server were benchmarked by 12 separate HammerDB instances concurrently. While running our tests, our CPU utilizations per VM ranged between 20 to 30 percent. Figure 12 shows the linear scale we
achieved during our tests.