Incremental Archive performance issue......
Posted in 2004
Topics: Backup & Restore, Performance & Tuning, Storage & Space Management, Platform-Specific Issues, Versions, Editions & End-of-Life
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>
<P><FONT SIZE=3D2>Hi,</FONT>
</P>
<P><FONT SIZE=3D2> 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.</FONT></P>
<P><FONT SIZE=3D2>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.</FONT></P>
<P><FONT SIZE=3D2>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. </FONT></P>
<P><FONT SIZE=3D2> 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.</FONT></P>
<P><FONT SIZE=3D2>Questions</FONT>
</P>
<P><FONT SIZE=3D2>1) What could be the reason for level-1 backup =
degradation in performance when level-0 is performing well ?</FONT>
<BR><FONT SIZE=3D2>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 ?</FONT></P>
<P><FONT SIZE=3D2>Any suggestions/comments is greatly =
appreciated.</FONT>
<BR><FONT SIZE=3D2> </FONT>
</P>
<P><FONT SIZE=3D2>Regards</FONT>
<BR><FONT SIZE=3D2>Rajesh Rajasekaran</FONT>
<BR><FONT SIZE=3D2>Informix Database Administrator</FONT>
<BR><FONT SIZE=3D2>Forest Pharmaceuticals Inc.</FONT>
<BR><FONT SIZE=3D2>(314) 493-7073</FONT>
</P>
<BR>
<BR>
<BR>
<BR>
<P>____________________________________________________________________&=
nbsp;=20
<BR>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.</P>
</BODY>
</HTML>
------_=_NextPart_001_01C41DAB.E6121798--
sending to informix-list
Related threads
- Posting from the Informix-list
- Migrating from IDS 9.40.UC6 to 11.50.UC3
- Ip for a network session
- questions onstat -g