Question:
The Buffer Pool List displays the value of Read Eff as *******. What does this mean?
Answer:
READ EFF stands for Read Effectiveness and is the ratio of Getpage requests to Synchronous I/O operations. When Synchronous I/O value is 0 (zero) and getpage value is NON ZERO, since you can't divide by zero, that's when the value of Read Eff is displayed as ********.