CPU idle time
Did the performance problem occur in the past?
Which user is experiencing the problem?
Is the problem happening right now?
How close is it to quitting time?
High CPU utilization near 100%
High CPU idle time
High swap/paging activity
High DB time
SAP Management Console
Executable program sappfpar
SQL statement which requires many records to be transferred to the ABAP program.
SQL statement which uses index during data retrieval.
SQL statement which reads many blocks but retrieves only a few records from the database.
SQL statement which uses table buffering.
SQL Monitor can be switched on for all or dedicated servers.
SQL Monitor is designed to trace a single process.
SQL Monitor can trace every SQL statement coming from ABAP programs, which include all OPEN SQL, native SQL, and ABAP kernel SQL statements.
SQL Monitor has low impact on the performance of the production system.
SQL statements used by ABAP programs
SQL statements used by SAP Basis Tables
Recursive SQL statements
SQL statements used by Database Administration Tools
Execution plan (table/index access)
Estimated costs/Estimated rows
Single record buffered
Generic area buffered
Client specific buffered
Tables that are seldom changed.
Large tables that are often accessed.
Here's an interesting quiz for you.