Buffer Pool Performance

The top three thresholds on this slide are most critical to bufferpool and system performance. However, if IWTH has counts but DMTH and SPTH do not, then this can be ignored. IWTH will be triggered whenever an updated page has not been written out (hot page) for two checkpoints.