Tuning Summary In Transaction ST02
My current system is SAP R/3 Enterprise 4.70. I have some questions
about tuning summary in transaction ST02 :
A D V E R T I S E M E N T
To the best of my knowledge I am answering your questions. Ok
1. Do we have to increase every profile parameter value which is displayed
in red alert in transaction ST02 ?
Ans: Ofcourse it shoud be, since each buffer holds different values, wherever
the red alert is there change the parameter value.
2. Why do the swapped objects always increase after a few days of tuning
(in RZ10) & system restart?
Ans: Since more data had been fed into the server, it needs more space to
hold in buffer while retrieving the data. Since buffer is shot in space, swap
memory will be used. It is not enough to increase the buffer and that does not
mean tuning, tuning in the sense full analysis of the problem and working in
that particular area to resolve the issue. For example, creation of index, data
archival, availability of statistics, alotting of no. of work process, etc.
3. Is there any standard in tuning ST02 to hold up the increasing value of
Ans: No. It depends on requirement.
4. After analysing ST02, how can we calculate the value of the parameter
profile to be increased (in RZ10) ?
Ans: yes, use the command:
sappfpar check pf=\\usr\sap\trans\tpparam
sappfpar check pf=\\usr\sap\trans\tp_domain_<sid>
Troubleshooting SAP Performance Issues
Is there a document that will help me troubleshoot system performance?
What are the steps on how to troubleshoot?
Troubleshooting is a BIG task of itself, there is no single reference
document because there are too many reasons why a system can appear "slow" to
- Different Databases
Every database has its own mechanism for optimizing access, even more, each
database has BOOKS on performance optimization. This can start from parameters
to database layout to operating system configuration, used filesystems, mount
- Different Operating System
The same goes for operating systems, a standard Windows 2000 (or 2003) isn΄t
configured for optimal throughput, there is a LOT to tune, e. g. enable
"background process priorities", stop non-needed services, network
configurations (TCP window sizes) etc. Also the connection between application
and database servers can be an issue
- SAP Itself
Almost for each and every long running program there are optimizations, be it
on ABAP layer or on selection layer. Out of my experience, most self developed
programs (Z*-programs) are the main issue, because developers program
doing "select *" and other things.
If CPU is 100% Busy, what action should be taken to keep CPU idle?
This can't be answered generally. One need to check what process is using so
much CPU - then one can start digging deeper. To add info regarding this issue,
you may use:
st06->details analysis menu->snapshot analysis->top CPU from there, start to