3469925 - SQL script "HANA_Threads_ThreadSamples_FilterAndAggregation" show no result when CPU spiked to High

Symptom

Your system suffered from high CPU spike and you want to use the script "HANA_Threads_ThreadSamples_FilterAndAggregation" (Note 1969700) to identify the responsible SQLs.

From the Load history information, you identified the CPU spiked time frame like below, and specified the script filters accordingly.

HANA_Threads_ThreadSamples_FilterAndAggregation_2.00.070+
 '2024/05/07 10:52:35' BEGIN_TIME, 
 '2024/05/07 11:36:00' END_TIME, 
 'HISTORY' DATA_SOURCE, 
 'HASH' AGGREGATE_BY,

But the execution result shows no record.

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

Environment

SAP HANA Database 1.0
SAP HANA Database 2.0

Product

SAP HANA 1.0, platform edition ; SAP HANA, platform edition 2.0

Keywords

CPU; Spike; HANA_Threads_ThreadSamples_FilterAndAggregation; , 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.