Average response time is very high

[Former Member]

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

[Former Member]

Hi,

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

how many DIA work processes you running.

Regards

Mark

[Former Member]

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

[Former Member]

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.