SAP Knowledge Base Article - Preview

3257190 - High CPU usage caused by column store access statistics cache

Symptom

You notice that CPU usage is high and many thread are in "IntentLock Enter" state and they are wait for lock "TREXCache_CacheInstance".

Call stacks similar to:
DataStatistics::CSAccessStatisticsCache::insert
DataStatistics::CSAccessStatisticsCache::lookup
AttributeEngine::AccessCounterHelpers::insertIntoCSAccessStatisticsCache


Read more...

Environment

  • SAP HANA DATABASE 2.00.048.02 and newer
  • SAP HANA DATABASE 2.00.053 and newer

Keywords

TREXCache_CacheInstance; DataStatistics::CSAccessStatisticsCache::lookup; collection_enabled , 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.