Home > Workload Solutions > SQL Server > White Papers > Dell EMC PowerMax Storage for Mission-Critical SQL Server Databases > Test case 7: DSS bandwidth test
Test case 7 demonstrates the high level of sequential read bandwidth that is available on the PowerMax platform for decision support systems and data warehouse environments.
We ran a single SQL Server database DSS workload at the Diamond service level with a SQL Server buffer pool size of 4 GB. While the test ran, we monitored host MB/S, as well as read and write response times.
As the test results in the following figure show, dual-ported smart RAID, 32 Gb FC-NVMe, and SCM drives coupled with the PowerMax cache provided a tremendous amount of bandwidth and unprecedented low latencies while supporting a SQL Server database OLTP workload at the Diamond service level.
Figure 13. SQL Server DSS sequential read bandwidth on PowerMax
The test showed an unprecedented read response time of 0.33 ms and a write response time of 0.21 ms while driving the DSS workload at almost 30 GB/s.
The PowerMax system with SCM drives and all other performance features can provide unparalled levels of bandwidth at very low latencies for decision support systems.