Information about current SAP HANA threads can be found at the following locations:
- Monitoring view M_SERVICE_THREADS
- SAP HANA Studio -> Administration -> Performance -> Threads
- DBACOCKPIT -> Performance -> Threads
- SQL: "HANA_Threads_CurrentThreads" (SAP Note 1969700)
Information about historic thread activities are available at:
- Monitoring view M_SERVICE_THREAD_SAMPLES (retention: usually at least 2 hours, for more details see SAP Note 2088971)
- History table HOST_SERVICE_THREAD_SAMPLES (if embedded statistics server is used, retention >= 30 days)
- SQL: "HANA_Threads_ThreadSamples_FilterAndAggregation" (SAP Note 1969700)
- SQL: "HANA_Threads_ThreadSamples_AggregationPerTimeSlice" (SAP Note 1969700)