Batch -job monitoring
We have been facing performance issues, while batch jobs are running.
The jobs are taking long time to complete.
We need your help in monitoring it. Suggest what tcodes need to be used.
Workload analysis should start checking transaction SM50/SM66 in order to see what is going
on the DB (sequential read, full table scan...) and the table or program that is causing
Useful transactions are ST06 (operating system analysis) and ST04 (DB analysis).
After detecting the main probable cause, you should run stats for the table detected or
evaluate why is taking so long, maybe a solution could be creating index. Sometimes HW or network are the bottle-necks.
The access path for every high sql sentence is given in ST04. If you detect standard programs you should
find SAP notes in order to improve performance.
Hope it helps.
Best regards from Peru.