SQL Server 2019 on Red Hat Enterprise Linux 8 now Generally Available

This post has been republished via RSS; it originally appeared at: New blog articles in Microsoft Tech Community.

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 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.



Instructions on how to install SQL 2019 CU1 with RHEL 8 have been updated on the documentation at following pages.

Configuring Repo: https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-change-repo?view=sql-server-ver15&pivots=ld2-rhel#configure-new-repository

Installation Tutorial: https://docs.microsoft.com/en-us/sql/linux/quickstart-install-connect-red-hat?view=sql-server-linux-ver15


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.


Running Red Hat UBI 8 based container: https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-configure-docker?view=sql-server-ver15#rhel

SQL Server on the Red Hat Container Catalog  https://access.redhat.com/containers/?tab=overview#/mcr.microsoft.com/mssql/rhel/server


Performance Improvement Updates

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 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)

Vin Yu (Senior Program Manager)

Tejas Shah (Principal Program Manager)

REMEMBER: these articles are REPUBLISHED. Your best bet to get a reply is to follow the link at the top of the post to the ORIGINAL post! BUT you're more than welcome to start discussions here:

This site uses Akismet to reduce spam. Learn how your comment data is processed.