Skip to Content
avatar image
Former Member

Batch -job monitoring

Hello All,

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.

Thanks!

Sujit

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Mar 01, 2011 at 07:47 PM

    Dear Sujit,

    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

    the overload.

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 25, 2011 at 08:30 AM

    Are the jobs consuming many resources from your database? Do you see many sequential reads in transaction SM66?

    Check with st04 if heavy SQL statements are being executed, do you see exclusive lock waits, etc.

    Kind regards,

    Mark

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      First thing I would do is generating the DB stats for the table which has long sequential reads. Then use the SQL trace and analyse the sql statement if it is using a index range scan or a full table scan? Then check if there is any problem with the index or check for table reorg. So you have many differnet parameters to check, you can start with these......

      Regards,

      Vamshi.

  • avatar image
    Former Member
    Dec 28, 2011 at 07:22 AM

    Hi all

    Some background jobs are taking long time to complete in production BW system. Please suggest me what to do

    Add comment
    10|10000 characters needed characters exceeded