SAP HANA Cockpit 2.0 SP 05 What’s New – by the SAP...
Technology Blogs by SAP
Learn how to extend and personalize SAP applications. Follow the SAP technology blog for insights into SAP BTP, ABAP, SAP Analytics Cloud, SAP HANA, and more.
Updating SAP HANA cockpit is very similar to installation. Below a video tutorial where we demonstrate an update from the SP 04 release to SP 05.
SAP HANA platform installation and update – Update SAP HANA cockpit
Administration
Improved Cockpit Resource Management
SAP HANA cockpit SP 02 introduced the cockpit user roles Cockpit Administrator, Cockpit Resource Administrator, and Cockpit User to enable separation of duties for cockpit and, as a result, a more secure environment.
In SP 05, this has been further enhanced with the roles Cockpit User Administrator and Cockpit Power User. A power user can register a resource but will have to request the resource administrator to add the resource to a resource group and assign its users.
In SP 05, the collection schedule for availability, performance, capacity, and alerts (APCA) statistics is now configurable. This parameter defaults to 60 seconds and the documentation adds that "This should only be performed if necessary." Additionally, you can also change the number of worker threads for the collection service (defaults to 10). Increasing threads can improve response time but uses more memory.
In Settings, you can now also configure connection timeouts and whether resource groups should be generated automatically for certain system types.
As a reminder, the system type for the SAP HANA database server - Production, Test, Development, Custom - is a configurable parameter, typically set during installation. Systems with system_type=production trigger specific client behavior in SAP HANA cockpit and studio, for example, returning an are-you-sure? warning when executing SQL, etc.
You can now provide a custom name for a resource (or stick to the default database@SID) when registering and/or editing a resource in the Cockpit Manager.
SP 04 introduced registering offline resources. This has now been extended to the import functionality.
On the Configuration of System Properties page, it is now much easier to change the layer (system, host, database) for a given parameter. The dialog (window) has been improved.
For audit trails with the database as target (not syslog or CSV), log entries are now displayed on the Auditing page. There are a lot of columns (35) that you can display plus options to filter, sort and group.
A link (Analyze Memory Statistics) to the Memory Analysis page is now directly accessible from the Memory Usage tile on the Overview page.
Should any out of memory event occur, you can now access the SAP Database Explorer Dump Viewer for the relevant trace files from the Out of Memory Events tab on the Memory Analysis page.
Capture and Replay - Backup, Thresholds, and Syncs
Several enhancements have been made to Capture and Replay. It is now very easy to make that recommended full backup after a capture: include it with the capture or trigger it from the Monitor Capture page.
To avoid unintended and misleading classifications in the replay report for statements that display minor runtime differences, you can now set a threshold value during the preprocessing step.
It is now also possible to synchronize the replay with an existing database backup on the Replay Configuration page.
Several enhancements have been made to the Workload Analyzer Based on Thread Samples page:
The page now opens with a chart displaying top SQL statements by lock time.
You can choose different operation periods to be displayed, and choose an entry on the chart to have more information displayed below along with the full SQL statement. Once a bar is selected, the corresponding information will be added to the filter on the analysis page.
You can navigate to the original analysis page by clicking Analyze in the footer bar.
Admission Control was introduced in the initial release of SAP HANA cockpit 2.0. New for SP 05 is the configuration page. Previously, admission control was only configurable through SQL.
In SP 05, trace configuration has been enhanced. You can now configure tracing for the kernel profiler to analyze performance issues with systems on which third-party software cannot be installed, or for parts of the database that are not accessible by the performance trace.
Additionally, you can now also configure tracing for expensive statements whose execution time exceeded a configured threshold.
Statement Library
Also new in SP 05 is the Statement Library which contains a number of default system statements but also allows you to add SQL statements of your own.
Cockpit > Monitor Expensive Statements > SQL Analyzer: Operator List
Cockpit > Manage Statement Hints: Add Statement Hint
High Availability and Scalability
Reinitializing the Secondary System
With SP 05 it is now possible to re-register a stopped secondary system. For example, in case full data shipping is needed or when you want to change the operation mode.
On the System Health page, by selecting specific system health information, you can now drill down to details on specific KPIs displayed in the Performance Monitor and the Workload Analyzer.
The SAP HANA Academy provides technical enablement, implementation and adoption support for customers and partners with 1000’s of free tutorial videos.