Author 
SAP HANA database history views are very useful for checking the detail about the database.
When SAP HANA database is not restarted after the performance downgrade, the "System Information" views can be checked further. If the performance issue is resolved without a database restart, then it indicates that the database was not in a hang situation, but the database performance was temporarily decreased.
If HANA database has been restarted after a hang situation, the history of database status can be found in "_SYS_STATISTICS" SAP HANA schema:
- HOST_LONG_RUNNING_STATEMENTS
- HOST_LONG_SERIALIZABLE_TRANSACTION
- HOST_LONG_IDLE_CURSOR
- HOST_UNCOMMITTED_WRITE_TRANSACTION
- HOST_MEMORY_STATISTICS
- HOST_RESOURCE_UTILIZATION_STATISTICS
- HOST_SAVEPOINTS
- HOST_MVCC_OVERVIEW
- HOST_VOLUME_IO_PERFORMANCE_STATISTICS
EmoticonEmoticon
Note: only a member of this blog may post a comment.