ST03N: Workload Monitor [Monitoring]
Hint: > 2x of CPU time
Hint: 40% of response time]
Probs: CPU bottleneck
Go to Detail Analysis Menu -> Top CPU , check existence of Non-SAP (external) programs by sorting by CPU time. Try to run these external programs in offline hours.
Check for any swapping happening in all the buffers. If there is high swapping for any buffer, increase the size of the buffer.
Response time – The time when a dialog process sends a request to a dispatcher work process, and the dialog is complete and the data is transferred to the presentation layer. The response time does not include the time for transferring the data from the SAP front end to the application server.
Wait time – The time when a user request sits in the dispatcher queue. It starts when user request is entered in the dispatcher queue; and ends when the request starts being processed.
Probs: long running tasks, locked tasks, not enough work process
Look for all the configured work processes are in Waiting or Running state. If all the wotk processes are running state, then increase the number of Dialog work processes.
This monitor will help to analyse the total work processes configured in all the servers and instances.
Hint: DB calls/requests good ratio is 1:10 = efficiency table buffering
Hint: 40% of response time
Probs: CPU/memory bottleneck on DB server, expensive SQL statement, missing indexes, small buffer, missing statistics
- Database buffer quality (> 95%), if <, increase database buffer cache size.
- Reads/User Calls (< 30), if >, the expensive SQL statements need to be tune. Some of expensive SQLs statement problems:
i) incorrect index access (Solution = create new index or reorganize the index)
ii) high table size (Solution = archive the old entries)
Hint: < 10% of response time, < 50ms
Probs: Program buffer, CUA buffer, screen buffer too small
GUI time – Response time between the dispatcher and the GUI during the roundtrips (roundtrips are communication steps between the SAP system and the front end during a transaction step).
Probs: network between GUI & SAP]
Go to Detail Analysis Menu -> LAN Check by PING. If there is high Avg. time or Loss time for any presentation servers, means there are some settings need to be change for the presentation server.
Execute PROFGEN_CORR_REPORT_5 report. From the output check if any user assigned with > 1000 user menu nodes.
Hint: < 20ms
Probs: SAP memory configuration (extended memory, roll buffer)
Hint: < 200ms