Description
This wait occurs on databases with snapshots. When the primary database is updated the original page must be written to any snapshots, during reads to the snapshot sparse file this wait will accumulate. The wait will also accumulate during DBCC CHECKDB operations as a snapshot is temporarily created internally
Resolved by
DBAs
Suggested solutions
- Drop any unnecessary snapshots
- Upgrade disks hosting snapshot data files
Additional research
Database Snapshots
Looking at Database Snapshot Performance