Answer
Dirty pages: modified in buffer pool but not yet persisted to disk.
Clean pages: identical to the disk version.
Checkpoints convert dirty pages to clean pages. Too many dirty pages increase recovery time and degrade performance.
Want to bookmark, take notes, or join discussions?
Sign in to access all features and personalize your learning experience.
Source: SugharaIQ