The total hit ratio for a buffer pool, shown as a percentage. This value is the ratio of physical reads to logical reads, including reads from data pages, index pages, and XDA object pages. Buffer pool hit ratio is the ratio of physical reads to logical reads, expressed as a percentage. It is a measure of how often reads are made from pages that are already in a buffer pool compared to how often they are made from pages that must be loaded from disk. A higher percentage indicates more data is being read from the buffer pool. This means a lower frequency of disk I/O. A lower percentage means more data is being read from disk. This means a higher frequency of disk I/O and slower performance.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center
