Tuesday, 26 November 2013

ST03 Workload Monitor in SAP



ST03N is used to analyze statistical data for the ABAP kernel and monitor the performance of a system. You can display the total values for all instances, and compare the performance of particular instances over a period of time.

The workload overview provides system administrators with various detailed information about the most important workload data, such as the CPU time, the number of database changes, the response times, and so on. You can display the workload overview for all task types (Dialog, Background, RFC, ALE, and Update), or only for one particular task type.

Workload Overview :-



Processing time – This is equivalent to response time minus the sum of wait time, database request time, load time, roll time, and enqueue time
Hint: > 2x of CPU time
Probs: Hardware

CPU time – A work process uses the CPU.
Hint: 40% of response time]
Probs: CPU bottleneck
Solution:
In ST06,
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.
In ST02,
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.
Hint: 1 second (dialog), <1 second (update)

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.
Hint: < 10% of response time
Probs: long running tasks, locked tasks, not enough work process
Solution:
In
SM50,
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.
In SM66,
This monitor will help to analyse the total work processes configured in all the servers and instances.

DB calls – Number of parsed accesses to the database.
Hint: DB calls/requests good ratio is 1:10 = efficiency table buffering

DB requests/DB Time – The time when a database request is put through to the database interface & when the database interface has delivered the result.
Hint: 40% of response time
Probs: CPU/memory bottleneck on DB server, expensive SQL statement, missing indexes, small buffer, missing statistics
Solution:
In
ST04,
- 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)

Average load & generation – The time needed to load and generate objects.
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).
Hint: < 200ms
Probs: network between GUI & SAP]
Solution:
In ST06,
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.
In SE38,
Execute PROFGEN_CORR_REPORT_5 report. From the output check if any user assigned with > 1000 user menu nodes.

Roll in time -  The time needed to roll user context information into the work process.
Hint: < 20ms
Probs: SAP memory configuration (extended memory, roll buffer)

Roll wait time – Queue time in the roll area.
Hint: < 200ms
Probs: network between GUI & SAP

24 comments:

  1. Thanks for sharing such useful information on the blog and refer the link Oracle Training in Chennai

    ReplyDelete
  2. http://www.androidtraininginchennai.in26 February 2015 at 01:35

    Awesome Blogs share more information and refer the link Android Training in Chennai

    ReplyDelete
  3. Oracle Training in Chennai26 February 2015 at 01:36

    Awesome Blogs share more information and refer the link Oracle Training in Chennai

    ReplyDelete
  4. I get a lot of great information from this blog. Recently I did oracle certification course at a leading academy. If you are looking for best Oracle Training in Chennai visit FITA IT training and placement academy which offer SQL Training in Chennai.

    ReplyDelete
  5. Your blog is really useful for me to get some technical information. Recently I did Oracle Training in Chennai at FITA located at Chennai. They give professional and job oriented training for all students.This is really very useful for me.

    ReplyDelete
  6. I get a lot of great information from this blog. Thank you for your sharing this informative blog. Just now I have completed hadoop certification course at a leading academy. If you are interested to learn Hadoop Training in Chennai visit FITA IT training and placement academy which offer Big Data Training in Chennai.

    ReplyDelete
  7. very nice blogs!!! i have to learning for lot of information for this sites...Sharing for wonderful information.
    AWS course chennai | AWS Certification in chennai | AWS Certification chennai



    ReplyDelete

  8. I get a lot of great information from this blog. Thank you for your sharing this informative blog.
    VMWare Training in chennai | VMWare Training chennai | VMWare course in chennai

    ReplyDelete
  9. Thanks for posting the useful information to my vision. Java is a programming language, now a day lots of websites & application created using java, because it’s more secure than others and reliable too. The popular JAVA Training institute has located in Chennai helps you to get your bright career.

    JAVA Training in Chennai | JAVA Training Institutes in Chennai

    ReplyDelete
  10. Excellent Post, I welcome your interest about to post blogs. It will help many of them to update their skills in their interesting field.
    Regards,
    sas training in Chennai|sas course in Chennai|sas training center in Chennai

    ReplyDelete
  11. Thanks for splitting your comprehension with us. It’s really useful to me & I hope it helps the people who in need of this vital information.
    Regards,
    ccna course in Chennai|ccna training in Chennai|ccna training institute in Chennai

    ReplyDelete
  12. Good Post! Thank you so much for sharing this pretty post, it was so good to read and useful to improve my knowledge as updated one, keep blogging…
    Regards,
    Oracle DBA Training in Chennai|Oracle apps Training in Chennai|Oracle Training

    ReplyDelete
  13. All are saying the same thing repeatedly, but in your blog I had a chance to get some useful and unique information, I love your writing style very much, I would like to suggest your blog in my dude circle, so keep on updates…
    Regards
    Angularjs training in chennai|Angularjs training chennai|Angularjs course in chennai|Angularjs training center in Chennai

    ReplyDelete
  14. this blog is really awesome , i got many information it is really good and informative too thanks for nsharing these information.


    ccna training in chennai

    ReplyDelete
  15. workload monitor in the sap training..
    Hadoop online training .All the basic and get the full knowledge of hadoop.
    hadoop online training

    ReplyDelete
  16. I have read your blog its very attractive and impressive. I like it your blog.

    Java Training in Chennai Java Training in Chennai | Core Java Training in Chennai

    Online Java Training Java Online Training | Java J2EE Online Training | JavaEE Training Institute in Chennai

    ReplyDelete
  17. It was very nice blog to learn about SAP BASIS. Thanks for sharing.SAP basis

    ReplyDelete
  18. It was very nice blog to learn about SAP BASIS. Thanks for sharing.
    sas training in Chennai

    ReplyDelete
  19. It was very nice blog to learn about SAP BASIS. Thanks for sharing.
    oracle training in chennai

    ReplyDelete
  20. very nice blogs!!! i have to learning for lot of information for this sites...Sharing for wonderful information.
    unix training in chennai

    ReplyDelete