SAP Knowledge Base Article - Preview

3096705 - Regular high CPU usage caused by statistics server

Symptom

You notice constant CPU spike every hour. When checking the running threads during the spike, some of below statement hashes with high percentage:

1964c8ab878cde5f306d9f605e3b94ed
1f989f4acd844d502ccd445f69f5ea02
38a8e11286f7309f2715c07c270a473b
430c496e0fe15c0353c80de1c72caab1
ba81a383d98a296d2e44e04278ccb770
c6edbab2e426f7e83b156ed06ccdf6bb
d3759ce6047b78f61d5fc3be392d0336
f1b12a80a3eb489df86f5e25097725db

e.g.:

SAMPLESPCTHOSTPORTNMCONN_IDSTATEMENT_HASH
8044.44anyanyanyany38a8e11286f7309f2715c07c270a473b
6033.33anyanyanyanyba81a383d98a296d2e44e04278ccb770
2011.11anyanyanyanyno SQL (checking)
105.55anyanyanyanyno SQL (JobexWatchdog)
105.55anyanyanyanyc6edbab2e426f7e83b156ed06ccdf6bb

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."


Read more...

Environment

SAP HANA database 2.00.041 and newer

Product

SAP HANA, platform edition 2.0

Keywords

High CPU, statistics server, 1964c8ab878cde5f306d9f605e3b94ed, 1f989f4acd844d502ccd445f69f5ea02, 38a8e11286f7309f2715c07c270a473b, 430c496e0fe15c0353c80de1c72caab1, ba81a383d98a296d2e44e04278ccb770, c6edbab2e426f7e83b156ed06ccdf6bb, d3759ce6047b78f61d5fc3be392d0336, f1b12a80a3eb489df86f5e25097725db , 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.