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. Set control.alternatewritethrough (a mssql-conf configuration option) to 0.
Set control.writethrough (a mssql-conf configuration option) to 1.If using XFS filesystem with FUA-capable storage for database files storage then, This means for SQL Server 2019 on RHEL 8, recommended configuration is following. 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. 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. You can read extremely good technical details at following blog written by Bob Dorr, a lead in SQL Server product group. SQL Server on the Red Hat Container Catalog Īs 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 about how to deploy the container at following page. We are also glad to announce the availability of SQL Server 2019 CU1 container image build on Red Hat Universal Based Image 8 (UBI8). SQL Server on Red Hat Universal Based Image Containers Instructions on how to install SQL 2019 CU1 with RHEL 8 have been updated on the documentation at following pages. You can read about SQL Server 2019 CU1 release at following page. 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 now leverage the latest SQL Server innovations on Red Hat 8. 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. SQL Server support for Red Hat Enterprise Linux (RHEL) 8 was announced at last Red Hat summit and was in preview.