Configuring and Troubleshooting SQL Server on Linux
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.
LINKS AND INFO
Catallaxy Services - https://www.catallaxyservices.com
Get the command line operations used in this video -- https://36chambers.wordpress.com/2024...
Configuring a SQL Server instance (my original video) -- • Configuring a SQL Server Instance
Configure SQL Server on Linux with the mssql-conf tool -- https://learn.microsoft.com/sql/linux...
Performance best practices and configuration guidelines for SQL Server on Linux -- https://learn.microsoft.com/sql/linux...
Troubleshoot SQL Server on Linux -- https://learn.microsoft.com/sql/linux...
Ext4 vs XFS - Which Filesystem Should You Use -- https://linuxopsys.com/topics/ext4-vs...
Linux OS Tuning for MySQL Database Performance -- https://www.percona.com/blog/linux-os...
Postgres vs. File Systems: A Performance Comparison -- https://www.enterprisedb.com/blog/pos...
Standard RAID levels (RAID 5) -- https://en.wikipedia.org/wiki/Standar...
Nested RAID levels (RAID 10) -- https://en.wikipedia.org/wiki/Nested_...
Improve Linux system performance with noatime -- https://opensource.com/article/20/6/l...
SQL Server on Linux: Forced Unit Access (Fua) Internals -- https://techcommunity.microsoft.com/t...
The TuneD Project -- https://tuned-project.org/
tuned-profiles-mssql -- https://manpages.ubuntu.com/manpages/...
Windows Server Power Management Effect on SQL Server -- https://www.mssqltips.com/sqlserverti...
vm.max_map_count (search in page) -- https://kernel.org/doc/Documentation/...
Ultimate Guide to JUMBO Frames: Configuration and Best MTU Size -- https://stonefly.com/resources/jumbo-...
Why jumbo frames affects the performance of the server -- https://serverfault.com/questions/259...
SQL Server 2016 Maximum Bytes/Row (8060) -- https://dba.stackexchange.com/questio...
Multi-Queue Block IO Queueing Mechanism (blk-mq) -- https://docs.kernel.org/block/blk-mq....
Recommendations to reduce allocation contention in SQL Server tempdb database -- https://learn.microsoft.com/troublesh...
