June 7, 2021 at 2:58 pm
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.
June 7, 2021 at 4:48 pm
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
Problems are opportunities brilliantly disguised as insurmountable obstacles.
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply