How to optimize SQL Server on Linux

There are several Linux-specific changes that need to be made for SQL Server deployments on Linux. Some changes may be specific to certain Linux distributions.

An administrator should disable the last accessed date/time (atime) on any filesystem that is used to store SQL Server data and/or log files. The last accessed date/time mount option causes a write operation to happen after each read access. This would generate a massive amount of extra I/O. The mount option should be changed to noatime to help reduce disk I/O.

In order to deal with large amounts of memory, Linux uses Transparent Huge Pages (THP). THP automates managing, creating, and working with huge pages. Manually trying to manage huge pages would be very difficult, so, for SQL Server on Linux, leave THP enabled.

Memory should be managed so that SQL Server does not starve the underlying operating system. At the same time, SQL Server should be configured to use as much memory...