Reports the percentage of times that a data page read could be satisfied from cache without requiring a physical page read.
11.0 and later
Result
Yes
None
SMC_NAME_SPID, [SMC_NAME_DB_ID + SMC_NAME_OBJ_ID], [SMC_NAME_ACT_STP_DB_ID + SMC_NAME_ACT_STP_ID], SMC_NAME_ENGINE_NUM
VALUE_ SAMPLE |
VALUE_ SESSION |
RATE_ SAMPLE |
RATE_ SESSION |
AVG_ SAMPLE |
AVG_ SESSION |
|---|---|---|---|---|---|
DOUBLE |
DOUBLE |
