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.

ASE database load taking huge time on UAT server

8 posts in General Discussion Last posting was on 2010-09-08 12:58:58.0Z
shree Posted on 2010-09-07 12:37:26.0Z
Sender: 5766.4c860d58.1804289383@sybase.com
From: Shree
Newsgroups: sybase.public.ase.general
Subject: ASE database load taking huge time on UAT server
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4c863206.5b1f.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 7 Sep 2010 05:37:26 -0700
X-Trace: forums-1-dub 1283863046 10.22.241.41 (7 Sep 2010 05:37:26 -0700)
X-Original-Trace: 7 Sep 2010 05:37:26 -0700, 10.22.241.41
Lines: 21
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29538
Article PK: 78770

Hi,

I need help to sort out one issue in my environment. We have
sybase
ASE 12.5.4/EBF 16816 on
production, QA & UAT. Database size is 240GB. The database
load on QA
from production takes approx 1.5 Hrs but same dump when
loaded on UAT
took more than 7 hours. I don't
see any issues from sybase ASE side for this delay then what
causing
this delay. I suspect its OS or disk related problem. Is
there any way
to prove this and how to reduce the load time in this case.
Let me
know if you need any other details.


Thanks
Shree


Jason L. Froebe [TeamSybase] Posted on 2010-09-07 15:36:34.0Z
From: "Jason L. Froebe [TeamSybase]" <jason.froebe@gmail.com>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.1.11) Gecko/20100713 Thunderbird/3.0.6
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: ASE database load taking huge time on UAT server
References: <4c863206.5b1f.1681692777@sybase.com>
In-Reply-To: <4c863206.5b1f.1681692777@sybase.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4c865c02@forums-1-dub>
Date: 7 Sep 2010 08:36:34 -0700
X-Trace: forums-1-dub 1283873794 10.22.241.152 (7 Sep 2010 08:36:34 -0700)
X-Original-Trace: 7 Sep 2010 08:36:34 -0700, vip152.sybase.com
Lines: 34
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29539
Article PK: 78769


On 09/07/2010 07:37 AM, Shree wrote:
> Hi,
>
> I need help to sort out one issue in my environment. We have
> sybase
> ASE 12.5.4/EBF 16816 on
> production, QA& UAT. Database size is 240GB. The database
> load on QA
> from production takes approx 1.5 Hrs but same dump when
> loaded on UAT
> took more than 7 hours. I don't
> see any issues from sybase ASE side for this delay then what
> causing
> this delay. I suspect its OS or disk related problem. Is
> there any way
> to prove this and how to reduce the load time in this case.
> Let me
> know if you need any other details.
>
>
> Thanks
> Shree

Could be any number of things really. The two most common items I've
run into are:

1. significant hardware (disk/memory/cpu/etc) differences
2. memory allocated to either backupserver or ASE is significantly
different (allocating large amounts memory to the backup server is
generally worth it if time of restoration is important)

hope that helps

jason


ET Posted on 2010-09-07 20:23:14.0Z
From: ET <ET>
Reply-To: ET
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; fr; rv:1.9.2.8) Gecko/20100802 Thunderbird/3.1.2
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: ASE database load taking huge time on UAT server
References: <4c863206.5b1f.1681692777@sybase.com>
In-Reply-To: <4c863206.5b1f.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4c869f32$1@forums-1-dub>
Date: 7 Sep 2010 13:23:14 -0700
X-Trace: forums-1-dub 1283890994 10.22.241.152 (7 Sep 2010 13:23:14 -0700)
X-Original-Trace: 7 Sep 2010 13:23:14 -0700, vip152.sybase.com
Lines: 35
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29544
Article PK: 78775

hi

It can be a lot of things, as said precedingly.

If you want to go to talk to your sysadmins with "something", you can
try using file creation command on the device(s) where you are
restoring, and compare between both environments. You may see big
differences.

You did not mention what is your OS but see mkfile or dd commands

Emmanuel

Le 07/09/2010 14:37, Shree a écrit :

> Hi,
>
> I need help to sort out one issue in my environment. We have
> sybase
> ASE 12.5.4/EBF 16816 on
> production, QA& UAT. Database size is 240GB. The database
> load on QA
> from production takes approx 1.5 Hrs but same dump when
> loaded on UAT
> took more than 7 hours. I don't
> see any issues from sybase ASE side for this delay then what
> causing
> this delay. I suspect its OS or disk related problem. Is
> there any way
> to prove this and how to reduce the load time in this case.
> Let me
> know if you need any other details.
>
>
> Thanks
> Shree


"Mark A. Parsons" <iron_horse Posted on 2010-09-07 20:48:28.0Z
From: "Mark A. Parsons" <iron_horse@no_spamola.compuserve.com>
User-Agent: Thunderbird 1.5.0.10 (Windows/20070221)
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: ASE database load taking huge time on UAT server
References: <4c863206.5b1f.1681692777@sybase.com>
In-Reply-To: <4c863206.5b1f.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: <4c86a51c$1@forums-1-dub>
Date: 7 Sep 2010 13:48:28 -0700
X-Trace: forums-1-dub 1283892508 10.22.241.152 (7 Sep 2010 13:48:28 -0700)
X-Original-Trace: 7 Sep 2010 13:48:28 -0700, vip152.sybase.com
Lines: 44
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29545
Article PK: 78778

Not enough info ...

- what's the exact command used to dump the source database?

- what's the exact command used to load the target database?

- if doing a multi-stripe, decompression load ... do you have at least as many cpus as the number of stripes?
(decompression is cpu intensive so if you have more stripes than cpus you could be cpu bound)

- if doing a decompression load ... are there other cpu intensive processes running on the same machine?

- are you loading from tape or disk?

- is there a network between the dump file(s) and the target dataserver? (network latency can easily cause a load to run
longer)

- if loading from a 'local' disk, have you taken a look at iostat data for said disks to see if they are running slow?

- have you tried monitoring the database devices (with iostat) that the target database resides on? (slow disks here
can delay the speed at which the backupserver can write to the database devices)

Shree wrote:
> Hi,
>
> I need help to sort out one issue in my environment. We have
> sybase
> ASE 12.5.4/EBF 16816 on
> production, QA & UAT. Database size is 240GB. The database
> load on QA
> from production takes approx 1.5 Hrs but same dump when
> loaded on UAT
> took more than 7 hours. I don't
> see any issues from sybase ASE side for this delay then what
> causing
> this delay. I suspect its OS or disk related problem. Is
> there any way
> to prove this and how to reduce the load time in this case.
> Let me
> know if you need any other details.
>
>
> Thanks
> Shree


Cory Sane [TeamSybase] Posted on 2010-09-08 03:06:56.0Z
From: "Cory Sane [TeamSybase]" <cory!=sane>
Newsgroups: sybase.public.ase.general
References: <4c863206.5b1f.1681692777@sybase.com> <4c86a51c$1@forums-1-dub>
In-Reply-To: <4c86a51c$1@forums-1-dub>
Subject: Re: ASE database load taking huge time on UAT server
Lines: 52
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=response
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Windows Mail 6.0.6002.18197
X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6002.18197
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4c86fdd0$1@forums-1-dub>
Date: 7 Sep 2010 20:06:56 -0700
X-Trace: forums-1-dub 1283915216 10.22.241.152 (7 Sep 2010 20:06:56 -0700)
X-Original-Trace: 7 Sep 2010 20:06:56 -0700, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29546
Article PK: 78777

check the memory definition in the backup server Run_file.


--
Cory Sane
[TeamSybase]
Certified Sybase Associate DBA for ASE 15.0

"Mark A. Parsons" <iron_horse@no_spamola.compuserve.com> wrote in message news:4c86a51c$1@forums-1-dub...
> Not enough info ...
>
> - what's the exact command used to dump the source database?
>
> - what's the exact command used to load the target database?
>
> - if doing a multi-stripe, decompression load ... do you have at least as many cpus as the number of stripes?
> (decompression is cpu intensive so if you have more stripes than cpus you could be cpu bound)
>
> - if doing a decompression load ... are there other cpu intensive processes running on the same machine?
>
> - are you loading from tape or disk?
>
> - is there a network between the dump file(s) and the target dataserver? (network latency can easily cause a load to run
> longer)
>
> - if loading from a 'local' disk, have you taken a look at iostat data for said disks to see if they are running slow?
>
> - have you tried monitoring the database devices (with iostat) that the target database resides on? (slow disks here
> can delay the speed at which the backupserver can write to the database devices)
>
>
> Shree wrote:
>> Hi,
>>
>> I need help to sort out one issue in my environment. We have
>> sybase
>> ASE 12.5.4/EBF 16816 on
>> production, QA & UAT. Database size is 240GB. The database
>> load on QA
>> from production takes approx 1.5 Hrs but same dump when
>> loaded on UAT
>> took more than 7 hours. I don't
>> see any issues from sybase ASE side for this delay then what
>> causing
>> this delay. I suspect its OS or disk related problem. Is
>> there any way
>> to prove this and how to reduce the load time in this case.
>> Let me
>> know if you need any other details.
>>
>>
>> Thanks
>> Shree


shree Posted on 2010-09-08 11:38:57.0Z
Sender: 7358.4c8774eb.1804289383@sybase.com
From: Shree
Newsgroups: sybase.public.ase.general
Subject: Re: ASE database load taking huge time on UAT server
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4c8775d1.736c.1681692777@sybase.com>
References: <4c86fdd0$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 8 Sep 2010 04:38:57 -0700
X-Trace: forums-1-dub 1283945937 10.22.241.41 (8 Sep 2010 04:38:57 -0700)
X-Original-Trace: 8 Sep 2010 04:38:57 -0700, 10.22.241.41
Lines: 69
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29548
Article PK: 78780

Checked the memory defination in Run_file for backup server
its same on both QA and UAT servers. See below.
Run file:
/opt/bus/sybase/ASE-12_5/bin/backupserver \
-e/opt/bus/sybase/ASE-12_5/install/BUS_QA_BCK.log \
-SBUS_QA_BCK \
-P32 \
-N32 \
-C96 \
-M/opt/bus/sybase/ASE-12_5/bin/sybmultbuf \
-m2016 \

> check the memory definition in the backup server Run_file.
>
>
> --
> Cory Sane
> [TeamSybase]
> Certified Sybase Associate DBA for ASE 15.0
> "Mark A. Parsons" <iron_horse@no_spamola.compuserve.com>
> > wrote in message news:4c86a51c$1@forums-1-dub... Not
> > enough info ...
> > - what's the exact command used to dump the source
> > database?
> > - what's the exact command used to load the target
> > database?
> > - if doing a multi-stripe, decompression load ... do you
> > have at least as many cpus as the number of stripes?
> (decompression is cpu intensive so if you have more
> > stripes than cpus you could be cpu bound)
> > - if doing a decompression load ... are there other cpu
> > intensive processes running on the same machine?
> > - are you loading from tape or disk?
> >
> > - is there a network between the dump file(s) and the
> target dataserver? (network latency can easily cause a
> > load to run longer)
> >
> > - if loading from a 'local' disk, have you taken a look
> at iostat data for said disks to see if they are running
> > slow?
> > - have you tried monitoring the database devices (with
> iostat) that the target database resides on? (slow disks
> > here can delay the speed at which the backupserver can
> > write to the database devices)
> >
> > Shree wrote:
> >> Hi,
> >>
> >> I need help to sort out one issue in my environment. We
> have >> sybase
> >> ASE 12.5.4/EBF 16816 on
> >> production, QA & UAT. Database size is 240GB. The
> database >> load on QA
> >> from production takes approx 1.5 Hrs but same dump when
> >> loaded on UAT
> >> took more than 7 hours. I don't
> >> see any issues from sybase ASE side for this delay then
> what >> causing
> >> this delay. I suspect its OS or disk related problem.
> Is >> there any way
> >> to prove this and how to reduce the load time in this
> case. >> Let me
> >> know if you need any other details.
> >>
> >>
> >> Thanks
> >> Shree