SAP Knowledge Base Article - Preview

3313368 - High CPU utilization in HANA database for access to CDS view ML4H_CDS_CATEG_H

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.