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.
Datavard Insights with Integrated Expensive SQL Monitoring
Example of KPI correlation of Datavard Insights. The autocorrelation function finds the right KPIs to be on the lookout for. You can always customize the correlation by adding other critical KPIs to the range.
Datavard Blog-Newsletter
Bleiben Sie informiert
Abonnieren Sie unseren kostenlosen Blog-Newsletter und erhalten Sie wertvolle Tips, Tricks und Expertenwissen zu den Themen SAP-Transformationen, SAP-Datenmanagement, Cloud-Migration, TCO Reduction, Data Lifecycle Management und vielem mehr.