SQL Server 2019 images with current Linux distribution support available in Azure marketplace

This post has been republished via RSS; it originally appeared at: SQL Server articles.

SQL Server team has been working diligently in adding support for current Linux distributions. To this end, the team announced support for SQL Server 2019 on RHEL 8.0, Ubuntu 18.04 and SLES 12 SP5 within last quarter.

 

The team is glad to announce that the Azure marketplace PAYG (Pay As You Go) images for SQL Server 2019 on RHEL 8.0, Ubuntu 18.04 and SLES 12 SP5 have been made generally available. You can deploy these images to get the latest of both SQL Server 2019 functionality and operating system improvements.

 

A visual of Azure marketplace with SQL Server 2019 on Linux images:

 

SQL2019LinuxAzureMarketplace.png

 

A few notable things:

  • SQL Server 2019 on RHEL 8.0 image has pre-enabled the HA repo. It means that if you want to deploy pacemaker cluster environment on these PAYG images to setup Availability Groups on SQL Server 2019, you can do so without a double subscription costs.
    • Here are the instructions on how to configure Availability Groups on SQL Server with RHEL VM on Azure. While the instructions were created for SQL Server 2017 on RHEL 7.x image, they are generally applicable to SQL Server 2019 on RHEL 8.x image with a few considerations on OS commands/configurations.
    • In fact, if you do use the new SQL Server 2019 on RHEL 8.0 image, you can skip the steps to manually install SQL Server and SQL tools on the VM reducing number of steps to perform.
  • SQL Server 2019 on RHEL 8.0 image includes the operating system improvements to XFS filesystems, including support for FUA bit. This enables you to take advantage of reduced forced filesystem flushes and improve IO throughput performance. Earlier announcement for support for RHEL 8.0 has some additional details for this.
  • SQL Server 2019 on SLES 12 SP5 image also includes the operating system improvements to XFS filesystems, including support for FUA bit. This enables you to take advantage of reduced forced filesystem flushes and improve IO throughput performance. Earlier announcement for support of SLES 12 SP5 has additional details for this.

 

The SQL Server team is excited to bring you the innovation of SQL Server 2019 and latest operating system support in new Azure IaaS images in Marketplace. We hope you can make good use of it. We are always listening to feedback, so please do let us know your thoughts.

 

Yadi Reyes (Snr. Software Engineer)

Pratyush Rawat (Principal Software Engineering Manager)

Mike Habben (Principal Software Engineering Manager)

Mine Tokus (Senior Program Manager)

Tejas Shah (Principal Program Manager)

Leave a Reply

Your email address will not be published. Required fields are marked *

*

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