SAP BASIS - Hana Cockpit explain
The SAP HANA cockpit is an SAP Fiori Launchpad site that provides you with a single point-of-access to a range of Web-based applications for the administration of SAP HANA.
The SAP HANA cockpitis installed with SAP HANA as automated content.
-which user has authorization for SAP HANA Cockpit?
After database creation, you will have to log on for first time as the user SYSTEM. In this case, the required roles will be assigned automatically
In order to access SAP HANA Cockpit the following roles need to be assigned.
sap.hana.admin.roles::Monitoring
or
sap.hana.admin.roles::Administrator
These roles allow you to open the cockpit and access the tiles in the
SAP HANA Database Administration
catalog.
If you're opening the cockpit on the system database of a multiple-container, you also need the role
sap.hana.admin.cockpit.roles::SysDBAdmin
so that you can access the tiles in the
SAP HANA System Administration
catalog.
-How can I access SAP HANA Cockpit?
You could access SAP HANA Cockpit directly through the url or you could go to SAP HANA Studio -->Right Click on the System in Navigation Pane --> Configuration and Monitoring --> Open SAP HANA Cockpit
System type SAP HANA Cockpit URL
Single-container system http://<host_FQDN>:<port>/sap/hana/admin/cockpit
System DB of multi-container system http://<host_FQDN>:<port>/sap/hana/admin/cockpit
Tenant DB in multi-container system http://<tenant_DB_FQDN>:<port>/sap/hana/admin/cockpit
-Does SAP HANA Cockpit have all functionality as in SAP HANA Studio?
No, as of SAP HANA SPS 10 not all functionality is available in SAP HANA Cockpit compared to SAP HANA Studio.
SAP HANA Developmnet is constantly improving and adding new functionalities to SAP HANA Cockpit.
-From which revision is SAP HANA Cockpit available?
SAP HANA Cockpit is available only starting SPS 09.
-Can I access SAP HANA cockpit when the DB is offline?
No, SAP HANA cockpit is not available when the DB is down.
-Is there a mode similar to diagnosis mode in cockpit when SAP HANA Database is not available?
Starting SPS11, we have an offline mode in SAP HANA cockpit. To access the offline mode there are two options:
navigate from standard SAP HANA cockpit
https://<host>:1129/lmsl/hdbcockpit/<SID>/index.html
-Can we access load graph also from SAP HANA Cockpit?
Yes, load graph is available in SAP HANA Cockpit.
SAP HANA Cockpit --> Tile “SAP HANA Database Administration” --> Clicking on any of the tile "used memory, CPU usage, disk usage" leads you to screen with load graph.
You need to select the KPI that you want to analyze
-Is it possible to take backups via SAP HANA Cockpit?
Yes, backups can be triggered from SAP HANA Cockpit.
Please note to trigger delta backup from SAP HANA Cockpit minimum requirement is SAP HANA SPS11.
-Can we monitor alerts and configuration within SAP HANA Cockpit?
Alert monitoring and alert configuration is possible with the SAP HANA cockpit only if the monitoring and alerting
functions in the system are being implemented by the embedded statistics service, not the statistics server.
SAP HANA revisions above 93 automatically have embedded statistics service.
-Is there a separate HANA cockpit for tenant database administrators?
No, there is only one SAP HANA cockpit per Database. You can administrate the tenants through System DB administrator on cockpit.
-Is it possible to configure parameters within SAP HANA cockpit?
No, configuring parameters still need to be performed using SAP HANA studio.
-Is there a special view in HANA cockpit for Multitenant database?
Yes, on multitenant database systems there is tile catalog "SAP HANA System Administration" that gives an overview on tenants and their status.
Click on Manage Database tile to get additional information
-Is there a section Diagnosis files in SAP HANA cockpit?
Yes, there is a tile “Number of Dumps” in Tile catalog “SAP HANA Database Administration”, this will open a new window for SAP-based development workbench that contains the traces.
Please note in multitenant system, the trace section holds only the traces of the System DB and not the tenant DB, therefore no indexserver traces would be available.
-Is there a possibility to view the memory allocation?
Yes, Go to Tile “Manage Services” under catalog “SAP HANA Database Administration”, then click on the used memory of any service.
A new window will show the memory allocation:
Please note for multitenant database this view is from single tenant database.
-Where can I monitor threads/sessions in SAP HANA Cockpit?
Unfortunately, threads/sessions monitor is not yet available in cockpit so SAP HANA studio needs to be used.
The SAP HANA cockpitis installed with SAP HANA as automated content.
-which user has authorization for SAP HANA Cockpit?
After database creation, you will have to log on for first time as the user SYSTEM. In this case, the required roles will be assigned automatically
In order to access SAP HANA Cockpit the following roles need to be assigned.
sap.hana.admin.roles::Monitoring
or
sap.hana.admin.roles::Administrator
These roles allow you to open the cockpit and access the tiles in the
SAP HANA Database Administration
catalog.
If you're opening the cockpit on the system database of a multiple-container, you also need the role
sap.hana.admin.cockpit.roles::SysDBAdmin
so that you can access the tiles in the
SAP HANA System Administration
catalog.
-How can I access SAP HANA Cockpit?
You could access SAP HANA Cockpit directly through the url or you could go to SAP HANA Studio -->Right Click on the System in Navigation Pane --> Configuration and Monitoring --> Open SAP HANA Cockpit
System type SAP HANA Cockpit URL
Single-container system http://<host_FQDN>:<port>/sap/hana/admin/cockpit
System DB of multi-container system http://<host_FQDN>:<port>/sap/hana/admin/cockpit
Tenant DB in multi-container system http://<tenant_DB_FQDN>:<port>/sap/hana/admin/cockpit
-Does SAP HANA Cockpit have all functionality as in SAP HANA Studio?
No, as of SAP HANA SPS 10 not all functionality is available in SAP HANA Cockpit compared to SAP HANA Studio.
SAP HANA Developmnet is constantly improving and adding new functionalities to SAP HANA Cockpit.
-From which revision is SAP HANA Cockpit available?
SAP HANA Cockpit is available only starting SPS 09.
-Can I access SAP HANA cockpit when the DB is offline?
No, SAP HANA cockpit is not available when the DB is down.
-Is there a mode similar to diagnosis mode in cockpit when SAP HANA Database is not available?
Starting SPS11, we have an offline mode in SAP HANA cockpit. To access the offline mode there are two options:
navigate from standard SAP HANA cockpit
https://<host>:1129/lmsl/hdbcockpit/<SID>/index.html
-Can we access load graph also from SAP HANA Cockpit?
Yes, load graph is available in SAP HANA Cockpit.
SAP HANA Cockpit --> Tile “SAP HANA Database Administration” --> Clicking on any of the tile "used memory, CPU usage, disk usage" leads you to screen with load graph.
You need to select the KPI that you want to analyze
-Is it possible to take backups via SAP HANA Cockpit?
Yes, backups can be triggered from SAP HANA Cockpit.
Please note to trigger delta backup from SAP HANA Cockpit minimum requirement is SAP HANA SPS11.
-Can we monitor alerts and configuration within SAP HANA Cockpit?
Alert monitoring and alert configuration is possible with the SAP HANA cockpit only if the monitoring and alerting
functions in the system are being implemented by the embedded statistics service, not the statistics server.
SAP HANA revisions above 93 automatically have embedded statistics service.
-Is there a separate HANA cockpit for tenant database administrators?
No, there is only one SAP HANA cockpit per Database. You can administrate the tenants through System DB administrator on cockpit.
-Is it possible to configure parameters within SAP HANA cockpit?
No, configuring parameters still need to be performed using SAP HANA studio.
-Is there a special view in HANA cockpit for Multitenant database?
Yes, on multitenant database systems there is tile catalog "SAP HANA System Administration" that gives an overview on tenants and their status.
Click on Manage Database tile to get additional information
-Is there a section Diagnosis files in SAP HANA cockpit?
Yes, there is a tile “Number of Dumps” in Tile catalog “SAP HANA Database Administration”, this will open a new window for SAP-based development workbench that contains the traces.
Please note in multitenant system, the trace section holds only the traces of the System DB and not the tenant DB, therefore no indexserver traces would be available.
-Is there a possibility to view the memory allocation?
Yes, Go to Tile “Manage Services” under catalog “SAP HANA Database Administration”, then click on the used memory of any service.
A new window will show the memory allocation:
Please note for multitenant database this view is from single tenant database.
-Where can I monitor threads/sessions in SAP HANA Cockpit?
Unfortunately, threads/sessions monitor is not yet available in cockpit so SAP HANA studio needs to be used.