Understanding Table I/O performance is critically important to properly diagnosing the health and efficiency of a database and pinpointing problems. In fact, if I only had just a few minutes to quickly assess a database, I’d look at 3 key measurements…
The Database Synchronous Read Percentage, SRP,
The Database Index Read Efficiency, IREF,
Table I/O measurements:
The average number [...]
