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.
- Configuring a SQL Server instance (my original video)
- Configure SQL Server on Linux with the mssql-conf tool
- Performance best practices and configuration guidelines for SQL Server on Linux
- Troubleshoot SQL Server on Linux
- Ext4 vs XFS – Which Filesystem Should You Use
- Linux OS Tuning for MySQL Database Performance
- Postgres vs. File Systems: A Performance Comparison
- Standard RAID levels (RAID 5)
- Nested RAID levels (RAID 10)
- Improve Linux system performance with noatime
- SQL Server on Linux: Forced Unit Access (Fua) Internals
- The TuneD Project
- tuned-profiles-mssql
- Windows Server Power Management Effect on SQL Server
- vm.max_map_count (search in page)
- Ultimate Guide to JUMBO Frames: Configuration and Best MTU Size
- Why jumbo frames affects the performance of the server
- SQL Server 2016 Maximum Bytes/Row (8060)
- Multi-Queue Block IO Queueing Mechanism (blk-mq)
- Recommendations to reduce allocation contention in SQL Server tempdb database