Where can I find information on the SQL statements executed?
The central source of information for SQL statements is transaction DB50 -> Problem Analysis -> Performance -> SQL Performance The Command Monitor and the Resource Monitor in particular are the tools used to analyze long SQL statements. a) Command Monitor (Diagnosis Monitor) The Command Monitor is designed for short-term analysis and should only be activated during an analysis. If the Command Monitor is not activated, no data is available for analysis. For an initial analysis, you can start the Command Monitor with the default values using ‘Change monitor settings’: Number of page accesses: >= 1.000 Runtime of SQL statement: >= 1,000 ms Selectivity: <= 10% Save parameter values: X Number of monitoring entries: 3.000 Once the Command Monitor has been activated, all commands that correspond to at least one of the recording criteria is recorded in the Monitor. If the maximum number of monitoring entries has been reached, the commands are overwritten cyclically, and the oldest commands are
