Home > Workload Solutions > SQL Server > White Papers > Scaling SQL Server 2022 VMs on Dell Integrated System for Microsoft Azure Stack HCI > CPU and storage parameters
The storage pool supported the near linear scaling for database performance. This demonstrated how SQL Server can optimally use the underlying storage capabilities of our cluster nodes.
Throughout our tests, read and write latency did not exceed acceptable levels and peaked at 1.5 ms when measured for the VM volume layer. This demonstrates that even in the most demanding workloads, when 12 SQL Server VMs were benchmarked concurrently the storage pool provided by the cluster was able to meet storage requirements.
We also maintained a relatively consistent CPU utilization on the VM level for the SQL server VMs, averaging between 20 to 30 percent CPU utilization to produce a respectable workload. This consistency ensured availability for non-IO intensive applications on our cluster to maximize its utility for all types of customers. Customers can balance the CPU and storage needs of their cluster to achieve similarly optimal results.