Cache Hardware Software White Paper 
SQL Server According to Bob
JANUARY 11, 2020
This White Paper is for informational purposes only. Stable media is commonly physical disk storage, but other devices and certain caching facilities qualify as well. Many high-end disk subsystems provide high-speed cache facilities to reduce the latency of read and write operations.
Percona
APRIL 17, 2023
Make sure the drives are mounted with noatime and also if the drives are behind a RAID controller with appropriate battery-backed cache. Furthermore, proper mount options can improve performance noticeably. By default, it uses 50% of the memory + 1 GB. Set the value to 60-70% and monitor the memory usage.
SQL Server According to Bob
JANUARY 11, 2020
This White Paper is for informational purposes only. Time of Last Access The time of last access is a caching algorithm that enables cache entries to be ordered by their access times.
Expert insights. Personalized for you.
40 
Let's personalize your content