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
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
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.
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.