Analyzing the Database Buffer

来源:互联网 发布:二级c语言题库百度云 编辑:程序博客网 时间:2024/05/08 10:08

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%

0 0
原创粉丝点击