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.:
SAMPLES | PCT | HOST | PORT | NM | CONN_ID | STATEMENT_HASH |
80 | 44.44 | any | any | any | any | 38a8e11286f7309f2715c07c270a473b |
60 | 33.33 | any | any | any | any | ba81a383d98a296d2e44e04278ccb770 |
20 | 11.11 | any | any | any | any | no SQL (checking) |
10 | 5.55 | any | any | any | any | no SQL (JobexWatchdog) |
10 | 5.55 | any | any | any | any | c6edbab2e426f7e83b156ed06ccdf6bb |
"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
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.