Symptom
- HANA Database CPU is high when you access the CDS view ML4H_CDS_CATEG_H
- The statement Hash for the SQL statement is '74d3229c25a96f60303335a58bd537de'
- At the time of the high CPU you observe that the execution count is high for the problem statement. This can be checked with the below SQL statement:
select snapshot_id, statement_hash, execution_count, avg_execution_time, statement_string
from _sys_statistics.host_sql_plan_cache
where statement_hash='74d3229c25a96f60303335a58bd537de'
order by snapshot_id desc
Read more...
Environment
SAP HANA, platform edition
Product
SAP HANA, platform edition all versions
Keywords
default_statement_concurrency_limit; , KBA , HAN-DB-PERF , SAP HANA Database Performance , HAN-DB , SAP HANA Database , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.