Skip to Content
avatar image
Former Member

How to check consumption of thread and memory resources per WLC?

Hi there,

I adjusted the SAP HANA WLM(WorkLoad Management) to my system for using system stably.
And then I would like to check consumption of thread and memory resources per WLC(Workload Class) but I cannot find a way to check it.

There isn't any sql statement to check it in the SAP Note 2222250.

Is there any way to check consumption of resources?

Tried query from the URL, https://assets.cdn.sap.com/pdfjs/web/viewer.html?file=https://assets.cdn.sap.com/sapcom/docs/2016/05/8aa8e6b9-737c-0010-82c7-eda71af511fa.pdf

But the result of that query that I wrote below is incorrect.
1.select a.user_name, a.application, a.applicationuser, a.workload_class_name, b.priority, b.statement_memory_limit, b.statement_thread_limit
from sys.m_connections_ a join sys.m_prepared_statements_ b on a.connection_id = b.connection_id
group by a.user_name, a.application, a.applicationuser, a.workload_class_name, b.priority, b.statement_memory_limit, b.statement_thread_limit;
2.select a.user_name, a.application, a.applicationuser, a.workload_class_name, to_char(b.statement_string), b.allocated_memory_size, b.priority, b.statement_memory_limit, b.statement_thread_limit
from sys.m_connections_ a join sys.m_prepared_statements_ b on a.connection_id = b.connection_id --and a.application = 'HDBStudio'
group by a.user_name, a.application, a.applicationuser, a.workload_class_name, to_char(b.statement_string), b.allocated_memory_size, b.priority, b.statement_memory_limit, b.statement_thread_limit;

Thank you.

JONGCHAE

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers