Skip to Content

Understanding High Processing Time (ST03N)

Hi guys.

After reviewing a couple of long running jobs, i came up with this one which has odd values

# Calls 600.000

DB Records 58.829

Seq Records 112.107

Sequential reads 378.211

Direct Reads 26.690

Accesses 162.963

CPU Time 74031 ms

CPIC-/RFC Time (ms) 0 ms

response time (ms) 21296994 ms

Waiting Time (ms) 0 ms

Processing time (ms) 21116018 ms

Load time (ms) 13 ms

Generation time 0 ms

Roll-In + wait time (ms) 1 ms

Database time 180962 ms

# Views Datenbankproz. 0

Total time DB Procedures 0 ms

Off Time ms) 0 ms

Block number 0 ms

Report Load time 8 ms

Load time screen (ms) 0 ms

CUA load time (ms) 5 ms

Roll-in operations 14

Roll-out processes, 12

Roll-In-Time (ms) 1 ms

Roll-out time (ms) 1 ms

Roll Wait Time (ms) 0 ms

As you can see, 99% of Response Time, comes from Processing Time, but there is little CPU Time & Database time, and none waiting.

Does it means CPU Bottlenecks? How can you breakdown Processing Time values to determine what is causing this?

Which notes are helpful to understand this? I came with these notes but any explanation would be appreciated.

Note 1014072 - High response time in transaction STAD or ST03 or ST03Nb

Note 8963 - Definition of SAP response time/CPU time

Note 376148 - Response times without GUI time

Note 805934 - FAQ: Database time

Note 110686 - Different response times ST03, ST07

Thanks a lot for you help.

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    Posted on Aug 05, 2013 at 03:52 PM

    Thanks for the help understanding this concept

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 29, 2013 at 10:39 PM

    Hi Martin,

    First of all, note 8963 says: "Processing time = response time".

    And Performance Analysis in SAP is a very very big area.

    I'm more interested in this figure: Sequential reads 378.211 Direct Reads 26.690

    Mainly, Direct Read refers to accesses in which a maximum of one line is returned by the database, otherwise Sequential Read refers to all other read database accesses, in which there may be more than one line returned.

    In case of Sequential Read, when you perform a trace on these queries you will see that index is used in most cases. However Direct Read have better performance than Sequential.

    So my idea is to check what the job really does, which tables are being read sequentially (SM50 while the job is running), and which SQL statements might be expensive (ST05, execution plan).

    Then you can check if those tables are being read using indexes (if not, maybe create new index), also check if the daily update statistics of your database is running (SM13), also check if buffers are not "red" (ST02), and maybe have an ABAP-er recheck the SQL-statements to optimize them.

    It could also helpful to check the database area (parameters) as well, but you need to check the figures on ST04 to be able to analyze this.

    So again, this is only my tips to check with the info you are providing, and not all conclusive by any means.

    I hope this will help you.

    Regards,

    Andre

    Add a comment
    10|10000 characters needed characters exceeded

    • Hello Mr.Wahjudi,

      fyi,,Note 8963 never said "Processing time = response time"... It mentions few metrics which has to be deducted from response time while calculating "Processing time".

      Processing time = response time

      "- " Wait time the dispatcher is waiting for a free

      work process (= dispatcher queue).

      "-" Load/generating time for loading/generating

      screens, ABAP programs, and CUA

      elements (not in presentation).

      "-" DB time for accessing and waiting for the data-

      base interface and, therefore, for the

      underlying database.

      "-" Roll-in time for the roll-in of the roll area

      context of a dialog step and possibly

      for a dialog step that is waiting for RFCs

      (as of Rel. 4.0A, also called 'roll wait

      time', see below for more information).

      "-" Enqueue time for setting a logical SAP enqueue.

      "-" DB procedure time time for processing DB procedures

      in the database (as of Rel. 4.6C; for

      example, in liveCache).

      Thanks & Regards,

      Ravindran D'

  • Posted on Jul 29, 2013 at 09:34 PM

    Hi Martin

    Could you share the OS /DB info and also during those peaks check the ST02 status?

    Thanks

    Ram

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.