<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2005
»
Backups
»
Backup in suspended state
Backup in suspended state
Rate Topic
Display Mode
Topic Options
Author
Message
devanandiiway
devanandiiway
Posted Thursday, August 30, 2012 6:59 AM
Valued Member
Group: General Forum Members
Last Login: Yesterday @ 11:10 PM
Points: 54,
Visits: 251
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.
Post #1352173
durai nagarajan
durai nagarajan
Posted Thursday, August 30, 2012 7:13 AM
SSC Eights!
Group: General Forum Members
Last Login: Today @ 6:23 AM
Points: 852,
Visits: 2,100
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
Post #1352183
devanandiiway
devanandiiway
Posted Thursday, August 30, 2012 7:17 AM
Valued Member
Group: General Forum Members
Last Login: Yesterday @ 11:10 PM
Points: 54,
Visits: 251
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.
Post #1352194
durai nagarajan
durai nagarajan
Posted Thursday, August 30, 2012 8:18 AM
SSC Eights!
Group: General Forum Members
Last Login: Today @ 6:23 AM
Points: 852,
Visits: 2,100
what makes you to increase the virtual memory?
what is the sql error log and windows log says at that time?
Regards
Durai Nagarajan
Post #1352254
devanandiiway
devanandiiway
Posted Thursday, August 30, 2012 10:28 AM
Valued Member
Group: General Forum Members
Last Login: Yesterday @ 11:10 PM
Points: 54,
Visits: 251
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.
Post #1352357
durai nagarajan
durai nagarajan
Posted Friday, August 31, 2012 2:13 AM
SSC Eights!
Group: General Forum Members
Last Login: Today @ 6:23 AM
Points: 852,
Visits: 2,100
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
Post #1352639
devanandiiway
devanandiiway
Posted Friday, August 31, 2012 3:59 AM
Valued Member
Group: General Forum Members
Last Login: Yesterday @ 11:10 PM
Points: 54,
Visits: 251
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.
Post #1352670
durai nagarajan
durai nagarajan
Posted Friday, August 31, 2012 6:48 AM
SSC Eights!
Group: General Forum Members
Last Login: Today @ 6:23 AM
Points: 852,
Visits: 2,100
what about drive and backup drive details?
if their speed is low or any hardware issue there this might happen.
Regards
Durai Nagarajan
Post #1352767
Divine Flame
Divine Flame
Posted Friday, August 31, 2012 7:32 AM
Ten Centuries
Group: General Forum Members
Last Login: Friday, May 17, 2013 2:00 PM
Points: 1,076,
Visits: 1,914
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?
- Divine Flame
Post #1352803
« Prev Topic
|
Next Topic »
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
