Introduction
In the last couple of weeks, we have posted new videos to the
SAP HANA Academy to show new features and functionality introduced with
SAP HANA 2.0 Support Package Stack (SPS) 02.
The topic of this blog is the
SAP HANA cockpit 2.0 SP 03 and it is the last blog of this series.
For the previous version of this blog, see
For the full SAP HANA 2.0 SPS 02 blog list, see
Tutorial Video
So far in this series, we have discussed Platform Lifecycle Management (Installation and Update), Security, System Administration, High Availability, Database Backup and Recovery, and Application Lifecycle Management. For most of the topics, SAP HANA cockpit was in the limelight.
To avoid showing the same features again in a dedicated video tutorial about SAP HANA cockpit, I will list the features below and point to the relevant video tutorial.
There are new features for:
- System Administration
- Performance Monitoring and Analysis
- Security Administration
- High Availability and Scalability
- Backup and Recovery
- Database Explorer
System Administration
SAP HANA cockpit for offline administration EOL?
The tool "SAP HANA cockpit for offline administration", hosted by the SAP host agent, was introduced with SPS 11 to cover functionality that could not be provided by the regular SAP HANA cockpit tool, hosted, as it was, by the SAP HANA system itself.
As with SAP HANA 2.0, the cockpit is no longer part of a HANA system, this offline tool is no longer required. All the offline capabilities have now been brought into the SAP HANA cockpit 2.0 (online).
The tool has not yet been removed but you may want to start to prepare yourself that some day, yes alas, it may no longer be with us (or, at the least, incarnates as an undocumented feature like HDB admin).
OLD

NEW
Resource Management in Cockpit Manager
To facilitate resource registrations between SAP HANA cockpit systems, you can now import and export resources in cockpit manager.
Multitenant Database Container System Management
Restricted features, blacklisted parameters, workload allocation, and auto-restart configuration are now all available from the
Manage Databases page.
System Health
The System Health app for multi-host systems has been enhanced with additional functionality.
For the detailed blog about this topic, see
For the video tutorial, see
https://youtu.be/gKPGn8DsLNM
Performance Monitoring and Analysis
Performance Monitor (Changed)
On the
Performance Monitor page, you can now drill-in to the selected time range.
Threads (Changed)
On the
Threads page, you can now identify what transaction is blocking a statement in a dedicated column.
Capture and Replay (Changed)
On the Replay Configuration page, you can now set optional filters (for example, statement type) and select more than one replayer.
Workload Analyzer (Changed)
You now have the possibility with
Workload Analysis (thread samples) to export and import datasets. This enables you to store the data in an application and to analyze it in another system.
For
Workload Analyzer (engine instrumentation) you can now set specific filters (for example, statement hash, thread type, or application source).
Security Administration
Database User and Role Management (Changed)
If you are implementing user authorization based on LDAP group membership, you can now set the authorization mode of a user to LDAP on the
New User page.
Encryption Configuration and Encryption Key Management (New)
You can now view the status and enable
Data Encryption on the
Overview page for not only data volume but also for
Log Volume and
Backup Encryption.
The tile now opens the new
Data Encryption Configuration page where you can see the status of all data encryption services, enable and disable each service, and access the page for managing encryption keys.
The new
Manage Keys page allows you to see the status and version history of all encryption root keys in your database. You can also perform all steps required to change your root keys safely, including creating a password-protected root key backup.
For the detailed blog about this topic, see
For the video tutorial, see
https://www.youtube.com/watch?v=ihYtbuioGBM
High Availability and Scalability
Secondary Read Access (New)
On the
System Replication Overview page, the status for
Secondary Read Access is now displayed in the header (when enabled).
Network Security Settings (New)
On the same page, we can view the network configuration settings.
Monitor Network (New)
A new link has been added to the
Overview page to the
Monitor Network page. On this page, you can measure the network speed between the hosts in a scale-out SAP HANA database with
Measure Network Speed. The result is displayed in the
Network Speed Check list, which provides an overview of all network channels between the involved hosts starting with the slowest network connection.
For the detailed blog about this topic, see
For the video tutorial, see
https://www.youtube.com/watch?v=s3MYBHo8664
Backup and Recovery
Copying an SAP HANA Database
You can now use SAP HANA cockpit to copy a database, system or tenant, within the same system or to a different system. For this, both file-based backups and backups created with third-party tools can be used.
Backup Encryption (Changed)
Native backup encryption can now be enabled and disabled from SAP HANA cockpit.
For the detailed blog about this topic, see
For the video tutorial, see
https://youtu.be/jPCYSpBplvM
SAP HANA Database Explorer
SQL Console Enhancements
The SQL console now displays the name of the connection and also allows you to rename tabs.
Database Object Searching Enhancements
The Object Search now allows you to limit your search to a specific database.
Connection Enhancements
A Connection Status Dialog now appears if you experience network connectivity problems. The dialog allows you to re-establish the connection.
Documentation
For more information, see:
SAP Help Portal
SAP Notes
Thank you for watching
The
SAP HANA Academy provides technical enablement, implementation and adoption support for customers and partners with 1000’s of free tutorial videos.
For the full library, see
SAP HANA Academy Library - by the SAP HANA Academy
For the full list of blogs, see
Blog Posts – by the SAP HANA Academy