Reference Architecture Guide—Ready Solutions for Microsoft SQL: Design for Dell EMC XtremIO
Appendix A: Best practice guidance
Operating system layer
For RHEL 7.6:
- Use the tuned-adm command-line tool to set the latency-performance profile.
- Follow Microsoft’s Performance best practices and configuration guidelines for SQL Server on Linux. Add the Microsoft-recommended performance-related configuration parameters for the RHEL operating system to the latency-performance profile.
- Change the disk label (dos, by default) to GPT.
- Create disk partitions using the fstab or parted utility on storage devices. We chose the EXT4 file system while formatting the disks.
- Keep all the mounted file entries in /etc/fstab to enable automatic mounting when the server reboots.
For Windows Server 2016:
- Select the High Performance power profile in the guest operating system.
- Format the drives using the ReFS file system with 64 KB allocation for better performance and durability.
- Change the disk label to GPT drive, and set the queue depth to 254 and ring pages to 32.
- Enable lock pages in memory for the SQL Server service account.