This section provides best practices and recommendations for configuring the Red Hat Linux operating system.
Perform the following steps:
echo 1024 > /sys/block/sdc/queue/max_sectors_kb
echo 1024 > /sys/block/sdc/queue/max_sectors_kb/nr_requests
See, Performance best practices and configuration guidelines for SQL Server on Linux
# 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
chmod +x /usr/lib/tuned/mssql/tuned.conf
tuned-adm profile mssql
tuned-adm list