Expensive SQL statements – impact on the system
Expensive SQL statements are long running statements, often seen as the main cause of performance problems. On top of causing long running programs, they also negatively influence other transactions. Even one expensive SQL statement can cause various problems such as high CPU utilization, high I/O loads, long blocking of SAP work processes and prolonged execution time of other SQL statements.
Expensive SQL statement monitoring helps you to define demanding processes happening on the system while experiencing performance bottlenecks. For these reasons, we always recommend customers to set up monitoring of their expensive SQL statements.
The way to get the most out of your monitoring is to correlate SQL statements with other performance related factors. Hence, integrating the expensive SQL statement of your HANA in a system monitoring solution such as Datavard Insights can be extremely helpful. Such synchronization will enable you to tell what was happening on the system while you experienced certain problems. You will be able to see the effects the execution had on your system, move on quickly with root cause analysis and take precautions for avoiding similar issues in the future.
Important hint: When setting up expensive SQL statement monitoring on your HANA system, make sure to set thresholds for the statements’ size and execution time to choose which processes will be tracked. Setting these thresholds is critical in order not to impact performance of your HANA system or populate it with collected data.