Controlling resources

[Bob Slater]

We are running HP-UX 10.20 on a 9000 D380 box. We use this as our database server for our QAD ERP package. The problem is that when accounting runns some of their reports they use so much of the resources that everyone else is slowed down to a snails pace. Is there a way to limit the amount of resources allocated to any given user or process?

[Hai Nguyen_1]

Bob,

I think that you have no way of controlling/allocating resources (CPUs,RAMs...) unless you purchase and install HP-UX process manager software.

Hai

[Steven E. Protter]

To reset process priority you need PRM. Thats the only way to limit things.

I also think you need to upgrade the OS first.

My soon to depart production box is a D380 it can run 11.00 and 11.11.

I think you are SOL at your current OS level.

I have attached some scripts that might allow you to track down the problem and tune the box a bit.

SEP

[Jim Mallett]

PRM is a "purchasable" that will do exactly what you want.

You can also do a: man ulimit
I have yet to use ulimit for this, but it may get you by if you can't by the PRM product.

[curt larson_1]

hp does sell a product Process Resouce Manager which will do this. But, it would seem easier to limit when resouce intensive operations can be done.

I'm sure someone wrote code for generating the reports. just modify them to only run at off peak times or schedule them to run at off hours or what ever requirements you'd like to program, i.e. report A can run but only when report B isn't or report A can not be running more the 2 at a time etc.

or course the easiest method of using limited resources is for everyone to work together. I'm sure if you could identify the resouce intensive reports and provide suggestions for when they should be run, that you'll get cooperation. And, of course, point out the conseqences of not doing so, ie what happens to everyones else's productivity when things slow down.

probably not a bad time to bring to management attention that they need to start planning to upgrade this system, obvious performace problems, 10.20 isn't going to be supported all that much longer, etc.

the short answer is no. you'll need to make changes.

1) change behavior, ie run reports at different
2) change the reports, ie when they can run
3) change system, ie get faster cpu, more memory (you should check into weather additional memeory could be helpful), process resource management sofware, etc.

[Sunil Sharma_1]

Hi,
You can do it with HP Process resource manager
but it is an additional software required to be purchased.

you can use OS related stuff to do this by reducing process priority using nice.

Sunil

[Caesar_3]

Hello!

The best is to you PRM (procces resorce manager) that you have also for 10.20
You can try to use the nice command but it's
only nice.

Caesar

[malay boy]

Hi,
Your mention aboiut database.If the database is oracle then you can control the resouce used.

The step :
1) Set the RESOURCE_LIMIT parameter in init.ora file OR do alter system set resource_limit=true;

2) Create profile.Example :
Create profile ORACLE_ERP limit
CPU_PER_SESSION 10000
LOGICAL_READS_PER_CALL 800
PRIVATE_SGA 4000;

then assign the profile to the user.

hope this help

regards
mB

[Bill Douglass]

Have you analyzed what resource botlenecks are being hit during these reports? Then you could consider ways to minimize the impact of these reports.

Disk I/O - check with iostat, sar -b, sar -d
Memory Usage - vmstat, swaminfo
CPU - top, sar -u

glance is a good tool for this as well, and is a free d/l for 30-day eval.

http://openview.hp.com/products/gplus/tc_gplus_0001.html

Also check with y9our DBA on the SQL used in these reports. There may be ways to improve with the code or the database layout to improve performance.