In a distributed environment, it is required to perform the start of HANA systems. It could be after a maintenance task, backup, and recovery, or some other reason. A start of single system or multiple systems can be performed using SAP HANA cockpit Offline Administration or using SAP HANA Studio.

Start a System Using HANA Cockpit

Navigate to SAP HANA Database Administration → SAP HANA Cockpit for Offline Administration.

sap 65

Navigate to Open the System Operations app by clicking the Start, Stop, Restart tile on the homepage of the SAP HANA cockpit for offline administration.

sap 66

At the bottom, you have an option to Start the System. When you click on Start System, database services start one by one. In case your environment contains multitenant database containers, it starts the services of all tenant databases.

The status of the system shows “Running” when all the services are successfully started.

sap 67

SAP HANA Admin – Stopping a HANA System

You can stop all SAP HANA systems using SAP HANA Cockpit for offline administration option in HANA Cockpit. In multitenant database container system, all tenant databases will be stopped using this option.

sap 68

When all the services are stopped one by one for all the databases, it shows the status of system as “Stopped” as shown in the following screenshot.

sap 69

You can also use the SAP HANA Cockpit for offline administration to restart SAP HANA system. In the multitenant database environment, when you select Restart from the footer bar, it also restarts all the tenant databases.

Start and Stop a System in HANA Studio

To perform a start/stop of a single HANA system or in multiple container system, you can also use SAP HANA Studio. All the tenant databases which are stopped individually has to start separately in HANA Studio.

Stopping a system is required in certain scenarios, when you have to make certain configuration changes, maintenance, patch upgrade, or other scenarios.

To start a system, navigate to System view and right-click HANA system that you want to start and stop → Configuration and Monitoring → Start System.

Monitoring the HANA System

System Monitor in HANA Studio provides an overview of all your HANA system at a glance. From System Monitor, you can drill down into the details of an individual system in the Administration Editor. It tells about Data disk, Log disk, Trace disk, Alerts on resource usage with priority.

The following information is available in the System Monitor −

sap 70

SAP HANA alert monitoring is used to monitor the status of system resources and services that are running in the HANA system. Alert monitoring is used to handle critical alerts like CPU usage, disk full, FS reaching threshold, etc. The monitoring component of HANA system continuously collects information about health, usage, and performance of all the components of HANA database. It raises an alert when any of the component breaches the set threshold value.

The priority of alert raised in HANA system tells the criticality of the problem and it depends on the check that is performed on the component. Example: If CPU usage is 80%, a low priority alert will be raised; however, if it reaches 96%, the system will raise a high priority alert.

The System Monitor is the most common way to monitor HANA system and to verify the availability of all your SAP HANA system components. The System monitor is used to check all key components and services of a HANA system.

sap 71

You can also drill down the details of an individual system in Administration Editor. It tells about Data disk, Log disk, Trace disk, alerts on resource usage with priority.

sap 722

Alert tab in Administrator editor is used to check the current and all other alerts in HANA system.

sap 73

It also shows the time when an alert is raised, the description of the alert, the priority of the alert, etc.

SAP HANA monitoring dashboard shows the key aspects of system health and configuration.

sap 74

You can also use SAP HANA Cockpit for system monitoring and alerts. SAP HANA Cockpit can be opened directly from HANA Studio or you can also open it via web browser. You should have sap.hana.admin.roles::Monitoring or sap.hana.admin.roles::Administrator role assigned to access SAP HANA Database Administrator catalog access.

sap 75

So, this brings us to the end of blog. This Tecklearn ‘How to Start, Stop and Monitor a HANA System’ blog helps you with commonly asked questions if you are looking out for a job in SAP Hana Administration and SAP Domain. If you wish to learn SAP Hana Administration and build a career in SAP domain, then check out our interactive, SAP HANA Administration Training, that comes with 24*7 support to guide you throughout your learning period. Please find the link for course details:

https://www.tecklearn.com/course/sap-hana-administraion/

SAP HANA Administration Training

About the Course

SAP HANA Administration training will help you learn SAP HANA administration tools, security and user management, system management and availability, data provisioning and integration with non-SAP systems and more. You will deploy SAP HANA Studio, automate through OS scripts, command line admin tools through hands-on projects and case studies. This course is designed to clear the HA200 SAP HANA Operations and Administration Certification conducted by SAP and helps you get the best jobs in top MNCs.

Why Should you take SAP HANA Administration Training?

The average salary for SAP HANA Database Administrator ranges from approximately $65,843 yearly for Administrator to $143,051 yearly for Enterprise Architect. – Indeed.com
SAP HANA is one of the top tools for working with real-time data due to the transformational nature of this tool. The role of an SAP HANA Administration and Operations personnel is critical of the success of SAP HANA deployment in any industrial set-up.
Worldwide Business Intelligence and Analytics Market to grow to $22.8 billion in next 2 years – Gartner.

What you will Learn in this Course?

Overview of SAP HANA

Overview of SAP HANA
Features and Benefits of SAP HANA
SAP HANA Components
Concept of SAP HANA guides
Scenarios in SAP HANA Administration

Architecture of SAP HANA

What is SAP HANA persistence?
Concept of Sizing in SAP HANA
Process of achieving scale out in SAP HANA
How SAP HANA achieves in-memory computation
Concept of columnar database
How SAP HANA is so fast with comparison to other tools

SAP HANA installation

Overview of SAP HANA tools

SAPA HANA Studio for Administration activities in SAP HANA
Accessing local and remote HANA systems using Client Tool
Monitor, Control, Configure and Administer the SAP HANA database using DBA Cockpit
Using HANA Studio Information modelling and data provisioning in HANA database
SAP HANA Transport

SAP HANA Operations

Privileges in HANA
Configure Password Policy and create user in SAP HANA
Auditing in SAP HANA

SAP HANA Smart Data Access

Data Provisioning in SAP HANA

Leveraging SAP HANA technology and integration architecture for enriching, cleansing and transforming data from disparate sources
Data replication with the SAP Landscape Transformation (SLT)
Implementing SLT Configuration with SUSPEND LOAD

SAP HANA Operations

Create Repository and Job Server
SAP GRC Architecture

Administration Operations in HANA Studio

Updating HANA database using lifecycle management
Security in SAP HANA
Sessions and Transactions in SAP HANA
Configure System Replication using HANA Cockpit

Migration to SAP HANA using DMO

Performance Monitoring and Analysis in SAP HANA

Got a question for us? Please mention it in the comments section and we will get back to you.

703