Dell EMC PowerFlex for Microsoft SQL Server 2019
- Configure high-performance profile for MDM, SDS, and SDC.
- Disable Read Flash cache and Read RAM cache for all flash clusters.
- Check with VxFlex platform team to increase the per device queue length value to 256 per host for improving the I/O concurrency.
- Ensure that the customize power plan is set to High Performance.