Yorkshireman
3200 pts. | Aug 3 2009 2:50PM GMT
Run Performance monitor whilst teh job is active and review the results.
PM will give you everything you need to discover where the problem is.
You’ll need to skip through the manual alongside the performance data - see if its disk bound - see which file(s) are the problem
then make some changes, run PM, compare results, make changes, run PM, compare results , make changes
you get the idea…
Whatis23
4040 pts. | Aug 3 2009 4:48PM GMT
If it is an existing job, verify if the job has been updated recently by your developement group. If the increase has been gradual, you may need to reorg the PF(s) it is using.






