By checking SAP HANA thread information we can get a current or historic snapshot of thread activities. This can help you to answer questions related to the SAP HANA workload, e.g.:
- Activities responsible for CPU consumption (SAP Note )
- Activities responsible for lock situations (SAP Note )
- Activities responsible for bad performance (SAP Note )
- Expensive SQL statements (SAP Note )