Back to Buffer Pool Basics: Part 5C – DWQT and VDWQT

(Willie Favero) Before we jump into discussing the last two variable buffer pool thresholds, the defaults for the previously discussed fixed buffer pool thresholds are: immediate write threshold (IWTH) – 97.5%, data management threshold (DMTH) – 95%, and prefetch threshold (SPTH) – 90%.

Read More - Register for Free Membership