Your Browser is Out of Date

ShareDemos uses technology that works best in other browsers.
For a full experience use one of the browsers below
Architecting Microsoft SQL Server 2019 Containers on Dell EMC PowerFlex
Executive Summary Technology Overview Solution Architecture Performance Tests Best Practices
PowerFlex
Red Hat Enterprise Linux
Microsoft SQL Server Containers
Conclusion References Configuration SQL Configuration and Tuned Profile

Red Hat Enterprise Linux

Red Hat Enterprise Linux

  • Ensure that the following best practices are applied to the Linux operating system:

    • Modify max_sector_kb to 1024 for all database volumes.

    For example:

    echo 1024 > /sys/block/sdc/queue/max_sectors_kb

    • Modify nr_requests to 1024 for all database volumes.

    For example:

     echo 1024 > /sys/block/sdc/queue/max_sectors_kb/nr_requests

    • Set disk read ahead settings to 4096 or more for high throughput storage.
    • SQL Server supports both EXT4 and XFS file systems to host the database files, but Microsoft recommends to use XFS file system for hosting the SQL Server data and transaction log files.
    • Disable the NUMA balancing to allow SQL Server to operate at maximum efficiency on NUMA node.
    • Set the open file limit to a maximum of 60000.
    • Disable the last accessed date and time on file systems for SQL Server data and log files.
    • Use a tuned profile-based system tuning tool of Linux to create profile for SQL Server.

    For more information about the Mssql tuned profile of tuned profile used for this solution, see Appendix B.

    For more information about Linux best practices, See Performance best practices.