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 )
Information about historic thread activities are available at:
- Monitoring view M_SERVICE_THREAD_SAMPLES
- Retention is usually at least 2 hours
- For more details see SAP Note
- Can be enabled / disabled via parameter <service>.ini -> [resource_tracking] -> service_thread_sampling_monitor_enabled (true / false)
- History HOST_SERVICE_THREAD_SAMPLES
- Is historicized by the statistics server (SAP Note ) every 10 minutes
- Data is retained for 42 days
- Per default every 50th timestamp of M_SERVICE_THREAD_SAMPLES is considered, can be adjusted as described in
- SQL: "HANA_Threads_ThreadSamples_FilterAndAggregation" (SAP Note )
- SQL: "HANA_Threads_ThreadSamples_AggregationPerTimeSlice" (SAP Note )