Ensure that the following best practices are applied to the Linux operating system:
- Modify max_sector_kb to 1024 for all database volumes.
For example:
echo 1024 > /sys/block/sdc/queue/max_sectors_kb
- Modify nr_requests to 1024 for all database volumes.
For example:
echo 1024 > /sys/block/sdc/queue/max_sectors_kb/nr_requests
- Set disk read ahead settings to 4096 or more for high throughput storage.
- SQL Server supports both EXT4 and XFS file systems to host the database files, but Microsoft recommends to use XFS file system for hosting the SQL Server data and transaction log files.
- Disable the NUMA balancing to allow SQL Server to operate at maximum efficiency on NUMA node.
- Set the open file limit to a maximum of 60000.
- Disable the last accessed date and time on file systems for SQL Server data and log files.
- Use a tuned profile-based system tuning tool of Linux to create profile for SQL Server.
For more information about the Mssql tuned profile of tuned profile used for this solution, see Appendix B.
For more information about Linux best practices, See Performance best practices.