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.

Batch Process

4 posts in General Discussion Last posting was on 2011-05-25 04:13:58.0Z
RGS Posted on 2011-05-20 21:12:27.0Z
Sender: 6a0d.4dd2f3d8.1804289383@sybase.com
From: RGS
Newsgroups: sybase.public.ase.general
Subject: Batch Process
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4dd6d93b.612e.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 20 May 2011 14:12:27 -0700
X-Trace: forums-1-dub 1305925947 10.22.241.41 (20 May 2011 14:12:27 -0700)
X-Original-Trace: 20 May 2011 14:12:27 -0700, 10.22.241.41
Lines: 10
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30192
Article PK: 72370

If I am running a batch stored procedure (a program that
process a lot of accounts via cursor and inside a cursor
there are sentences like select, insert, update, delete) and
asume I have only one processor in the machine then:

All of the time the use of processor will be 100%? Or, a
portion of time, the program use disk (I/O) and NOT always
the use of processor will be 100%?

Thanks!


Michael Peppler [Team Sybase] Posted on 2011-05-21 07:06:36.0Z
From: "Michael Peppler [Team Sybase]" <mpeppler@peppler.org>
Organization: Peppler Consulting SARL
Subject: Re: Batch Process
User-Agent: Pan/0.14.2 (This is not a psychotic episode. It's a cleansing moment of clarity.)
Message-ID: <pan.2011.05.21.07.06.35.810200@peppler.org>
Newsgroups: sybase.public.ase.general
References: <4dd6d93b.612e.1681692777@sybase.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 21 May 2011 00:06:36 -0700
X-Trace: forums-1-dub 1305961596 10.22.241.152 (21 May 2011 00:06:36 -0700)
X-Original-Trace: 21 May 2011 00:06:36 -0700, vip152.sybase.com
Lines: 17
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30195
Article PK: 72374


On Fri, 20 May 2011 14:12:27 -0700, RGS wrote:

> If I am running a batch stored procedure (a program that process a lot of
> accounts via cursor and inside a cursor there are sentences like select,
> insert, update, delete) and asume I have only one processor in the machine
> then:
>
> All of the time the use of processor will be 100%? Or, a portion of time,
> the program use disk (I/O) and NOT always the use of processor will be
> 100%?

It depends. If physical IOs are required, then the CPU will not be at 100%
during the execution of your batch. If no physical IOs are required then
you will most likely be very close to 100%.

Michael


RGS Posted on 2011-05-24 15:16:10.0Z
Sender: 4ee.4ddbcb47.1804289383@sybase.com
From: RGS
Newsgroups: sybase.public.ase.general
Subject: Re: Batch Process
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4ddbcbba.4fa.1681692777@sybase.com>
References: <pan.2011.05.21.07.06.35.810200@peppler.org>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 24 May 2011 08:16:10 -0700
X-Trace: forums-1-dub 1306250170 10.22.241.41 (24 May 2011 08:16:10 -0700)
X-Original-Trace: 24 May 2011 08:16:10 -0700, 10.22.241.41
Lines: 21
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30199
Article PK: 72377

Excellent, thanks!

> On Fri, 20 May 2011 14:12:27 -0700, RGS wrote:
>
> > If I am running a batch stored procedure (a program that
> > process a lot of accounts via cursor and inside a cursor
> > there are sentences like select, insert, update, delete)
> > and asume I have only one processor in the machine then:
> >
> > All of the time the use of processor will be 100%? Or, a
> > portion of time, the program use disk (I/O) and NOT
> > always the use of processor will be 100%?
>
> It depends. If physical IOs are required, then the CPU
> will not be at 100% during the execution of your batch. If
> no physical IOs are required then you will most likely be
> very close to 100%.
>
> Michael
>


Cory Sane [TeamSybase] Posted on 2011-05-25 04:13:58.0Z
From: "Cory Sane [TeamSybase]" <cory!=sane>
Newsgroups: sybase.public.ase.general
References: <4dd6d93b.612e.1681692777@sybase.com> <pan.2011.05.21.07.06.35.810200@peppler.org>
In-Reply-To: <pan.2011.05.21.07.06.35.810200@peppler.org>
Subject: Re: Batch Process
Lines: 26
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original
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.18263
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4ddc8206$1@forums-1-dub>
Date: 24 May 2011 21:13:58 -0700
X-Trace: forums-1-dub 1306296838 10.22.241.152 (24 May 2011 21:13:58 -0700)
X-Original-Trace: 24 May 2011 21:13:58 -0700, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30200
Article PK: 72379

Note that options like "runnable process search count" can also affect the way the cpus are used. The default value is 2000,
this means to look for from the run queue 2000 times before jumping off the cpu.

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

"Michael Peppler [Team Sybase]" <mpeppler@peppler.org> wrote in message news:pan.2011.05.21.07.06.35.810200@peppler.org...
> On Fri, 20 May 2011 14:12:27 -0700, RGS wrote:
>
>> If I am running a batch stored procedure (a program that process a lot of
>> accounts via cursor and inside a cursor there are sentences like select,
>> insert, update, delete) and asume I have only one processor in the machine
>> then:
>>
>> All of the time the use of processor will be 100%? Or, a portion of time,
>> the program use disk (I/O) and NOT always the use of processor will be
>> 100%?
>
> It depends. If physical IOs are required, then the CPU will not be at 100%
> during the execution of your batch. If no physical IOs are required then
> you will most likely be very close to 100%.
>
> Michael
>