Home > Storage > PowerFlex > White Papers > Dell APEX Block Storage for Public Cloud: Microsoft SQL Server Multi-Subnet Failover Clustering Deployment > Single SQL Server 2022 database instance in a single AWS AZ
The objective of this test was to check the single SQL Server 2022 database performance with one SQL Server Cluster Object having volumes mapped to the APEX Block Storage.
For configuration details of EC2 Instance, see section. Datafiles of the TPROC-C database were distributed across volumes . Log files are stored on separate volumes and tempdb was stored on another Volume.
The following figure 6 shows the performance of a single SQL Server 2022 Instance:
Figure 6: Performance of a single instance in a multi-AZ environment in Dell APEX Block Storage for Public Cloud
As shown in the above test results, a maximum 64000 IOPS is achieved with 30 virtual users under 1 millisecond read latency and write latency. AWS EC2 Instance CPU was at 20% and memory utilization of approximately 50%.