Description
This wait accumulates when a database is configured to use Indirect Checkpoints. These checkpoints can reduce the amount of disk I/O spikes and time it takes to recover a database. High values from this wait type are a sign of normal activity and can be safely ignored
Resolved by
DBAs
Suggested solutions
- Safe to ignore
Additional research
DIRTY_PAGE_POLL wait type in SQL Server 2012
See more
Check out SpotLight, a free, cloud based SQL Server monitoring tool to easily detect, monitor, and solve SQL Server performance problems on any device