Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Backup in suspended state Expand / Collapse
Author
Message
Posted Thursday, August 30, 2012 6:59 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, June 10, 2013 3:10 AM
Points: 54, 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.
Post #1352173
Posted Thursday, August 30, 2012 7:13 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, March 19, 2014 5:48 AM
Points: 1,048, Visits: 2,646
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
Posted Thursday, August 30, 2012 7:17 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, June 10, 2013 3:10 AM
Points: 54, 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.
Post #1352194
Posted Thursday, August 30, 2012 8:18 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, March 19, 2014 5:48 AM
Points: 1,048, Visits: 2,646
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
Posted Thursday, August 30, 2012 10:28 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, June 10, 2013 3:10 AM
Points: 54, 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.
Post #1352357
Posted Friday, August 31, 2012 2:13 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, March 19, 2014 5:48 AM
Points: 1,048, Visits: 2,646
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
Posted Friday, August 31, 2012 3:59 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, June 10, 2013 3:10 AM
Points: 54, 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.


Post #1352670
Posted Friday, August 31, 2012 6:48 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, March 19, 2014 5:48 AM
Points: 1,048, Visits: 2,646
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
Posted Friday, August 31, 2012 7:32 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 12:21 AM
Points: 1,270, Visits: 2,331
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
Post #1352803
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse