Perform the following steps to create a tuned profile for the SQL Server database engine:

1. Create a directory with name mssql under the /usr/lib/tuned directory.
2. Create a file that is named tuned.conf.

The following example shows a sample tuned file:

# A tuned configuration for MSSQL on Linux

# This provides a _default_ tuned for an OLTP workload

# !!WARNING: our shell scripts overwrite some of these for specific benefits. 

#

[main]

summary=Optimize for MS SQL OLTP

include=throughput-performance

[cpu]

force_latency=5

[sysctl]

vm.swappiness = 1

vm.dirty_background_ratio = 3

vm.dirty_ratio = 80

vm.dirty_expire_centisecs = 500

vm.dirty_writeback_centisecs = 100

vm.transparent_hugepages=always

vm.max_map_count=1600000

net.core.rmem_default = 262144

net.core.rmem_max = 4194304

net.core.wmem_default = 262144

net.core.wmem_max = 1048576

kernel.numa_balancing=0

   3. Run the following command to save the file and activate the profile: tuned-adm profile mssql

   4. Run the following command to check your activated profile: tuned-adm list