Online Tutorials & Training Materials | STechies.com
Register Login

Information about SAP HANA Threads

12 Feb 2015 6:03 pm || 0

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)