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

Updated on: 24-Feb-2020

277 Views

Kickstart Your Career

Get certified by completing the course

Get Started
Advertisements