Parallel processing causing issues

[ManojYadav]

Dear All,

Need support on below query.

We have a custom program which runs in background every day to create/ change requirements. This program uses FM BAPI_REQUIREMENTS_CREATE / BAPI_REQUIREMENTS_CHANGE. Since we have millions of records and database commits, it takes huge time to finish the job. To improve the performance we implemented parallel processing ( ref. Implementing Parallel Processing (sap.com) ). It has improved performance more than 40-50%.

We don not see any issues if run 3-4 parallel jobs. But if we increase the job numbers like 5, 6 etc., it causes issues like update processes are full, overloading system update queue, CPU bottleneck .

How this can be resolved from ABAP side and BASIS side to get maximum improved performance without causing system issues

Thank you.

Regards,

Manoj

[Sandra_Rossi]

Difficult to say anything about all these performance issues. It requires analysis at your side. Ask an expert from SAP Consulting or any ABAP/basis expert.

[S_Sriram]

Hi Manoj,

During the parallel process, what is the load on the database instance? if possible could you share the OS/ DB version and database instance hardware resource details?

Regards

SS