Backup receiving ASYNC_IO_COMPLETION

• ericwenger1

  Hall of Fame

  Points: 3436

  More actions

  June 7, 2021 at 2:58 pm

  #3893012

  Morning,

  I've run into a new issue that I've not run across before. Trying to do a Diff Backup on a fairly large database(1 tb)

  and receiving ASYNC_IO_COMPLETION WAIT TYPE. Any ideas would be greatly appreciated. Both MDF and LDF files are on the same drive. I've verified with the sys admin that this drive is a premium SSD Drive.

   

• Jeffrey Williams

  SSC Guru

  Points: 90349

  More actions

  June 7, 2021 at 4:48 pm

  #3893048

  Check out this article: https://www.sqlskills.com/blogs/paul/cause-high-duration-async_io_completion-waits/

  If this is causing the backups to take longer than they should - you could setup the XE event and gather the same information to provide to your server/storage team to show them.

  Also - are these backups using compression?

   

  Jeffrey Williams
  “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

  ― Charles R. Swindoll

  How to post questions to get better answers faster
  Managing Transaction Logs