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 11:01:02

• Related Questions & Answers
• SQL statement to create a Restricted user in SAP HANA
• SAP HANA Modeling Perspective in HANA Studio
• Customizing SAP HANA Perspective in HANA Studio
• SAP HANA database functions in HANA Cockpit
• TCP/IP port in SAP HANA to access SAP HANA XS Engine
• Opening SAP HANA Cockpit from HANA Studio
• Using SAP HANA Cockpit for HANA Administration
• Incremental backup in SAP HANA
• Data compression in SAP HANA
• Using aggregated in SAP HANA
• Persistence layer in SAP HANA
• SQL statement to add a table as Virtual table in SAP HANA Smart Data Access
• Use of SAP Host Agent in SAP HANA
• Installing SAP HANA Studio from SAP Marketplace
• Start and stop HANA system in SAP HANA Studio