RE: Multiple processors

IF job is CPU bound and IF workload can be run in parallel, either by
submitting another job that does "half" the work OR job is running SQL and
SMP feature is installed and turned on.

That said, my experience is that it's rarely the CPU issue but rather I/O or
simply process has to be serialized (i.e. one thing has to be done before
another one can).

Celebrating 10-Years of SQL Performance Excellence

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Steve McKay
Sent: Thursday, January 11, 2007 10:36 AM
To: midrange-l@xxxxxxxxxxxx
Subject: Multiple processors

We have a partition which runs *one* batch job and one interactive session 
for the operator that checks on the batch job occasionally.  This batch job 
runs for days at a time and when it finishes, another similar job is kicked 
off by the operator.  We want to reduce the run time of the batch job.  One 
suggestion is to add another processor to the partition.  I'm not convinced 
that adding another processor will improve the run time.  So my dumb 
question for today is:

Will adding another processor to a partition running a single batch job 
decrease the run time of the batch job?

Thanks,

Steve