Skip to Content

This blog gives a small insight into working on performance related issues. There will be many reasons for performance degradation and once such reason is below.

Users complained that tcode ZSDG_VIA was taking 5 to 6 minutes to process data which normally takes around1 minute. Checked sm66 and found the process is accessing table EDIDC. Updated the statistics for table EDIDC from DB20 but still performance was bad.

DB14 logs below

Below is tcode screen. We select variant in Settings tab below and click data. Then switch to Upload tab and click data. This should fetch the total number of errors data in 1 or 2 minutes.

Setup st12 trace and found below sql statement taking long processing time on table EDIDC

Worked with ABAP team and they changed the select query which is used to get the error IDOCs from EDIDC table. Earlier the program was considering all the error IDOCs but now it is consider only the last one month data in EDIDC table.

SQL query before changes done by ABAP team


SQL query after changes done by ABAP team

For performance tuning of SAP system the following standard tools included in the NetWeaver platform can be used.

1. Workload Monitor (ST03N)
2. Tune Buffers Monitor (ST02)
3. Statistical Records (STAD)
4. SQL Trace Analysis (ST05)
5. Workprocess Overview (SM50)
6. Operating System Monitor (ST06)
7. Table Call Statistics (ST10)
8. Database Activity (ST04)
9. Profile Maintenance (RZ10)
10. CCMS Monitoring (RZ20)

To report this post you need to login first.

3 Comments

You must be Logged on to comment or reply to a post.

  1. Bocaj GP

    Good Work Ranjith .. I felt the blog ended abruptly….you can come up with some general transcations and procedures to check for performance related issues in ABAP System

    Kind Regards,

    Jacob

    (0) 
    1. Ranjith Jacob Post author

      Hello Jacob,

      Thank you. I will definitely write something on st12, sm30, st05 which are all performance related transactions and their procedures very soon.

      Thanks,
      Ranjith

      (0) 
      1. Juan Reyes

        Performance issues in custom code 90% of the time are related to expensive SQL statements or poor use of indexes which should be spotted during QA testing.

        I agree with Jacob, you should add your own input into the blog and close it with your recomendations.

        After all if the blog does not reflect your opinion it’s simply a document.

        Regards, Juan

        (0) 

Leave a Reply