HANA Studio Flashcards
Main tabs of HANA Studio Administration editor.
Overview
Landscape
Alerts
Performance
Volumes
Configuration
System Information
Diagnosis Files
Trace Configuration
Important editors available in the SAP HANA Administration Console
The System Monitor
The Administration editor
The Backup editor
The Security editor
The SQL console
Important views available in the SAP HANA Administration Console
Systems: which is the central access point for performing system administration and monitoring activities
Error Log: which contains error and information messages
Properties: which shows the detailed properties of the active resource (for example, the SAP HANA system selected in the Systems view)
Job Log
Systems view description
The Systems view provides you with a hierarchical view of all the SAP HANA systems managed in the SAP HANA studio and their contents. It is the central access point for performing system-specific administration and monitoring activities using the other available editors.
System Monitor (editor) description
The System Monitor is an editor that provides you with an overview of all your SAP HANA systems at a glance. From the System Monitor, you can drill down into the details of an individual system in the Administration editor.
Administration editor description
The Administration editor the main tool for performing administration and monitoring activities.
Administration Editor (Diagnosis Mode)
The Administration editor diagnosis mode allows you to monitor and perform emergency operations on systems to which either no SQL connection is available or the SQL connection is overloaded.
The Administration editor opens automatically in diagnosis mode in the following situations:
- When you open the Administration editor for a system that cannot be reached by SQL
- When you initiate the start, stop, or restart of a system
Monitoring Dashboard description
The Monitoring Dashboard visualizes key aspects of system health and configuration on a single screen with the option to drill down to more detailed views.
From the Systems view, choose Configuration and Monitoring / Open Dashboard
Backup editor description
The Backup editor is the main tool for performing administration and monitoring activities related to backup.
Security editor description
The Security editor is the main tool for managing the following aspects of security administration:
- Password policy
- Auditing
- Data volume encryption
You can access the Security editor in several ways:
- Expand the system in the Systems view and choose the Security entry
- In the context menu of the Systems view, choose Security/Open Security Console.
SQL Console description
Some tasks may require you to work with SQL statements, for example, certain administration tasks can only be performed using SQL. You can enter, execute, and analyze SQL statements in the SQL console.
Subtabs of Landscape tab in Administration editor
Services
Hosts
Redistribution
System Replication
Subtabs of Performance tab in Administration editor
Threads
Sessions
Blocked Transactions
SQL Plan Cache
Expensive Statements Trace
Job Progress
Load
Tools for system administration
- SAP HANA Studio / Administration Console perspective
- SAP HANA Lifecycle Manager Tools
- SAP Solution Manager
- SAP HANA HW Configuration Check Tool
- SAP HANA XS apps
Prerequisites of adding an SAP HANA System in Studio
- The relevant ports in your firewall are open.
- If you want to secure communication between the SAP HANA server and the SAP HANA studio using the Secure Sockets Layer (SSL) protocol, you have configured the server for SSL and imported the trust store file that contains the server root certificate into either the Java keystore or your user keystore on the client.
- You must have a database user, or the necessary infrastructure for Kerberos-based user authentication must be in place.