Monitoring SAP HANA Using SAP HANA Cockpit and SAP HANA Studio for SAP HANA Dynamic Tiering
- Capabilities of SAP HANA Cockpit related to SAP HANA Dynamic Tiering
- Checking the
Esserver
Status to see if Dynamic Tiering is active - Checking Coordinator Types to see if extended storage is running and created
Prerequisites
- System: Access to an SAP HANA 2.0 system with the optional SAP HANA Dynamic Tiering component installed.
- Integrated Development Environment: Cockpit is already installed and configured. Basic working knowledge of SAP HANA Studio and SAP HANA Cockpit. E.g. You should be able to connect to your HANA instance from SAP HANA Studio and feel comfortable with executing simple queries.
- Credentials: Have a cockpit admin user and password with access to your HANA system and access to “
<SID>adm
” for a SSH session
SAP HANA cockpit provides a single point of access to a range of SAP HANA administration and monitoring tasks. It is used to monitor and ensure the overall health of the system. It enables a user to configure tasks such as:
- Checking the status of the system i.e. verifying if it’s active and running, and configuring system properties
- How to stop and start extended storage
- How to add and remove additional space for extended storage
SAP HANA cockpit is also used for monitoring and managing checks which include:
- Analyzing usage of CPU, memory and tables i.e. how much memory is being used
- Used to monitor the percentage of
DBspace
in use and view alerts forDBspaces
nearing their capacity - Ability to view and search for various server logs and custom traces
SAP HANA Studio is a rich client tool based on an Eclipse platform. SAP HANA Studio is the central development environment and a key administration and monitoring tool for SAP HANA. There are a several tabs providing detailed status information for the HANA system. For example, the “Overview” tab in the HANA Studio displays the overall status of the HANA system including the Dynamic Tiering component. More detailed status information for each process on a per host basis is then provided under the “Landscape” tab. We will explain the contents of these tabs in more detail later on in this lesson.