SAP_Basis HANA Database Unified Dashboard

The sap_basis HANA Database Unified Dashboard provides predefined list views to monitor the health and performance of the HANA Database in the SAP landscape.
uim901
sap_basis_Hana_UD
The sap_basis HANA Database Unified Dashboard provides predefined list views to monitor the health and performance of the HANA Database in the SAP landscape.
 
Contents
 
 
 
: If your Unified Dashboard is not populating with data, make sure all required data sources for the Unified Dashboard are enabled. The required probe must be deployed and must be configured so that required QoS metrics and subkeys or targets are activated. For more information, see the help topic on required data sources for the Unified Dashboard.
SAP_Basis HANA Database Required Data Sources
This table lists the probes, QoS metrics, and subkeys or targets that must be activated to populate data in the SAP_Basis DB2 Database dashboard. An asterisk (*) means that this QoS brings data for all targets for which it is applicable.
QoS
Subkey/Target
QOS_SAP_HANA_SCHEMA_DELTA_RECORDS
*
QOS_SAP_HANA_DISK_VOLUME_SIZE
*
QOS_SAP_HANA_DISK_VOLUME_USED_SPACE
*
QOS_SAP_HANA_HOST_TOTAL_IO_TIME
*
QOS_SAP_HANA_HOST_CPU_USER_TIME
*
QOS_SAP_HANA_HOST_CPU_BUSY
*
QOS_SAP_HANA_HOST_TOTAL_COUNT
*
QOS_SAP_HANA_HOST_IDLE_COUNT
*
QOS_SAP_HANA_HOST_FREE_PHYSICAL_MEMORY
*
QOS_SAP_HANA_HOST_USED_PHYSICAL_MEMORY
*
QOS_SAP_HANA_HOST_FREE_SWAP_SPACE
*
QOS_SAP_HANA_HOST_USED_SWAP_SPACE
*
QOS_SAP_HANA_HOST_EFFECTIVE_ALLOCATION_SIZE
*
QOS_SAP_HANA_HOST_MEMORY_ACTUAL_USED_SIZE
*
QOS_SAP_HANA_HOST_MEMORY_ALLOCATION_PEAK_SIZE
*
QOS_SAP_HANA_SERVICE_PENDING_REQUEST
*
QOS_SAP_HANA_SERVICE_RESPONSE_TIME
*
QOS_SAP_HANA_SERVICE_STATUS
*
QOS_SAP_HANA_SERVICE_COORDINATOR_TYPE
*
QOS_SAP_HANA_SERVICE_REQUESTS_PER_SEC
*
QOS_SAP_HANA_SERVICE_PROCESS_CPU_USAGE
*
QOS_SAP_HANA_SERVICE_PROCESS_MEMORY
*
QOS_SAP_HANA_SERVICE_AVAILABLE_MEMORY
*
QOS_SAP_HANA_SERVICE_TOTAL_MEMORY
*
QOS_SAP_HANA_SHARED_MEMORY_USED_PCT
*
QOS_SAP_HANA_SERVICE_LOG_MISSING
*
QOS_SAP_HANA_SERVICE_LOG_BACKUP
*
QOS_SAP_HANA_SERVICE_DATA_SNAPSHOT
*
QOS_SAP_HANA_SERVICE_COMPLETE_DATA_BACKUP
*
QOS_SAP_HANA_MAX_PEAK_MEMORY_USED
*
For more information about configuring probes, see the documentation for each probe.
Schema Summary
This table displays information about the SAP HANA schemas. Use this chart to view information about the records residing on the schema. 
Column Name
Description
Number of documents in delta for complete schema
The total number of records in delta for the complete schema.
Disk Summary
This table displays information about the SAP HANA disks. Use this chart to view information about the disks on the host and at file system level.
Column Name
Description
Used Volume Size
The total size of data and log volumes.
Total Volume Size
The total disk space used on the host hard disk.
Host Memory Performance
This table displays information about the host memory performance. Use this chart to view information about the memory utilization by the system and peak memory utilization.
Column Name
Description
Free Physical Memory
The total amount of free physical memory on the host.
Used Physical Memory
The total used physical memory on the host.
Free Swap Memory
The total free swap memory on the host.
Used Swap Memory
The total used swap memory on the host.
Size of Memory Pool
The size of the memory pool for all SAP HANA processes.
Memory Pool in Actual Use
The amount of memory from the memory pool that is currently in use by SAP HANA processes.
Memory Allocation Peak size
The highest memory pool allocation to the HANA system.
Host Summary
This table displays information about the host summary. Use this chart to view information about the host performance.
Column Name
Description
Total IO Time
The aggregated IO time statistics for the volume.
Total CPU System Time
The total CPU system time used by all processes.
CPU Busy
The total percentage of CPU utilization.
Total Connection Count 
The number of current connections per instance.
Idle Connection Count
The number of idle connections per instance.
Services Summary
This table displays information about the SAP HANA services. Use this chart to view information about the performance of internal services and how the requests are handled.
Column Name
Description
Pending Requests
The total number of pending requests for the connection to the HANA service.
Request Response Time
The average request response time for the last 1000 requests.
Service Status
The operational state of the SAP HANA system. Possible values are (0 - No, 1 - Yes, 2 - Unknown, 3 - Starting, 4 - Stopping)
Coordinator type in distributed landscape
The state of the coordinator type of the Dynamic Tiering Service. Possible values are (0 - Master, 1 - Slave, 2 - Standby, 3 - None, 4 - Unknown)
Requests Per Second
The average of last 1000 requests.
CPU and Memory Performance
This table displays information about the CPU and memory performance. Use this chart to view information about the overall performance of the HANA system.
Column Name
Description
CPU Usage
The total CPU usage by the current process.
Logical Memory Usage
The logical memory usage by the service.
Total Memory Size
The total allocation limit for all processes.
Total Memory Usage
The total size of available memory.
Shared Memory Used
The amount of shared pool memory that is currently in use.
Log and Data Backup Status
This table displays information about the log and data Backup status. Use this chart to view information about data and log backups that are the key components for HANA system performance.
Column Name
Description
Log Missing Status
The state of missing log backups at a particular instance of time. Possible values are (0 - successful, 1 - Failed, 2 - Running, 3 - Cancel Pending, 4 - Cancelled)
Log Backup Status
The state of the SAP HANA redo log backups at a particular instance of time. Possible values are (0 - successful, 1 - Failed, 2 - Running, 3 - Cancel Pending, 4 - Cancelled)
Data Snapshot Status
The state of the Storage snapshot at a particular instance of time. Possible values are (0 - successful, 1 - Failed, 2 - Running, 3 - Cancel Pending, 4 - Cancelled)
Complete Data Backup Status
The complete data backup of HANA system which includes data and log. Possible values are (0 - successful, 1 - Failed, 2 - Running, 3 - Cancel Pending, 4 - Cancelled)
DB Usage Summary
This table displays information about the SAP HANA database usage.
Column Name
Description
Max Peak Used Memory
The highest used memory value recorded.