Additional SQL Server features and topics not covered by specific categories
SQL Server on Linux OS configuration recommendation
Are there any recommandation/explaination of the following setting? and how /why it's affecting sql server performance
Setting Value More information
CPU frequency governor performance See the cpupower command
ENERGY_PERF_BIAS performance See the x86_energy_perf_policy command
min_perf_pct 100 See your documentation on intel p-state
C-States C1 only See your Linux or system documentation on how to ensure C-States is set to C1 only
Setting Value More information
disk readahead 4096 See the blockdev command
sysctl settings kernel.sched_min_granularity_ns = 10000000
kernel.sched_wakeup_granularity_ns = 15000000
vm.dirty_ratio = 40
vm.dirty_background_ratio = 10
vm.swappiness = 10 See the sysctl command
sysctl -w kernel.numa_balancing=0
sysctl -w vm.max_map_count=1600000
Transparent Huge Pages (THP) enabled