cancel
Showing results for 
Search instead for 
Did you mean: 

Services History Tracking

DeepakVarandani
Explorer
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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;

DeepakVarandani
Explorer
0 Kudos

Thanks Mayank for the reply!!

I was looking for Service Wise Memory History Usage which can be tracked from HOST_SERVICE_MEMORY view.

Answers (1)

Answers (1)

Former Member
0 Kudos

I regret, this is not possible according to my knowledge.