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

Updated on: 12-Mar-2020

2K+ Views

Kickstart Your Career

Get certified by completing the course

Get Started
Advertisements