SAP HANA -Slower Response with High User CPU Usage

The performance can degrade as the usage of the CPU can be increased by the SAP HANA database configuration, the application configuration or its usage.


Root cause: Not many executor threads but high CPU in a few nodes and a few tables accessed

Required Action: In an SAP Business Warehouse system, check for non-even partitioning of huge column tables. For more information, see SAP Note 1819123 – BW on SAP HANA SP5: landscape redistribution and Indicator for Large Delta Storage of Column Store Tables.


Root Cause: Performance degradation by huge MVCC versions

Required Action: Check for Active Version in the load graph to find the MVCC garbage blocker, then kill it. For more information, see Troubleshooting Blocked Transactions from the below reference.

Leave a Reply