THE VIDEO

THE SYNOPSIS

In this video, we will run through detailed configuration recommendations for SQL Server on Linux. We will also find out where you can find your error logs.

THE COMMANDS

Following are the command line operations I used throughout the video.

sudo apt-get install -y plocate
locate mssql-conf


cd /opt/mssql/bin/
sudo ./mssql-conf list


sudo ./mssql-conf set-collation
# Latin1_General_CI_AS


sudo systemctl stop mssql-server
systemctl status mssql-server
sudo systemctl start mssql-server


sudo vi /etc/security/limits.d/99-mssql-server.conf
# mssql soft stack 8192
# mssql hard nofile 32767
# mssql soft nofile 16000

sudo apt-get install -y tuned
man tuned-profiles-mssql
cd /usr/lib/tuned
less mssql/tuned.conf


ethtool -g eth0
# Shows an error on my NIC because tx max is 2560
sudo ethtool -G eth0 tx 4096
sudo ethtool -G eth0 tx 2560
ethtool -g eth0


ethtool -l eth0


cat /sys/block/sda/queue/scheduler


free -h


sudo /opt/mssql/bin/mssql-conf set memory.memorylimitmb 4096
sudo systemctl restart mssql-server


sudo ls -l /var/opt/mssql/log

LINKS AND ADDITIONAL INFORMATION

All of these videos are on behalf of Catallaxy Services, LLC, my consulting company where I help customers on problems all across the data platform space.

Leave a comment