SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Backup in suspended state


Backup in suspended state

Author
Message
devanandiiway
devanandiiway
Old Hand
Old Hand (304 reputation)Old Hand (304 reputation)Old Hand (304 reputation)Old Hand (304 reputation)Old Hand (304 reputation)Old Hand (304 reputation)Old Hand (304 reputation)Old Hand (304 reputation)

Group: General Forum Members
Points: 304 Visits: 255
Hi,

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

Regards,
Devanand.
durai nagarajan
durai nagarajan
Hall of Fame
Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)

Group: General Forum Members
Points: 3481 Visits: 2784
ASYNC IO looks like related to your backup place IO issue and nothing related to virtual memory.

is the backup gets completed?

Regards
Durai Nagarajan
devanandiiway
devanandiiway
Old Hand
Old Hand (304 reputation)Old Hand (304 reputation)Old Hand (304 reputation)Old Hand (304 reputation)Old Hand (304 reputation)Old Hand (304 reputation)Old Hand (304 reputation)Old Hand (304 reputation)

Group: General Forum Members
Points: 304 Visits: 255
Yeah, previous week it took 3 hrs and it did not complete. After increasing the virtual memory, it took 45 mins to backup the 82 gb database, though it was in suspended mode.

What could be the actual issue? Do you mean there is some issue with my backup target location.
Am taking backup to my local drive.

Regards,
Devanand.
durai nagarajan
durai nagarajan
Hall of Fame
Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)

Group: General Forum Members
Points: 3481 Visits: 2784
what makes you to increase the virtual memory?

what is the sql error log and windows log says at that time?

Regards
Durai Nagarajan
devanandiiway
devanandiiway
Old Hand
Old Hand (304 reputation)Old Hand (304 reputation)Old Hand (304 reputation)Old Hand (304 reputation)Old Hand (304 reputation)Old Hand (304 reputation)Old Hand (304 reputation)Old Hand (304 reputation)

Group: General Forum Members
Points: 304 Visits: 255
Initially all the application jobs running on the server got failed, because of IO issue. So admin recommended to increase the virtual memory.

When the backup was in ASYNC IO, it dint complete. When i killed the session id, in sql server log i received an error saying that "backup command failed to backup the database"

Windows Admin team is saying that there are no error logs.

Thanks,
Dev.
durai nagarajan
durai nagarajan
Hall of Fame
Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)

Group: General Forum Members
Points: 3481 Visits: 2784
can you post the hardware server configuration, like processors, and drives are ordinaly HDD or san drives. backup drive details

Definetly looks like sql is waiting for something.

Regards
Durai Nagarajan
devanandiiway
devanandiiway
Old Hand
Old Hand (304 reputation)Old Hand (304 reputation)Old Hand (304 reputation)Old Hand (304 reputation)Old Hand (304 reputation)Old Hand (304 reputation)Old Hand (304 reputation)Old Hand (304 reputation)

Group: General Forum Members
Points: 304 Visits: 255
Hi,

Please find the hardware details below

IBM XSERIES_3650 Intel® Xeon™ MVcpu 3.20Ghz, RAM:8GB

We are taking backup to H: drive whose free space is around 157 GB.
durai nagarajan
durai nagarajan
Hall of Fame
Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)

Group: General Forum Members
Points: 3481 Visits: 2784
what about drive and backup drive details?

if their speed is low or any hardware issue there this might happen.

Regards
Durai Nagarajan
Divine Flame
Divine Flame
SSCarpal Tunnel
SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)

Group: General Forum Members
Points: 4389 Visits: 2816
devanandiiway (8/31/2012)
Hi,

Please find the hardware details below

IBM XSERIES_3650 Intel® Xeon™ MVcpu 3.20Ghz, RAM:8GB

We are taking backup to H: drive whose free space is around 157 GB.




Have you taken a look at "Avg. Disk Queue Length"? Is it under acceptable limit?


Sujeet Singh
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search