HA215-SAP HANA 2.0 SPS06 - Using Monitoring and Performance Tools.
Analyzing SQL Statements
Use these views to analyze the performance of SQL statements:
●M_ACTIVE_STATEMENTS
●M_PREPARED_STATEMENTS
●M_EXPENSIVE_STATEMENTS (enable_tracking and memory_tracking must first be enabled in the global.ini file for this view)
To be able to set memory limits for SQL statements, enable the following parameters:
●In the global.ini file, in the resource_tracking section:
-enable_tracking = on
-memory_tracking = on
Use the Monitor Statements page to analyze the current most critical statements running in the database.
Analyzing the current most critical statements running in the SAP HANA database can help you identify the root cause of poor performance, CPU bottlenecks, or Out of Memory situations. Enabling memory tracking allows you to monitor the amount of memory used by single statement executions.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
LizzyOlivan
1 year, 3 months agoVipul_1988
1 year, 9 months ago