Skip to Content
0

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

Jun 05, 2017 at 02:45 AM

54

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers