Job Monitoring

samsuf2002 · Post by **samsuf2002** » Thu Jan 22, 2009 2:36 pm

Is it helpful to turn off the job monitor to increase performance and reduce overhead ?

Thanks in advance

ray.wurlod · Post by **ray.wurlod** » Thu Jan 22, 2009 3:38 pm

Marginally. Maybe only negligibly. Depending on what you mean by "performance".

samsuf2002 · Post by **samsuf2002** » Thu Jan 22, 2009 7:59 pm

Performance in case of extracting data from Oracle by running user defined queries. We improved some performance by creating indexes on the source tables and we want to try some more options in different areas to enhance the performance.

So I was wondering if turning off the Job monitor could help.

ray.wurlod · Post by **ray.wurlod** » Thu Jan 22, 2009 9:05 pm

I have no idea what you mean by "performance". How would you propose to measure it? (A quick search will tell you of my firmly held belief that rows/sec is an almost toally meaningless metric.)

My previous answer was that of an economist - the performance monitor requires some resources; if it's not running those resources are available for other processes. If nothing else is running, then those other processes can be DataStage processes. Supply and demand.

miwinter · Post by **miwinter** » Thu Jan 22, 2009 10:28 pm

Samsuf, you have a partitioned DB..? Extracting in parallel...?