Analyzing the Database Buffer

最新推荐文章于 2024-06-13 23:50:34 发布

原创最新推荐文章于 2024-06-13 23:50:34 发布 · 452 阅读

0 ·

CC 4.0 BY-SA版权

SAP Performance Management 专栏收录该内容

42 篇文章

订阅专栏

本文介绍了 SAP 系统中数据缓冲访问的质量评估指标，包括物理读取次数、逻辑读取次数以及缓冲命中率等关键参数，并解释了这些指标如何帮助优化数据库性能。

The following values characterize the quality of data buffer accesses:

-> Physical read accesses
Number of read accesses to the hard drive. This value indicates how many blocks or pages must be loaded to satisfy user queries being processed in an SAP work process.

-> Logical read accesses
Total number of read accesses. This figure indicates how many blocks or pages are read from the buffer and the hard disk.

-> Buffer quality or hit ratio
This value is derived for the quality of a buffer from the following equation:
Buffer quality= (logical accesses- physical accesses) I logical accesses x 100%