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 the user:
- 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 parameters...
- 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 "quick-and-dirty"doing "select *" and other things.
For e.g.:
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 narrow down.
0 Comments