Home > Workload Solutions > SQL Server > White Papers > SQL Server 2019 Best Practices on PowerEdge Servers and PowerStore T Model Arrays > Red Hat Enterprise Linux
The Linux operating system has been widely accepted for running SQL Server databases. We used Red Hat Enterprise Linux version 8.5 for the tests, as this Linux flavor provides the stability, reliability, and security required for databases. The same best practice approach was taken with Red Hat Linux, as used for VMware. Linux best practices are integrated into each physical layer of recommendations. It is easy for customers to review Linux recommendations by reading CPU best practices or another physical layer.
The following table summarizes the software architecture used to validate the best practices:
Table 4. Software architecture used
SQL Server | 2019 CU 16-15.0.4223.1 |
Operating system | Red Hat Enterprise Linux 8.5 |
VMware vSphere | VMware 7.0.3 with vCenter 7.0.3 |
There are many possible combinations for the software architecture. The goal for testing SQL Server, Red Hat Enterprise Linux 8.5, and VMware vSphere 7.0.3 was to have a design that applies to what database customers use today. Future best practices programs will address new versions of the database and advances in both the operating system and virtualization.