Analyzing the Database Buffer

最新推荐文章于 2022-01-20 15:51:47 发布

scmaxyes

最新推荐文章于 2022-01-20 15:51:47 发布

阅读量417

点赞数

分类专栏： SAP Performance Management

本文链接：https://blog.csdn.net/scmaxyes/article/details/42708727

版权

SAP Performance Management 专栏收录该内容

42 篇文章 0 订阅

订阅专栏

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%