Posts tagged: Hit Ratio from TKProf

Sep 23 2009

How to Calculate Hit Ratio from Tkprof output

 Tkprof will have three fields in output
1. Disk
2. Query
3. Current
Generally hit ratio is calculated like as follows
 Hit Ratio = 1 – (Physical Reads/Logical Reads)

Physical Reads = Sum (Disk)
Logical Reads  = Sum (Query) + Sum (Current)

Alibi3col theme by Themocracy