3 Replies Latest reply: Nov 18, 2009 2:26 PM by Wim Van den Wyngaert RSS

Average response time is very high

Michael Noronha
Currently Being Moderated

My solman 7.0 ehp1 system is aving severe performance issue

the EWA states

 

System Performance     Active Users     102

     Avg. Response Time in Dialog Task     4205 ms

     Max. Dialog Steps per Hour     2486

     Avg. Response Time at Peak Dialog Hour     3225 ms

     Avg. Availability per Week     99 %

Database Performance     Avg. DB Request Time in Dialog Task     1658 ms

     Avg. DB Request Time in Update Task     236 ms

Database Space Management     DB Size     253.67 GB

     Last Month DB Growth     6.89 GB

 

 

Please let me know what to check and correct.

 

Task     Steps     Application Server Performance     Database Server Performance

Dia     125733            RED                                                   RED

 

 

Kindly suggest wht to check my OS is HPUNIX 11.23

 

DB:oracle 10g

 

<subject_modified>

Do not use capitals or abreviations on the subject

Next time your thread will be locked/deleted

 

Read the "Rules of Engagement"

 

Edited by: Juan Reyes on Nov 18, 2009 12:01 PM

  • Re: AVG RESPONSE tIME IS VERY HIG
    Alberto Castillo
    Currently Being Moderated

    Hi, could you post your HW for that server. Also, did you upgrade the system lately?. The AVG response times are really high and I don´t think this system (per DB size) is new so probably you did a system copy to different HW or and  upgrade as already mentioned.

     

    You could ask SAP for an Early Watch service also so they could give you the correct parameter values.

     

  • Re: AVG RESPONSE tIME IS VERY HIG
    Mark Norman
    Currently Being Moderated

    Hi,

     

    You could run an early watch alert report yourself on the server.   

     

    how many DIA work processes you running.

     

    Regards

     

    Mark

    • Re: AVG RESPONSE tIME IS VERY HIG
      Wim Van den Wyngaert
      Currently Being Moderated

      Hello,

       

      The best idea for the moment is to do an analysis yourself of your Solution Manager.

      Good starting point is transaction ST03N where you can see average response times over the last weeks and days.

       

      In ST03N you can also consult detailed reports.

       

      Based on the average response times in ST03N try to find out in ST03N if it is a CPU bottleneck or database problem.

       

      Afterwards go in detail with ST03N to find which reports or transactions have poor response times.

      Look also for SAP Notes based on the tcodes/programs with poor performance.

       

      There are also a lot of roadmaps and whitepapers explaining how to troubleshoot performance issues in SAP.

       

      Success.

       

      Wim

Actions