hi all.
I have Aix 4.3.3.0 on RS6000 and Sybase 11.9.xx running on it.
We addess second CPU and finally I found a nice program to monitor also
CPU usage.

Running sybase and my monitor program (from www.bullfreeware.com, called
"monitor") i see that sybase always use first cpu, until 100% and second
until 3%.

I know I can change the behavior by using the bindprocessor utility of
Aix but I think bindprocessor just move application from a CPU to another
and this is not what i want.

I would like to parallelize CPU usage of Sybase on my server.

What can I do?

thanks in advance.

--
Massimiliano.

In article <pan.2003.08.19.10.19.48.952888@renodemedici.it> ,
massimiliano.adamoNOSPAM@renodemedici.it says...
> hi all.
> I have Aix 4.3.3.0 on RS6000 and Sybase 11.9.xx running on it.
> We addess second CPU and finally I found a nice program to monitor also
> CPU usage.
>
> Running sybase and my monitor program (from www.bullfreeware.com, called
> "monitor") i see that sybase always use first cpu, until 100% and second
> until 3%.
>
> I know I can change the behavior by using the bindprocessor utility of
> Aix but I think bindprocessor just move application from a CPU to another
> and this is not what i want.
>
> I would like to parallelize CPU usage of Sybase on my server.
>
> What can I do?

Covering the obvious things first :

- did you configure Sybase to use an additional engine?
- do you have a multiple and concurrent user workload?

Adding a CPU and configuring ASE to use an additional engine will
not be much use if, for example, you have a single-threaded batch
process. (Well, unless it was using parallel query.)

Are those utilisation figures as reported by AIX (CPU) or by
Sybase (engine)?

Cheers,
--
Joe Woodhouse
Principal Consultant (former Sybase Technical Evangelist)
Prima Donna Consulting Pty Ltd
(IT. Business. Law. Children's Parties.)

On Tue, 19 Aug 2003 07:34:10 -0400, Joe Woodhouse wrote:

> In article <pan.2003.08.19.10.19.48.952888@renodemedici.it> ,
> massimiliano.adamoNOSPAM@renodemedici.it says...
>> hi all.
>> I have Aix 4.3.3.0 on RS6000 and Sybase 11.9.xx running on it. We
>> addess second CPU and finally I found a nice program to monitor also
>> CPU usage.
>>
>> Running sybase and my monitor program (from www.bullfreeware.com,
>> called "monitor") i see that sybase always use first cpu, until 100%
>> and second until 3%.
>>
>> I know I can change the behavior by using the bindprocessor utility of
>> Aix but I think bindprocessor just move application from a CPU to
>> another and this is not what i want.
>>
>> I would like to parallelize CPU usage of Sybase on my server.
>>
>> What can I do?
>
> Covering the obvious things first :

thanks for your answer.


> - did you configure Sybase to use an additional engine? - do you have a
> multiple and concurrent user workload?

I'm not really a DBA (I know a little MySQL and something other). What do
mean with "concurrent user workload"? I just know that I have lot of user
wich have acces to database and they can do query or other, concurrent or
not.
I heard about possiblity to use an additional engine. But I don't know how
to do.

> Adding a CPU and configuring ASE to use an additional engine will not be
> much use if, for example, you have a single-threaded batch process.
> (Well, unless it was using parallel query.)

Pls, tell me thinking I'm like just a children What do you mean with
"single threaded batch process" ?


> Are those utilisation figures as reported by AIX (CPU) or by Sybase
> (engine)?


I don't know exactly what Sybase do with SMP systems.

Here there is a repor of CPU usage ->

PID USER PRI NICE SIZE RES STAT TIME CPU% COMMAND
11122 sybase 100 0 8611k 4880k slp 5:11:34 58.4/3.0 dataserver

As you can see secon CPU is on 3% usage and never go up or go down.
First CPU usage move from 0% until 100% and second remain at 3.0% !

--
Massimiliano.