What are your top 5 checks to get an idea of HANA DB health?

[former_member603686]

To HANA administrors,

What are you looking when you want to get an idea of HANA system good (or bad) health?

Mine are:

• Services status and services uptime (to identify unit manual restart of any service)
• CPU and Memory usage (and particularly the repartition of memory in categories: caches, system, rs tables, cs tables, monitoring data, statements execution & int. results!)
• Existence of dumps and date & time of last dumps
• Existence of backups and date & time & duration of last backups
• Checks for high and medium alerts in HANA (especially if some concerns Wait/No wait ratio of log buffer, and Read/Write trigger ratio that I mentionned in this blog post: https://blogs.sap.com/2019/02/20/tips-for-sap-hana-monitoring-and-administration/ )

> What about you? is there any other interesting checks I should consider?

Thanks a lot and share the knowledge!

Yi

[SergioG_TX]

* log file size check

* SAP HANA used memory vs available memory

* Performance threads - running times

* landscape services status

[former_member603686]

Great, thanks Sergio for your contribution.

I guess you are talking about backup log files in your first point.

[SergioG_TX]

yes backup logs as well as execution logs ... everything gets logged.. if your file gets too big in size then it starts impacting performance since it has to keep up with it as statements get executed. your hana admin can explain further as to how and what gets logged.

[former_member747869]

As an in-memory database, it is critical for SAP HANA to handle and track its memory consumption carefully and efficiently; therefore, the HANA database pre-allocates and manages its own memory pool. The concepts of the in-memory HANA data include the physical memory, allocated memory, and used memory.

* CPU Usage

* Memory Usage

* Volume Usage

* License (Valid and Usage)

* Alerts

* Backups

* Running services

* Performance threads - running times

[former_member755871]

How do I monitor processes in SAP Hana?

[TammyPowlas]

Everything I learned was in this free Open SAP Course SAP HANA Admin with Jose Ramos https://open.sap.com/courses/hsha1

[former_member603686]

Hi Tammy,

Thanks for your answer and good advise on where to get great info!

I was more interested in this question to get 'ready to use' checks so every one can contribute and share their experiences on why/when a particular check can interested and when not, for example.

Kind regards.