Test case 6 demonstrates the end-to-end NVMe support of PowerMax for SQL Server running on Linux servers.
We ran a single SQL Server database OLTP workload with a SQL Server buffer pool size of 4 GB on Linux server. While the test ran, we monitored host IOPS, SQL Server TPM, and read and write response times.
As the test results in the following figure show, PowerMax provided end-to-end NVMe support when using 32 Gb FC-NVMe HBAs on the Linux server.
Figure 12. End-to-end NVMe test for SQL Server running on Linux
This testing achieved read and write response times of 0.15 ms and 0.19 ms respectively. This performance level was unparalleled, while all components of the storage system were still quite balanced and able to support additional workloads. PowerMax supported host IOPS of over 227 K with a SQL Server Database OLTP transaction rate of 1.8 M.
The end-to-end NVMe support on PowerMax accommodates an unrivaled level of performance for SQL Server on Linux.