Description
This wait type accumulates while requests SQL Server is waiting for a storage level (snapshot) backup to complete. These backups freeze all I/O on the volume to enable backups of large databases to be performed in seconds. Small accumulated values are acceptable. If an individual wait takes over 5 seconds investigation is required.
Resolved by
DBAs
Suggested solutions
- Make sure snapshot backup drivers and software are up to date.
- Ensure snapshot backup drivers and software are configured correctly.
- Move non critical files and databases off the snapshot volume (the less I/O to freeze the better).
Additional research
Snapshot Backups
Should I Be Using SAN Snapshots as a Backup Solution?