Performance Optimization during the Data Archiving Initial runs

[Former Member]

Dear Experts,

We are running archiving jobs (Write Job & Preprocessing Jobs) which are running for nearly 56hrs. It is writting and analyzing nearly 4 million records.

Any suggestions to improve the performance for running these jobs to complete in less time. Its ISU Archiving.

I have gone through Many SAP Notes, but i'm unable to find related to improving performance during the archival runs. These are initial runs.

Thank You,

Mahesh C

[Former Member · Accepted solution]

You should check the sql statements that are being executed by these runs.. Possibly by adding additional indexes you can speedup the process.

Kind regards,

Mark

[former_member204746]

analyze SQL requests made by this program with ST05. then, it might be useful to add an index based on the WHERE clause of long running SQL requests.

[Former Member]

Hi Mark & Eric,

Thanks for the suggestions. We will analyse the sql statements if there needed we try to add INDEX.

Mahesh