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.
cancel
Showing results for 
Search instead for 
Did you mean: 
dvankempen
Product and Topic Expert
Product and Topic Expert

Introduction


Earlier this week (January 23, 2018), SAP HANA cockpit 2.0 SP 05 was released-to-customer (RTC).

Below you will find an overview of the new features with reference to the documentation.

 

For the full SAP HANA cockpit playlist on YouTube, see

For the previous version of this blog, see

For a complete list of the SAP HANA cockpit 2.0 What's New blogs, see

For the Getting Started with SAP HANA cockpit 2.0 blog, see

 

Documentation


New features and known issues are documented in

For all SAP HANA cockpit documentation, see



SAP HANA Cockpit SP - Release Notes

 

Software Download


You can download the support pack from Software Downloads on the SAP ONE Support Portal:



SAP Software Downloads: HANA Cockpit 


Update


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.

For more information, see



Cockpit Manager - Cockpit Roles

 

Fine Tuning Cockpit Settings


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.

For more information, see



Cockpit Manager > Settings > Data Collection



Cockpit Manager > Settings > Connections



Cockpit Manager > Settings > Display

 

Name that Resource (even offline)


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.



Cockpit Manager > Register Resource: Resource Name

 

Stop System


You can now stop (or start) systems directly from the Overall (System) Database Status tile.

For more information, see



Cockpit > Overview > Stop | Start System

 

Change Layers


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 more information, see



Cockpit > Configuration of System Properties > Change Layer

 

User Management and Security Administration


Cutting Corners: Grant Privileges to User


There is a new page (or app, if you prefer), Assign Privilege, which allows you to directly grant privileges to a user.

The best practice remains to grant privileges to roles and assign roles to users but for those that prefer quick-and-dirty: at your service!

There are links to both Assign Roles and Assign Privileges on the Users page.

For more information, see





Cockpit > Assign Privileges



Cockpit > User > Assign Privileges

 

Filter, Sort, and Group the Audit Table Log


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.

For more information, see



Cockpit > Auditing > Audit Table Log



Cockpit > Auditing > Audit Table Log > Configure

 

Audit Logging for the Cockpit


To track events for the cockpit itself you can now use the Audit Logs app accessible from the XS Advanced Administration tool.

For more information, see



Audit Logs

 

Backup and Recovery


Backup Configuration


SP 05 adds a page to edit (or view) the backup configuration for each database (Catalog Settings, Log Settings, and Data Backup).

For more information, see



Cockpit > Manage Databases > Configure Backup







Backup Configuration

 

Performance Monitoring and Analysis


Memory Analysis


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.

For more information, see



Cockpit > Overview: Memory Usage



Cockpit > Memory Analysis

 

Monitor Volumes and Reclaim Space


SP 05 adds a Disk Volume Monitor page, where you view disk statistics (per host, tenant, type (data or log), service and volume ID.

Links to Reclaim Space, Backup and configure System Replication are included.

For more information, see



Cockpit > Disk Volume Monitor



Cockpit > Disk Volume Monitor: Reclaim Space

 

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.

For more information, see



Cockpit > Capture and Replay > Configure New Capture





Cockpit > Replay Workload > Replay Management > Replay Configuration

 

Performance Monitor - Presets and Comparisons


Presets in the Performance Monitor makes it easier to select any of the most common time frames.

Additionally, you can now easily compare KPI performance with Performance Comparison.

For more information, see



Cockpit > Performance Monitor: Preset



Cockpit > Performance Monitor > Performance Comparison

 

Workload Analyzer


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.


For more information, see


Cockpit > Workload Analysis 

 

Threads - Filter, Sort, and Group


Several enhancements have been made to the Threads page:

  • Filter threads by host, service, and thread type

  • Select the sorting parameters of the threads with the Group and Sort option

  • Get the Call Stack information for the selected thread.

  • Define the columns by choosing parameters that will be displayed in the table.


For more information, see



Cockpit > Threads

Workload Admission Control Settings


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.

For more information, see



Cockpit > Manage Workload Classes 



Cockpit > Manage Workload Classes > Manage Admission Control

 

Workload Classes


You can now import (and export) Workload classes for exchange between systems.

For more information, see

The creation of workload class mappings has been enhanced with application component name and application component type.

For more information, see



Cockpit > Manage Workload Classes > Import



Cockpit > Manage Workload Classes > Create Class

 

Statements Monitor and Expensive Statements


It is now possible to set up or modify the workload class of a statement on the Statements Monitor and Expensive Statements page.

For more information, see

 

SAP HANA Database Explorer


Trace Configuration


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.

For more information, see



SAP HANA Database Explorer > Trace Configuration



SAP HANA Database Explorer > Trace Configuration > Kernel Profiler



SAP HANA Database Explorer > Trace Configuration > Expensive Statement Trace



SAP HANA Database Explorer > Add to Statement Library



SAP HANA Database Explorer: Statement Library

SQL Analyzer


Several enhancements have been made to the SQL Analyzer:

  • View the details of table accesses performed (Table Accesses List tab),

  • Get aggregated information for each column and choose aggregator functions, filter and sort the results, and customize columns.

  • Re-execute the SQL query with parameter changes.

  • Open SQL Analyzer through the Statement Hints page.>

  • Move to Operator List after selecting the Tables Used tile in Overview.

  • Split the areas between the operators and the timeline chart.


Additionally, the Plan Graph now displays critical paths.

For more information, see



Cockpit > Monitor Expensive Statements > SQL Analyzer: Input Parameters



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.

For more information, see

 

System Health


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.

For more information, see

 

Documentation


For more information, see:

SAP Community Blogs



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

 

5 Comments