Checking savepoint statistics of SAP HANA

SAP HANASAPSAP Basis

This can be checked using M_SAVEPOINT_STATISTICS. This view has a resettable counterpart. This means, you can also see the values since the last reset in the dependent view: M_SAVEPOINT_STATISTICS_RESET.

To reset the values, use the SQL command −

ALTER SYSTEM RESET MONITORING VIEW SYS.M_SAVEPOINT_STATISTICS_RESET

or the management console command −

monitor reset -n M_SAVEPOINT_STATISTICS_RESET
raja
Published on 05-Feb-2018 22:41:59
Advertisements