Checking savepoint statistics of SAP HANA

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