on 12-03-2015 7:50 AM
Hi Experts,
I want to know how to enable and track the history of Memory and CPU usages of all services other than index server.
As per "HANA_LoadHistory_Services_Rev90+" file in SAP Note 1969700, only index server is considered for M_LOAD_HISTORY_SERVICE table.
Is there any other table or option by which we can get the information of all other services.
Best Regards,
Deepak Varandani
Try This:
SELECT top 10 HOST, SERVER_TIMESTAMP, round(INSTANCE_TOTAL_MEMORY_USED_SIZE/1024/1024/1024, 2) as "Used Memory GB"
from _SYS_STATISTICS.HOST_RESOURCE_UTILIZATION_STATISTICS
where hour(SERVER_TIMESTAMP) = 7 and minute(SERVER_TIMESTAMP) = 0 order by SERVER_TIMESTAMP desc;
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I regret, this is not possible according to my knowledge.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.