Show TOC

Function documentationCurrent Status Locate this document in the navigation structure

 

The Current Status section provides an overview of the statuses of the most important database resources.

Overview

Section

Description

Overview

Status of available disk space and physical memory

In some sections, the resource state is displayed by a bar. The bars change color when a threshold is reached. For values up to 97%, the bars are black; over 98%, red. The threshold values from the Alerts screen are not used here.

If no data is displayed in any of the overview sections, or if the data is grayed out, this means that the database is not running or cannot be accessed.

Note Note

If the database is not available, the Overview section is still available, and it is still possible to schedule jobs.

End of the note.

Overview: General System Information: Operational State

  • Green: The database is available.

    All services are running. Database users with the appropriate authorizations can log on and execute SQL statements. The Database System Administrator and the DBM operator can perform administrative tasks.

    Choose All services are started to go to display an overview of the services. (Alternatively, choose   Configuration   Services  .)

  • Yellow: One or more services is not running or is still starting.

    To display more information about the errors, click the message.

Overview: General System Information: Start Time Of First Started Service

Overview: General System Information: Start Time Of Last Started Service

The time, at which the database was started.

With a distributed system, two start times are displayed. These are the start times of first server and last server to start.

(With a distributed system, Yes is displayed in General System Information: Distributed System.)

Overview: General System Information: Build Time

The timestamp, at which the database software was compiled.

Overview: Current Alerts

To display more information, click the message. (Alternatively, choose   Configuration   Alerts  .)

Example Example

The following message appears: Alerts cannot be displayed.

To look for a possible cause, check General System Information: Operational State. Here, the following message may be displayed: Some services are not started. Click this message to go to the Services section to find out which services are not started.

End of the example.

Overview: Disk Full Events

If there are no disk full events to report, nothing is displayed here. If a disk is full, a message is displayed.

You need to first resolve the critical situation, then flag the event as resolved so that the SAP HANA database can resume work.

  1. Click the error message to display more information.

  2. Select the event and choose Handle Selected Events.

Overview: Database Memory and CPU: Memory User/Allocation Limit

Overview: Database Memory and CPU: CPU Usage

Overview: Database Memory and CPU: Available CPUs

Shows memory and CPU consumption from the perspective of the SAP HANA database.

Here, you can see the memory used by SAP HANA database relative to the allocated memory, without the operating system usage.

You can also see the actual CPU usage and the number of available CPUs.

Choose either option to go to the Services overview.

Overview: Database Disk Usage

Shows disk consumption from the perspective of the SAP HANA database.

Here, you see the data volume size, the log volume size, and the size of the trace files, relative to the disk size.

Choose any option to go to the Volumes overview.

Overview: Host: Memory and CPU

  • Physical Memory Used/Available

  • Virtual Memory Used/Available

  • CPU Usage

Shows memory and CPU consumption from the perspective of the operating system.

Choose either option to go to the Services overview.

Overview: Host: Disks

  • Disk Containing Data Used/Total

  • Disk Containing Log Used/Total

  • Disk Containing Trace Used/Total

Shows disk space used on a particular host, from the perspective of the operating system.

Choose any option to go to the Volumes overview.
Alerts

Displays an overview of the current alerts reported by the statisticsserver when usage thresholds for database resource were exceeded.

The Current Alerts section displays the highest alert level.

The Alert Check Information section displays an overview of the alert checks performed in the system.

A green traffic light indicates that no issues were found when the last check was performed. The scheduled time for the next check is displayed.

A yellow traffic light indicates that an issue has been found. You should check what has happened.

Note Note

To change the alert threshold values, choose Display/Configure Thresholds. Choose Edit Mode to make changes to the threshold values.

A threshold value is displayed against a yellow background indicates that the value is different from the default value.

In releases before SPS07:: The alert threshold values cannot be changed using DBA Cockpit. To change the alert thresholds, use SAP HANA studio.

  1. Choose Administration.

  2. Go to the Alerts tab.

  3. Choose Configure Check Settings.

  4. Go to the Configure Check Settings tab.

End of the note.

To change the size of views or to see just one overview, move the pane divider.