M_Expensive statement in SAP HANA

SAP HANASAPSAP BpC

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

raja
Published on 23-Apr-2018 11:01:02
Advertisements