This section provides best practices and recommendations for configuring the Red Hat Linux operating system.

Perform the following steps:

• Run the following command to modify max_sector_kb to 1024 for all database volumes

echo 1024 > /sys/block/sdc/queue/max_sectors_kb

• Run the following command to modify nr_requests to 1024 for all database volumes

echo 1024 > /sys/block/sdc/queue/max_sectors_kb/nr_requests

• Microsoft recommendations

See, Performance best practices and configuration guidelines for SQL Server on Linux

• Apply the tuned-profile for SQL Server
  • Create a directory with the name mssql under /usr/lib/tuned
  • Create a file named tuned.conf

# A tuned configuration for SQL Server on Linux 

[main]

summary=Optimize for Microsoft SQL Server

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

# For , use

# vm.transparent_hugepages=madvice

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

kernel.sched_latency_ns = 60000000

kernel.sched_migration_cost_ns = 500000

kernel.sched_min_granularity_ns = 15000000

kernel.sched_wakeup_granularity_ns = 2000000

• Save the following file to activate:

chmod +x /usr/lib/tuned/mssql/tuned.conf

tuned-adm profile mssql

• Confirm that the profile has been activated, by running:

tuned-adm list