SQL Server support for Red Hat Enterprise Linux (RHEL) 8 was announced at last Red Hat summit and was in preview. Our team since then made numerous improvements to fully embrace the Red Hat 8 ecosystem which includes a native RHEL 8 package for SQL Server 2019 and Red Hat Enterprise Linux based containers and are fully supported in production. You can now leverage the latest SQL Server innovations on Red Hat 8.
SQL Server on Red Hat Enterprise Linux 8
We are happy to announce the availability of SQL Server 2019 package native to RHEL 8 ecosystem, fully supported for production use, starting with CU1. You can read about SQL Server 2019 CU1 release at following page.
SQL Server on Red Hat Universal Based Image Containers
We are also glad to announce the availability of SQL Server 2019 CU1 container image build on Red Hat Universal Based Image 8 (UBI8). It’s fully supported for production use. You can read about how to deploy the container at following page.
As one may have worked with SQL Server on Linux, they may have introduced to certain storage and IO flush related configurations due to unavailability of FUA (Forced Unit Access) functionality in user mode of Linux ecosystem. You can read extremely good technical details at following blog written by Bob Dorr, a lead in SQL Server product group.
If you see the “Safety and Performance” section in the blog, it outlines the various configurations you can have depending on kernel version and storage capabilities.
We are glad to say that Red Hat engineering team have introduced the FUA capability in user mode for XFS filesystem starting with RHEL 8. This means for SQL Server 2019 on RHEL 8, recommended configuration is following.
If using XFS filesystem with FUA-capable storage for database files storage then,
Enable trace flag 3979
Set control.writethrough (a mssql-conf configuration option) to 1.
Set control.alternatewritethrough (a mssql-conf configuration option) to 0.
Of course, if EXT4 filesystem is in use then the blog should be reviewed thoroughly to see how to get best performance based on underlying storage configuration.
We hope you give SQL Server 2019 on Red Hat 8 try and let us know what you think.
Mike Habben (Principal Software Engineering Manager)