Symptom
After HANA Upgrade to SPS 06 you observe the CPU utilization frequently spiking to ~100%. The CPU resources on the system are small and from the runtime dumps you observe that CALL_SYS_STATISTICS.STATISTICS_SCHEDULABLEWRAPPER is responsible for the CPU spikes.
The scenario matches the situation described in Note 2889270 - High CPU Usage by Embedded Statistics server with CALL _SYS_STATISTICS.STATISTICS_SCHEDULABLEWRAPPER. However, you have already set the "threadpool" parameter indicated in the note and have not had any issues with this pre-upgrade.
Read more...
Environment
HANA Version 2.00.061.00
Product
Keywords
KBA , HAN-DB-MON , SAP HANA Monitoring , How To
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.
SAP Knowledge Base Article - Preview