BACKUPIO

Description

A backup operation is reading/writing from database data files. Note that all backup waits are accumulated for restore operations too

Resolved by

DBAs

Suggested solutions

  1. Investigate volume hosting database files, upgrade if possible
  2. Use backup compression if available
  3. Remove any unused indexes (less data to backup)

Additional research

Backup Wait Statistics

See more

Consider using ApexSQL Monitor, a Windows and SQL Server monitoring tool able to track SQL Server wait types, including the individual query wait statistics

⇐ Back to index