M_Expensive statement in SAP HANA

This can be checked using system view M_EXPENSIVE_STATEMENTS.

SELECT * FROM M_EXPENSIVE_STATEMENTS

In SAP HANA, the M_EXPENSIVE_STATEMENTS view provides convenient access to the most expensive statements that were executed on the system. A statement is considered being expensive if its runtime exceeds a particular threshold. Please note that the expensive statements trace needs to be activated first in the Performance → Expensive Statements Trace screen in the SAP HANA studio. Click Configure the Trace Configuration dialog

SAP Developer

Published on 23-Apr-2018 14:31:02