Skip to main content

SAP HANA Cockpit Introduction and Use Case

The SAP HANA cockpit 2.0 provides a single point of access to a range of tools for administration and detailed monitoring of SAP HANA databases. It also integrates development capabilities required by administrators through the SAP HANA Database Explorer. 


The SAP HANA cockpit 2.0 is a web-based HTML5 user interface that you access through a browser. It runs on SAP HANA extended application services, advanced model (XS advanced). 


The cockpit handles single-container and multi-container systems as of SAP HANA 1.0 SPS 12. 


You can use the cockpit to monitor and manage multiple SAP HANA database systems and tenants


The cockpit can be installed separately on dedicated hardware, shared hardware or in an existing SAP HANA database tenant. It provides greater flexibility, because it allows you to

manage more than one SAP HANA system in a single administration environment


SAP HANA Cockpit : 


Centralized system and database administration features, such as database monitoring, user management, and data backup.


  • Start and stop services

  • To monitor the system

  • To configure system settings

  • Manage users and authorizations.



Cockpit Manager

SAP HANA Cockpit 

SAP HANA database explorer

Used by the cockpit administrator to register databases and to create

groups and cockpit users for accessing SAP HANA cockpit.

Screen shows a high level aggregated overview of all registered

systems. From this aggregated landscape overview level you can quickly drill down to a

detailed overview of an individual database. In the database overview screen you find cards

for all important parts of the SAP HANA database.



The SAP HANA database explorer tool is integrated into the SAP HANA cockpit. The database explorer allows you to query information about the database using SQL statements, and to view information about your database's catalog objects


https://<hostname>:51026/



The Database Directory is like a summary of all the databases you're responsible for. If you see a database marked as Stopped, Running with issues, or Unknown, it means there's a problem. To figure out what's wrong, you can go to the System Overview page in the cockpit by selecting the corresponding line.


If the entire SAP HANA database system is having issues, it's crucial to quickly find out why so you can fix it and get everything running smoothly again. Even if the whole system is down, you can still use the cockpit to investigate the main cause of the problem. This is done through the SAP start service connection


Other feature in SAP HANA COCKPIT ➖


Manage Tenant :  


Navigate through the SAP HANA Cockpit using the following steps:
  • Start from the Home screen in the SAP HANA Cockpit.
  • Choose the "Database Directory" tile or navigate to your personal group tile.
  • Within the Database Directory screen, locate and select the "Manage Databases" link.
  • In the "Manage Databases" screen, identify the tenant database that you wish to start.
  • For the selected tenant database, click on the "Start" button.

Manage Service : 

  

Navigate through the SAP HANA Cockpit following these steps:


  • On the Home screen, select the "Database Directory" tile.

  • Within the Database Directory, identify the SYSTEMDB that is currently stopped.

  • Access the Database Overview screen for the identified SYSTEMDB.

  • Locate the "Services" card on the Database Overview screen.

  • To initiate the startup of the database system, click on the "Start Database" button within the Services card.

 This is a running blog and we will keep on updating this with other details.

Comments

You might find these interesting

8 Must-Know Questions About Object Store on SAP Business Technology Platform

What is the problem that Object Store solves ? Modern enterprise systems increasingly deal with massive volumes of unstructured data such as documents, logs, media files, and backups. Traditional relational databases are not optimized for such workloads. What is Object Store ? Object storage—commonly referred to as blob storage—addresses this gap by providing scalable, durable, and cost-efficient storage for unstructured data. Object storage is a storage architecture designed to manage unstructured data as discrete units called objects.  Each object consists of: Binary data (file content) : Image , File etc Metadata (descriptive attributes) : File size, Content type, Last modified timestamp, Storage class (hot, cool, archive) Unique identifier (key or URL) : unique path-like string used to locate a blob inside a bucket Unlike file systems or relational databases, object storage does not rely on hierarchical file structures or schemas. The SAP BTP Object Store service is a managed, ...