In one of my production servers, the backup is going to suspended state with "ASYNC IO completion", and it is taking long time to complete.
I have contacted my system admin to increase the virtual memory and paging. Microsoft recommended to have 12 GB, but we have 20 GB configured in our system.
But still the backup for 3 databases are going to suspended state with ASYNC IO completion. The size of the database are as follows 83gb, 49 gb, 19 gb.
Kindly tell me if there is anyway i can avoid this ASYNC IO issue. Also let us know the exact reason for this issue.
Thanks in Advance