SEO

#1 (**permalink**) 04-19-2008, 09:00 PM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode