ONBAR-VERITAS DB restore performance issue...

Posted in 2004

Rajasekaran, Rajesh — Thu, 26 Feb 2004 07:55:48 -0600 — 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_01C3FC70.3D2B4B10 Content-Type: text/plain; charset="iso-8859-1" Hi, We have a performance issue with ONBAR restore for our IDS 7.31UD2XG. We use the Veritas Netbackup 4.5GA under Solaris 8. The backup (whole system serial) that we are trying to restore is the whole system restore. The restore throughput used to be 10 mb/sec and now its around 3 mb/sec. The restore is going over the network. The resore client has 100 MBPS network and the master server is 1000 Mbps/sec (gigabit network). I dont see much usage on the CPU,memory on both the box. Our network ppl say that the load between the two host is normal. We somehow identified that the slow down could be very specific to the restore client and it may be due to disk writes. But, we also have the view that the storage array is only 25% used during the restore. The storage array is Sun storedge A5200 array on Sun Fire V880 host. The DB volume layouts are RAID5 with 8 cols and 32k stripe size. I know RAID5 is going to slow down writes due to parity writing but i dont think it should degrade to the extent of more than 75%. Our VERITAS bptm logs from the master server shows that the delay is after it sends the data to the client. For an object, 6.5 hrs out of 10 hrs was the delay for one object. This used to complete in 4.5 hrs. But on this instance, the disk is not heavily loaded and hence more data can be pumped up. Considering the storage array is not utilized much, Should the BAR_NB_XPORT_COUNT and the BAR_NB_XFER_SIZE be increased ? I just left the values to 100 & 31 respectively. I am assuming that increasing this parameter will only have effect on parallel backups/restores. Also, BAR_NB_XFER_SIZE is set to 31 by default on 2k pagesize system. But it says xbsa has 64kb limit. At the same time, it can have values upto 1 million.Will it help if i increase beyond 32 k ? Will tuning both these parameters for a serial whole system restore help ? Please pass on your suggestions/comments. 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_01C3FC70.3D2B4B10 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.2653.12"> <TITLE>ONBAR-VERITAS DB restore performance issue...</TITLE> </HEAD> <BODY> Hi,    We have a performance issue with ONBAR = restore for our IDS 7.31UD2XG. We use the Veritas Netbackup 4.5GA under = Solaris 8. The backup (whole system serial) that we are trying to = restore is the whole system restore. The restore throughput used to be = 10 mb/sec and now its around 3 mb/sec. The restore is going over the = network. The resore client has 100 MBPS network and the master = server is 1000 Mbps/sec (gigabit network). I dont see much usage on the = CPU,memory on both the box. Our network ppl say that the load between = the two host is normal.    We somehow identified that the slow down = could be very specific to the restore client  and it may be due to = disk writes. But, we also have the view that the storage array is only = 25% used during the restore. The storage array is Sun storedge A5200 = array on Sun Fire V880 host. The DB volume layouts are RAID5 with 8 = cols and 32k stripe size. I know RAID5 is going to slow down writes due = to parity writing but i dont think it should degrade to the extent of = more than 75%. Our VERITAS bptm logs from the master server shows = that the delay is after it sends the data to the client. For an object, = 6.5 hrs out of 10 hrs was the delay for one object. This used to = complete in 4.5 hrs. But on this instance, the disk is not heavily = loaded and hence more data can be pumped up. Considering the storage array is not utilized much, = Should the BAR_NB_XPORT_COUNT and the BAR_NB_XFER_SIZE be increased ? I = just left the values to 100 & 31 respectively. I am assuming that = increasing this parameter will only have effect on parallel = backups/restores.  Also, BAR_NB_XFER_SIZE  is set to 31 by = default on 2k pagesize system. But it says xbsa has 64kb limit. At the = same time, it can have values upto 1 million.Will it help if i increase = beyond 32 k ? Will tuning both these parameters for a serial whole = system restore help ? Please pass on your suggestions/comments. 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_01C3FC70.3D2B4B10-- sending to informix-list

ONBAR-VERITAS DB restore performance issue...

Related threads

Your privacy choices