No of Jobs

Munish · Post by **Munish** » Sun Dec 10, 2006 11:57 pm

Hi All,
I got to execute 30 jobs which are infact loading the data into fact and summary tables.
Configuration: 12 CPU, each CPU duo core solaris
Logical nodes: 12

I was just wondering that
1. If the larger number of job running parallel will effect the overall performance

or

2, Should I restrict number of jobs.

Please let me know of your thoughts.

Cheers,
Munish

ray.wurlod · Post by **ray.wurlod** » Mon Dec 11, 2006 12:03 am

Monitor your system, using a tool like top or sar or similar. If you have spare capacity, you're OK. If you have no spare capacity, you should reduce the number of concurrent jobs until you do have some spare capacity, or add more capacity.

It's probable that some of the smaller jobs could be run on fewer nodes. More of these could then run concurrently.

Ultimately your key performance indicator is whether you can meet the available time windows with a safety margin to spare.

us1aslam1us · Post by **us1aslam1us** » Mon Dec 11, 2006 4:48 pm

It fairly depends on how much data (being processed) you are talking about?

Hey Ray i have seen that sar tool but it seems to be bit complicated as we need to install some other thing on the maching.
(i don't remember what else can be used but i feel top and iostat are best bet with ps)

Sam