uneven use on dual processors 
Author Message
 uneven use on dual processors
I have a server with Dual Xeon PIII processors.   I am noticing that
when the server is under a heavy load (11.51) the processors are
not being used evenly.   One processor will be at 95% while
the second one is at  40-60%.     Is there a way to distribute
the load via execution classes so that the load is more evenly
distributed?  Would this by me anything?

Ted



Wed, 23 Apr 2003 13:53:45 GMT
 uneven use on dual processors

how many engines? two? if not, set the max no. of engine to two.

benny

Quote:

>I have a server with Dual Xeon PIII processors.   I am noticing that
>when the server is under a heavy load (11.51) the processors are
>not being used evenly.   One processor will be at 95% while
>the second one is at  40-60%.     Is there a way to distribute
>the load via execution classes so that the load is more evenly
>distributed?  Would this by me anything?

>Ted



Wed, 23 Apr 2003 03:00:00 GMT
 uneven use on dual processors
There are 2 processors.  I have the max online engines set at 2 and the
minimum online engines set at 1.

Ted


Quote:
> how many engines? two? if not, set the max no. of engine to two.

> benny


> >I have a server with Dual Xeon PIII processors.   I am noticing that
> >when the server is under a heavy load (11.51) the processors are
> >not being used evenly.   One processor will be at 95% while
> >the second one is at  40-60%.     Is there a way to distribute
> >the load via execution classes so that the load is more evenly
> >distributed?  Would this by me anything?

> >Ted



Wed, 23 Apr 2003 03:00:00 GMT
 uneven use on dual processors

Ted,

On a two-engine server, the 0 engine is probably going to be doing all
the housekeeping tasks, so it's not out of line for it to be doing more
work than the other.  There are configuration parameters that can be set
to control the amount of housekeeping that's done, but you probably
don't want to mess with them if you don't have to.

Also, you can assign processes and/or login ids to a particular server
engine by defining an execution class, associating it with an engine,
and then binding processes and/or logins to that execution class.  I
think this is explained in Chapter 22 of the Performance and Tuning
manual.

Still, I'm mostly inclined to let Sybase allocate resources among
engines as it thinks best, until something really bogs down,
performance-wise.  Then I deal with that one issue.  I don't tune
anything unless I have to; this philosophy has saved me much grief over
the years.

Hope this helps,

                                Larry Burns



Quote:
> There are 2 processors.  I have the max online engines set at 2 and
the
> minimum online engines set at 1.

> Ted



> > how many engines? two? if not, set the max no. of engine to two.

> > benny


> > >I have a server with Dual Xeon PIII processors.   I am noticing
that
> > >when the server is under a heavy load (11.51) the processors are
> > >not being used evenly.   One processor will be at 95% while
> > >the second one is at  40-60%.     Is there a way to distribute
> > >the load via execution classes so that the load is more evenly
> > >distributed?  Would this by me anything?

> > >Ted

Sent via Deja.com http://www.deja.com/
Before you buy.


Sat, 26 Apr 2003 08:04:10 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. Can you allocate one processor in a dual processor system for sql 7

2. Single processor or dual processor license

3. dual processor /License and number of processors

4. Dual Processor v Single Processor

5. Single processor SQL 2000 on dual processor server

6. Using NT Dual Processor for Oracle 7.3+ Enterprise for NT

7. PERFOMANCE LOST ON DUAL PROCESSORS

8. sql under dual processor system - problem

9. Does Windows 98 support dual processors?

10. Dual Processor Question...

11. Single file DTS import with dual processors


 
Powered by phpBB® Forum Software