SAP Background job affect system performance

[Former Member]

Dears:

i have some questions about the relationship between sap background job and system performance:

1. Is there any method to identify if it is the running background job affect the system performance when the system is slow? But we can't cancel any background job at that moment.

2. If we list all the background job in sm37 which running in office hour, can we identify which background job mayl affect system performance if they run?

As i know system slow can cause by many factor, but is there any method we can use to make sure the system slow is not caused by the background job at that moment. Even if we find some background job is running for a long time.

[Former Member]

The first place to look would be SM50. That should at least show what is running on the App server and give you a basic idea of which job is consuming resources. Beyond that, you might want to check the transaction profiles in ST03N (select Task Type 'Background') to see which background processes are using the most average CPU, DB time, and amount of requested data.

Hope that helps.

J. Haynes

[Former Member]

Hi

Get the max. CPU utilization work process/ DB sessions PID list from OS level or ST06 ( Top CPU load).

if the processes in BG processes , Check/find the job name as per the PID in "job history" and Analysis the Job (fine tune the select query or change the schedule)

if the processes in DB sessions , check/find the session query in ST04 -> DB sessions and analysis the query have proper secondary index for the where clause fields or fine tune the query .

Regards,

Sureshram.