Reports the ratio of pages in buffers that were both referenced and reused, relative to all pages in buffers in a given cache that were reused.
If the ratio is large, then prefetching is effective; otherwise, prefetching is not providing much benefit. This may suggest that a buffer pool should be eliminated (or it may imply that a clustered index on some table is fragmented, and that the index should be dropped and recreated).
SMC_NAME_DATA_CACHE_PREFETCH_EFFICIENCY
ignores buffers in the default buffer pool in each cache.
11.0 and later
Result
No
DATA_CACHE_ID
None
VALUE_ SAMPLE |
VALUE_ SESSION |
RATE_ SAMPLE |
RATE_ SESSION |
AVG_ SAMPLE |
AVG_ SESSION |
|---|---|---|---|---|---|
DOUBLE |
DOUBLE |
