Which features do you need to activate before you can analyze the memory usage of running SQL statements? (Choose two.)
Which features do you need to activate before you can analyze the memory usage of running SQL statements? (Choose two.)
To analyze the memory usage of running SQL statements, you need to activate Memory Tracking and Tracking. These features are essential for monitoring the memory usage and performance of SQL statements. 'Memory tracking' allows for the monitoring of memory use by individual SQL statements, while 'Tracking' enables the general tracking of statement execution and performance analysis. Therefore, these two features are critical to have an accurate analysis of SQL statements' memory usage.
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.
The option D should be "Enable Tracking"