Incremental Archive performance issue......

Posted in 2004

Rajasekaran, Rajesh — Thu, 8 Apr 2004 15:56:01 -0500 — source: Usenet: comp.databases.informix

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C41DAB.E6121798 Content-Type: text/plain; charset="iso-8859-1" Hi, Our QAS system is a Sun E450 box with a sun storedge T/3 array attached. Its a solaris o/s with IDS 7.31 database. The DB size is around 400 GB. Its backup is directed over the network to a tape library attached to a master server which is another host. Our Master server is also the PRD box. Its a Sun Fire V880 with Sun L40 tape libary attached. We have the Veritas Netbackup Data center 4.5 for our backups & restores. The QAS DB backup is going over the network to the master server's DLT tape library that gives 35 GB/HR performance. We got that throughput for our QAS level-0 bkup even though its over the T3 network. But the Level-1 backup has severe performance degradation and it takes almost 5-7 hrs to complete. Our PRD level-1's are taking anywhere btw 1.5 - 2 hrs. We are only running the onbar whole system serial bkup. It should not put much I/O bottlenecks since only one dbspace bkup is running at one time and not parallel. I can see the iostat shows 10000-25000 Kb/sec for the T3 storedge array continously during the level-1 bkups. The informix "onstat -g stq" shows Full queue 0, Empty queue with Cnt 100 all the time. I dont see the I/O bottleneck here and i dont see the problem with the Veritas Netbackup side since our level-0 works as expected. I dont see any "arc_very_old_pages()" running during the level-1 bkups. Questions 1) What could be the reason for level-1 backup degradation in performance when level-0 is performing well ? 2) What better way to monitor btw the onbar and the engine ? Will the bar_dbug = 9 lvl trace shows more detail towards my problem ? Any suggestions/comments is greatly appreciated. Regards Rajesh Rajasekaran Informix Database Administrator Forest Pharmaceuticals Inc. (314) 493-7073 ____________________________________________________________________ This e-mail and its attachments may contain Forest Laboratories, Inc. proprietary information that is privileged, confidential or subject to copyright belonging to Forest Laboratories, Inc. This e-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this e-mail, or the employee or agent responsible for delivering this e-mail to the intended recipient, you are hereby notified that any dissemination, distribution, copying or action taken in relation to the contents of and attachments to this e-mail is strictly prohibited and may be unlawful. If you have received this e-mail in error, please notify the sender immediately and permanently delete the original and any copy of this e-mail and any printout. ------_=_NextPart_001_01C41DAB.E6121798 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2657.73"> <TITLE>Incremental Archive performance issue......</TITLE> </HEAD> <BODY> Hi,     Our QAS system is a Sun E450 box = with a sun storedge T/3 array attached. Its a solaris o/s with IDS 7.31 = database. The DB size is around 400 GB. Its backup is directed over the = network to a tape library attached to a master server which is another = host. Our Master server is also the  PRD box. Its a Sun Fire V880 = with Sun L40 tape libary attached. We have the Veritas Netbackup Data = center 4.5 for our backups & restores. The QAS DB backup is going over the network to the = master server's DLT tape library that gives 35 GB/HR performance. We = got that throughput for our QAS level-0 bkup even though its over the = T3 network. But the Level-1 backup has severe performance degradation = and it takes almost 5-7 hrs to complete. Our PRD level-1's are taking = anywhere btw 1.5 - 2 hrs. We are only running the onbar whole system serial = bkup. It should not put much I/O bottlenecks since only one dbspace = bkup is running at one time and not parallel.  I can see the iostat shows 10000-25000 Kb/sec = for the T3 storedge array continously during the level-1 bkups. The = informix "onstat -g stq" shows Full queue 0, Empty queue with = Cnt 100 all the time. I dont see the I/O bottleneck here and i dont see = the problem with the Veritas Netbackup side since our level-0 works as = expected. I dont see any "arc_very_old_pages()" running = during the level-1 bkups. Questions 1) What could be the reason for level-1 backup = degradation in performance when level-0 is performing well ? 2) What better way to monitor btw the onbar and the = engine ? Will the bar_dbug =3D 9 lvl trace shows  more detail = towards my problem ? Any suggestions/comments is greatly = appreciated.   Regards Rajesh Rajasekaran Informix Database Administrator Forest Pharmaceuticals Inc. (314) 493-7073 ____________________________________________________________________&= nbsp;=20 This e-mail and its attachments may contain Forest Laboratories, = Inc. proprietary information that is privileged, confidential or = subject to copyright belonging to Forest Laboratories, Inc. This e-mail = is intended solely for the use of the individual or entity to which it = is addressed. If you are not the intended recipient of this e-mail, or = the employee or agent responsible for delivering this e-mail to the = intended recipient, you are hereby notified that any dissemination, = distribution, copying or action taken in relation to the contents of = and attachments to this e-mail is strictly prohibited and may be = unlawful. If you have received this e-mail in error, please notify the = sender immediately and permanently delete the original and any copy of = this e-mail and any printout. </BODY> </HTML> ------_=_NextPart_001_01C41DAB.E6121798-- sending to informix-list

Incremental Archive performance issue......

Related threads

Your privacy choices