SAP HANA Load History

Nota de consulta: 2222110 - FAQ: SAP HANA Load History.

Host specific KPIs like host-wide CPU and memory figures( Ver QUERY )

SELECT * FROM SYS.M_LOAD_HISTORY_HOST

En orden del mas actual al mas antiguo

SELECT * FROM SYS.M_LOAD_HISTORY_HOST ORDER BY TIME DESC

Meta information for M_LOAD_HISTORY_HOST and M_LOAD_HISTORY_SERVICE like underlying SQL statements and description( Ver QUERY )

SELECT * FROM SYS.M_LOAD_HISTORY_INFO

Indexserver specific KPIs like MVCC versions, statement count or active thread count( Ver QUERY )

SELECT * FROM SYS.M_LOAD_HISTORY_SERVICE

Los distintos puertos monitorizados

SELECT DISTINCt(port) FROM SYS.M_LOAD_HISTORY_SERVICE

Cantidad de entradas de la tabla

SELECT COUNT(port) FROM SYS.M_LOAD_HISTORY_SERVICE