SAP HANA Cockpit 2.0 SP 04 What’s New – by the SAP HANA Academy
Introduction
Earlier this week (October 31, 2017), the latest support pack for SAP HANA cockpit 2.0 SP 04 was released-to-customer (RTC).
Support pack 04 introduces some nice new functionality to make administering SAP HANA systems easier, more secure, and more manageable for large scale deployments.
With a new home page on the SAP Help Portal and new guides, finding documentation and relevant information about cockpit has also been greatly enhanced.
Below you will find the most important new features listed with reference to the documentation.
We have also just started a new playlist on the Academy:
New tutorial videos will be added in the upcoming weeks.
For the previous version of this blog, see
For the complete list of the SAP HANA cockpit 2.0 What’s New blogs, see
Documentation
SAP HANA Cockpit
As of SAP HANA cockpit SP 04, the latest cockpit documentation is available on SAP Help Portal. This includes the release notes, the Installation and Update Guide, the Administration guide, and education resources, including openSAP and the SAP HANA Academy.
Getting Started with SAP HANA cockpit – Documentation and training
SAP Help Portal – SAP HANA Cockpit
Administration
Managing Tenant Databases
For tenant management, you can now copy and replicate a tenant database, reset the SYSTEM password and assign the operating system user and group (in case of high isolation level).
For more information, see
- Managing Tenant Databases – SAP HANA Administration with SAP HANA Cockpit
SAP HANA Cockpit – Manage Databases
Tenant-Specific Licenses
As a tenant database administrator, you can now install and delete tenant-specific licenses in your tenant using the Licensing page. Previously, this was only possible using SQL.
For more information, see
- Install a Permanent License – SAP HANA Administration with SAP HANA Cockpit
SAP HANA Cockpit – License
Stop System
SP 04 introduces ‘soft’ stops for the SAP HANA system as registered resource with a configurable time (5, 15, 30 minutes). Previously, only immediate stops were avaiable.
SAP HANA Cockpit – Manage Systems
Single Sign-on
Single Sign-on (SSO) for registered resources has been available for some time in SAP HANA cockpit 2.0. With SSO enabled (or even enforced) the administrator no longer needs to enter a username and password each time a connection to the database is made.
New in SP 04 is the availability of SSO for the SAP HANA cockpit itself. The administration guide documents how you can configure this using the SAP Cloud Platform (SCP) Identity Authentication service as identity provider (IdP) but if you wish to use another IdP that’s perfectly fine as well, of course.
For more information, see
- Configure SSO Access to the SAP HANA Cockpit – SAP HANA Administration with SAP HANA Cockpit
Collecting Diagnosis Information
You can now collect diagnostics from both existing files and the SAP HANA runtime environment using SAP HANA cockpit. This is mainly used for support analysis.
Previously, to collect this information, you had to either use the command line or use tools that are deprecated or on their way out: SAP HANA cockpit for offline administration and SAP HANA studio.
Now that all the functionality of the SAP HANA cockpit for offline administration has been integrated into SAP HANA cockpit 2.0, the link to the offline cockpit is no longer available from the Overview page.
For more information, see
- Collect and Download Diagnosis Information with the Cockpit – SAP HANA Administration with SAP HANA Cockpit
SAP HANA Cockpit – Diagnosis Files
Registering Offline Resources
Previously, the SAP HANA database needed to be up and running (with a valid license) before you could register it as a resource in the SAP HANA cockpit. This is no longer required. You can now register a resource with SAP HANA cockpit even when the cockpit is unable to connect to the resource. Once the resource is registered, you can use the cockpit to start it or update its license.
A newly registered resource that has an invalid or expired license, are offline or stopped, are listed in the Resource Directory with software version 0.00.000.00.0(UNKNOWN) and state Unknown.
For more information, see
- Register a Resource – SAP HANA Administration with SAP HANA Cockpit
SAP HANA Cockpit – Resource Directory
Cockpit Manager Filtering
You can now filter by type or hostname for Registered Resources and filter by role type for Cockpit Users.
SAP HANA Cockpit Manager – Filter By
Scalability
For large-scale cockpit deployments, scalability support has been enhanced. You can now create hundreds of resource groups and cockpit users. Previously, the limit was 100 groups and users.
Cockpit API
SAP HANA cockpit now offers REST APIs that you can use with a third-party tool to register resources, create users and groups, and add users and resources to groups.
For more information, see
- Managing Resources, Users, and Groups with the Cockpit APIs – SAP HANA Administration with SAP HANA Cockpit
User Management and Security Administration
Database User and Role Management
As of SP 04, you can now also assign privileges to users (assigning privileges to roles was added in SP 03). This concludes the studio-cockpit feature parity for database user and role management.
SAP HANA Cockpit – Assign Privileges
Using the Role page of the SAP HANA cockpit, you can now map LDAP groups to roles If case you are implementing user authorization based on LDAP group membership. Previously, this was only possible using SQL.
SAP HANA Cockpit – Roles
The Role page now also shows the role type.
For more information, see
Auditing
You can use both the file system and the database as audit trail target but if you selected database tables, you can now delete old audit entries using Auditing page of the SAP HANA cockpit. Typical reason might be that you want to avoid the audit table becoming too large.
For more information, see
SAP HANA Cockpit – Auditing
Performance Monitoring and Analysis
Collecting Performance Monitor Data
On the Performance Monitor page, you can now import and export collected data.
For more information, see
SAP HANA Cockpit – Performance Monitor
Memory Analysis
Memory analysis may be required to troubleshoot out-of-memory incidents or to investigate unusual memory usage. As of SP 04, you can now display the details about which allocators are consuming the most memory.
For more information, see
- Analyze Memory Statistics – SAP HANA Administration with SAP HANA Cockpit
SAP HANA Cockpit – Memory Analysis
Workload Classes
It is now possible to disable or enable an existing workload class. This will make it easier to test and evaluate the effectiveness of the workload class.
For more information, see
- Managing Workload Classes in SAP HANA Cockpit – SAP HANA Administration with SAP HANA Cockpit
SAP HANA Cockpit – Workload Classes
Capture and Replay
On the Replay Configuration page in the User Authentication area it is now possible to reset the password for the database users captured in the source system.
Additionally, on the Overview tab, you can now view a comparison of the SQL statements based on results and runtime information. This makes it easier to focus on SQL statements which have a different performance in the execution time, for example, or to identify the reasons why the replay failed.
SAP HANA Cockpit – Replay Configuration
Workload Analyzer
SAP HANA cockpit 2.0 SP 04 introduces new functionality for both the Workload Analyzer Based on Thread Samples and for the Workload Analyzer Based on Engine Instrumentation.
On the Thread Samples page, the filters adjustable in the header bar now apply to all charts.
SAP HANA Cockpit – Workload Analysis
For Engine Instrumentation (Capture and Replay), on the Capture Information page, you can now view and compare information on a traced workload and also load the trace.
On the Workload Analyzer page, SQL Statements tab, you can now select a particular workload to analyze its Plans and Jobs, and perform a hierarchical analysis of data by adding Request ID to the dimensions.
SAP HANA Cockpit – Capture Information
Monitoring System Replication
Finally, three new monitoring features are available for system replication.
The System Replication Overview page, the tables that provide information on the replicating services also display the corresponding tenant database names.
On the Log Shipping Backlog Site 1 to 2 tab, we now get log shipping backlog 24 hours history in a graph displaying different colours should the thresholds set for alert 104 have been surpassed.
On the Replicated Services tab, the replication status tenantcopy is now displayed when a tenant is being copied or moved in the primary system.
For more information, see
SAP HANA Database Explorer
There have been several enhancements to both the Catalog Browser and SQL Console for the SAP HANA Database Explorer which will improve the ease-of-use of this tool.
Additionally, the explorer now also has its own guide.
For more information, see
Catalog Browser Enhancements
Three handy enhancements have been added to the catalog browser of the SAP HANA Database Explorer:
- The context menu (right-click) now includes connection information (hostname, database)
- The context menu for catalog objects now includes the option to generate the SELECT statement.
- When you add filters to the result set of Open Data, a counter now shows the number of active filters.
SAP HANA Database Explorer – Connection Information
SAP HANA Database Explorer – Generate SELECT Statement
SAP HANA Database Explorer – Open Data
SQL Console Enhancements
Similarly, the Run drop-down menu in the SQL console now contains the Run Statement option (F9) which runs a multi-line SQL statement.
The shortcut key for the Analyze SQL option is now Ctrl-Shift-X.
Should one of the SQL statements in a script (or sequence of statements) return an execution error, you can now choose whether to ignore the error (and continue with the rest of the statements) or abort.
SAP HANA Database Explorer – SQL Console
SAP HANA Database Explorer – SQL Console
Documentation
For more information, see:
SAP Community Blogs
SAP Help Portal
- SAP HANA Cockpit
- NA Database Explorer Guide
- SAP HANA Cockpit SP 04 Features – What’s New in the SAP HANA Cockpit 2.0 (Release Notes)
- SAP Cloud Plaform Identity Authentication – SAP Cloud Platform
- SAP HANA Administration with SAP HANA Cockpit
- Setting Up Single Sign-On
- Register a Resource
- Collect and Download Diagnosis Information with the Cockpit
- Disable or Enable a Workload Class
- Managing Tenant Databases
- Analyze Memory Statistics
- Install a Permanent License
- Managing Resources, Users, and Groups with the Cockpit APIs
- Collecting Performance Monitor Data for SAP Support
- Capturing and Replaying Workloads
- Analyzing Workloads
- Database Role Details
- Delete Audit Entries
- Monitoring SAP HANA System Replication with the SAP HANA Cockpit
SAP Notes
- 2513227 – SAP HANA cockpit 2.0 SP 04
- 2362820 – SAP HANA Performance Management Tools
- 2373065 – SAP HANA 2.0 Database Explorer Release 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
- Subscribe to our YouTube channel for updates
- Join us on LinkedIn linkedin.com/in/saphanaacademy
- Follow us on Twitter @saphanaacademy
- Google+ plus.google.com/+saphanaacademy
- Facebook facebook.com/saphanaacademy