Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

IQ Backup saturate storage array

2 posts in General Discussion Last posting was on 2012-05-01 07:49:05.0Z
LM Posted on 2012-04-26 12:42:03.0Z
Sender: 58a.4f99413f.1804289383@sybase.com
From: LM
Newsgroups: sybase.public.iq
Subject: IQ Backup saturate storage array
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4f99429b.5c9.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 26 Apr 2012 05:42:03 -0700
X-Trace: forums-1-dub 1335444123 172.20.134.41 (26 Apr 2012 05:42:03 -0700)
X-Original-Trace: 26 Apr 2012 05:42:03 -0700, 172.20.134.41
Lines: 8
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.iq:4494
Article PK: 246635

Hello;
IQ Backup generates saturation of the storage array, with
Sybase IQ 15 on Solaris x86.
Do you know any parameters that permit to reduce charge in
storage array ?

Regards
Lionel


Leonid Gvirtz Posted on 2012-05-01 07:49:05.0Z
From: Leonid Gvirtz <leonid@gvirtz-consulting.com>
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:12.0) Gecko/20120428 Thunderbird/12.0.1
MIME-Version: 1.0
Newsgroups: sybase.public.iq
Subject: Re: IQ Backup saturate storage array
References: <4f99429b.5c9.1681692777@sybase.com>
In-Reply-To: <4f99429b.5c9.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4f9f9571$1@forums-1-dub>
Date: 1 May 2012 00:49:05 -0700
X-Trace: forums-1-dub 1335858545 10.22.241.152 (1 May 2012 00:49:05 -0700)
X-Original-Trace: 1 May 2012 00:49:05 -0700, vip152.sybase.com
Lines: 29
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.iq:4497
Article PK: 246637

Hi Lionel

Does you storage support snapshots/clones? If so, you may consider IQ
Virtual Backup instead of the regular backup.

How many destinations you use in your BACKUP statement? The more
destinations you use the more CPU cores IQ will be able to use for
backup. If you use more than one destination - try to decrease their number.

Also, you may want to check your storage limitations/configuration, may
be it just doesn't support required throughput and gets saturated under
relatively light load. Maybe the number of of physical drives in the
array is just not enough. On Solaris, you may try iostat, sar, prstat
and vmstat to get an idea.

Hope it helps
Leonid Gvirtz
http://www.gvirtz-consulting.com

On 4/26/2012 3:42 PM, LM wrote:
> Hello;
> IQ Backup generates saturation of the storage array, with
> Sybase IQ 15 on Solaris x86.
> Do you know any parameters that permit to reduce charge in
> storage array ?
>
> Regards
> Lionel