Home > Workload Solutions > SQL Server > White Papers > SQL Server 2019 Best Practices on PowerEdge Servers and PowerStore T Model Arrays > Red Hat Enterprise Linux: Last Accessed Time (atime)
In this best practice, we changed the default Linux XFS mount option per Red Hat guidelines.
Overview
Atime is a specification of the Linux operating system tracks the last time a file was accessed. For example, when the Linux operating system reads data from a data file, the access time is updated. Database frequently access data files and updating the access time with each access represents an overhead on the operating system possibly impacting performance.
It is possible to specify no access time (noatime), meaning the Linux operating system will not update the access time for files. The goal of this best practice was to reduce associated overhead and increase efficiency by setting the operating system to noatime.
Additional resources