HDB_THRDSMP_STAT - KPIs for individual HANA database requests based on thread samples

Data Description

The HDB_THRDSMP_STAT event is used to get KPIs for individual HANA database requests based on thread samples. The SAP HANA work, like executing of SQL statements or background tasks is performed by threads. Each SAP HANA process like indexserver or xsengine consists of a set of threads. Thread samples are regular samples of thread activities which are historicized.

Potential Use Cases

This event could be used in the following scenarios:

• Analyze CPU usage and thread activity

• Identify performance bottlenecks

SAP Navigation

HANA Thread Sample statistics can’t be displayed from SAP Application server but can be seen from SAP HANA Studio & SAP HANA Cockpit

HDB_THRDSMP_STAT data: