SAP Knowledge Base Article - Preview

3025410 - High CPU utilization caused by cyclic joins

Symptom

HANA experience High CPU situation when most active threads include one or more of the following call stacks in the Kernel Profiler Trace or Runtime dumps :

JoinEvaluator::TupleList::partitionFind
JoinEvaluator::TupleList::partition_iterator::operator++
JoinEvaluator::LoopWithEqJob::recurseWithEq

For details search within the KBA 2100040- FAQ: SAP HANA CPU


Read more...

Environment

  • SAP Hana Platform Edition 1.0
  • SAP Hana Platform Edition 2.0

Product

SAP HANA, platform edition 2.0

Keywords

HANA 1.0, HANA 2.0, CPU, cyclic join, hint , KBA , HAN-DB-PERF , SAP HANA Database Performance , 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.