SAP HANA Metrics
| Metrics | Description |
|---|---|
| Total Connections (Active + Idle) | Overall count, including both active and idle. |
| Max Connections | Maximum simultaneous connections. |
| Maximum duration of backup thread (s) | Longest backup thread duration. |
| Failed DATA backups (count) | Unsuccessful data backup attempts. |
| Failed LOG backups (count) | Unsuccessful log backup attempts. |
| Maximum used space on data backup disks | Peak disk space utilization. |
| Time since the last DATA backup in hours | Duration since the last data backup in hours. |
| Time since the last LOG backup in minutes | Duration since the last log backup in minutes. |
| CPU utilization by system (avg. 5 mins)(%) | Average system CPU usage. |
| CPU utilization by users (avg. 5 mins) (%) | Average user CPU usage. |
| CPU utilization in I/O waits (avg. 5 mins)(%) | CPU usage during I/O waits. |
| Total CPU utilization on all hosts (avg 5min)(%) | Average CPU usage across hosts. |
| Maximum used space on data backup disk (%) | Peak utilization percentage of data backup disk space. |
| Maximum used space on data disks (%) | Peak utilization percentage of data disks. |
| Maximum used space on log disks (%) | Peak utilization percentage of log disks. |
| Total used space on data disks (GB) | Total utilized space on data disks in gigabytes. |
| Total used space on log disks (GB) | Total utilized space on log disks in gigabytes. |
| Hosts in failover status (count) | Number of hosts currently in failover status. |
| System replication errors (count) | The total number of errors encountered during system replication. |
| Unknown replication statuses (count) | The total number of replication statuses that are unknown. |
| Age of oldest replication snapshot (s) | Age of the oldest replication snapshot in seconds. |
| Log shipping delay (s) | Delay in log shipping in seconds. |
| Maximum duration of replication (s) | The longest duration of replication in seconds. |
| Global memory allocation limit for database (GB) | Maximum memory allocation limit for the database in gigabytes. |
| Free database memory (GB) | Amount of free memory available for the database in gigabytes. |
| Used database memory (GB) | Amount of memory currently used by the database in gigabytes. |
| Temporary memory used (GB) | Amount of temporary memory currently in use in gigabytes. |
| Maximum physical used memory on hosts (%) | Peak utilization percentage of physical memory on hosts. |
| Memory used by column tables (%) | Percentage of memory used by column tables. |
| Memory used by row store tables (%) | Percentage of memory used by row store tables. |
| Total memory used (%) | The overall percentage of memory used. |
| Current used memory by row store tables (GB) | The current amount of memory used by row store tables in gigabytes. |
| Currently used memory by column store tables (GB) | The current amount of memory used by column store tables in gigabytes. |
| Global allocation limit for the database (GB) | Total allocation limit for the database in gigabytes. |
| Total estimated size of column tables (GB) | Total estimated size of column tables in gigabytes. |
| Total memory used by the database (GB) | Total memory used by the database in gigabytes. |
| Number of unloads due to low memory (count) | Count of unloads triggered due to low memory. |
| Maximum duration of MergeDog thread (s) | The longest duration of the MergeDog thread in seconds. |
| Savepoint speed (MB/s) | Speed of savepoints in megabytes per second. |
| Number of savepoints (count) | Total count of savepoints. |
| Maximum duration of a critical phase of a savepoint(s) | The longest duration of a critical phase of a savepoint in seconds. |
| Maximum duration of a savepoint (s) | The longest duration of a savepoint in seconds. |
| Time since last savepoint (s) | Time elapsed since the last savepoint in seconds. |
| Number of blocked transactions (count) | Total count of blocked transactions. |
| Number of object locks older than 1 min (count) | Count of object locks older than one minute. |
| Age of oldest object lock (min) | The age of the oldest object lock in minutes. |
| Duration of longest transaction lock wait (min) | Duration of the longest transaction lock wait in minutes. |
| Maximum redo size of a current transaction (MB) | Maximum redo size of a current transaction in megabytes. |
| Maximum undo size of current transaction (MB) | Maximum undo size of a current transaction in megabytes. |
| SQL Plan Cache Hit Ratio | Ratio of SQL plan cache hits. |
| SQL Plan Cache Evictions | Count of SQL plan cache evictions. |
| SQL Thread Time | Total time spent by SQL threads. |
| Number of expensive SQL statements exceeding the time limit (count) | Count of SQL statements exceeding the time limit. |
| Number of expensive statement over memory limit (count) | Count of statements exceeding the memory limit. |
| Total Lock Time (sec) | Total lock time is calculated based on the number of blocking sessions per second granularity. This does not consider the duration when a transaction is rolled back during a session-level or server-level lock timeout. |