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.

pastedimage_2_202199-6024294

DB14 logs below

pastedimage_0_202219-2113188

pastedimage_0_202220-2035914

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.

pastedimage_0_202221-4986183

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

pastedimage_0_202222-8054790

pastedimage_4_202217-9819489

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

pastedimage_5_202218-6655339

SQL query after changes done by ABAP team

pastedimage_12_202209-9157388

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)

New NetWeaver Information at SAP.com

Very Helpfull

 

 

User Rating: Be the first one !