Re: Session priorities

From: Tim X <timx_at_spamto.devnul.com>
Date: 25 Feb 2003 18:52:17 +1100
Message-ID: <87u1esiyq6.fsf@tiger.rapttech.com.au>

>>>>> "Ron" == Ron Boggs <rboggs_at_endian-networks.com> writes:

 Ron> I am interested in methods used to give priority to one database  Ron> (or schema, or set of users, or application, etc) over another.

 Ron> We have a critical switch database running on one host which
 Ron> feeds data to a reporting database on another host.  For smaller
 Ron> environments, we are looking at ways those two database could
 Ron> reside on the same host.  The issue is giving the switch a
 Ron> higher priority over the sessions working on the reporting side.

 Ron> First of all, we tried resource manager and it was not
 Ron> applicable.  These servers rarely exceed 100% of CPU capacity

 Ron> and resource manager does not become effective at allocating CPU  Ron> util the load is 125% (or beyond).

 Ron> In plain English, what we need is a way to give sessions at the
 Ron> switch database priority over those at the reporting database.
 Ron> IOW...switch sessions should never (ok...rarely) wait for CPU
 Ron> time behind a reporting session.  I can't see where the future
 Ron> RM feature of fixed CPU allocation will address this in the way
 Ron> we need it to either.  If the server has 4 CPU's and the switch
 Ron> needs all 4 of them...that's what we want it to get.

 Ron> Has anybody had any success with a similar requirement?  Any way

 Ron> to 'nice' the server processes down for the reporting database  Ron> and have it remain effective until the database is shutdown?

 Ron> FYI...our database environments (typically) are Solaris 8.

 Ron> I appreciate any feedback.

 Ron> Ron Boggs St. Louis, MO

I'm a bit confused - if your not utilizing 100% cpu, then you have idle cpu cycles already, so your applications are not using all the available cpu, so how can you make them use more than they want/need? Maybe the problem isn't available cpu but insufficient memory, slow disk I/O, bus, etc?

Tim

-- 
Tim Cross
The e-mail address on this message is FALSE (obviously!). My real e-mail is
to a company in Australia called rapttech and my login is tcross - if you 
really need to send mail, you should be able to work it out!

Received on Tue Feb 25 2003 - 01:52:17 CST