Skip to Content
Product Information

SAP HANA Cockpit 2.0 SP 09 What’s New – by the SAP HANA Academy

Introduction

In the upcoming days and weeks, we will be posting new videos to the SAP HANA Academy to show new features and functionality introduced with SAP HANA cockpit 2.0 SP 09, released February 2019.

For the full SAP HANA cockpit playlist on YouTube, see

 

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

For the How to Install / Update blog, see

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

Installation and Update

No changes: the installation and update process for SP09 is the same as for the previous release(s).

Tutorial video: Update

Administration and Monitoring

Cockpit Troubleshooting User Role (New)

Grant a user the Cockpit Troubleshooting Role. This allows the user to access XSA Logs in Cockpit Manager.

SAP HANA Cockpit Manager, Create User

SAP HANA Cockpit Manager, XSA Logs

For the documentation, see

Creating a Technical User during Registration (New)

Create a technical user during resource registration. Each resource needs a technical user to collect resource statistics, a.k.a. “health data”.  Before, you had to create this user separately using another tool.

SAP HANA Cockpit Manager, Create Technical User

For the documentation, see

Resource Enhancements (New)

Searching and sorting registered resources in Cockpit Manager and the Resource Directory has been made easier.

Unregister groups of resources.

SAP HANA Cockpit Manager, Registered Resources

For the documentation, see

System Overview Enhancements (New)

New in the System Overview

  • Right click on a link to open in a new browser tab or window
  • Delete custom tiles

SAP HANA Cockpit, System Overview

Managing System Configuration (Changed)

Take and compare (database point-in-time) snapshots in System Configuration. Previously, this was only possible for the current database configuration.

SAP HANA Cockpit, Configuration Manager

SAP HANA Cockpit, Configuration Manager

For the documentation, see

Table Placement Editor (Changed)

Create a new table placement rule by copying an existing rule and reusing the same or modified parameters. Previously, you could only create new ones.

For the documentation, see

Performance Monitoring and Analysis

Capture and Replay (New and Changed)

On System Overview

  • Start captures directly from the Capture Workloads tile (and stop when running). The tile displays capture name, start time, and duration.
  • Start replays directly from the Replay Workloads tile (and stop when running). The tile displays  name, start time, and duration.

SAP HANA Cockpit, System Overview

In Replay Configuration

  • Authenticate users with a Secure User Store Key.
  • >Choose Reset Password to reset at once the passwords for all users not authenticated by external tools or created during the replay.

SAP HANA Cockpit, Replay Configuration

In addition, you now trigger and monitor the export of a replay report. The export contains both data from the captured workload as well as the results of a replay.

For the documentation, see

SQL Analyzer (New and Changed)

Choose to color nodes by either Type or Location and set the default inner plan to Physical or Location in Plan Graph Settings.

SAP HANA Cockpit, SQL Analyzer, Plan Graph, Settings

SAP HANA Cockpit, SQL Analyzer, Plan Graph

For the documentation, see

Workload Analyzer (New)

Navigate from Workload Analyzer to Current Table Distribution (distributed systems).

For the documentation, see

Performance Monitor (Changed)

A new hierarchically sorted table legend that displays the KPI unit, y-axis scale, as well minimum, maximum, and average values.

For the documentation, see

SAP HANA Database Explorer

Client-side Encryption (New)

Database Explorer supports execution of client-side encryption-related SQL statements.

Import Data (New)

Import data supports batch inserts to improve performance. New tables are created regardless of whether or not the data is successfully inserted.

Import/Export HDI Containers (New)

Import and export HDI containers from the database explorer. Requires the HDI Container Group Administrator permission.

SQL Console GlobalPreferences (New)

  • Indicate potential SQL errors
  • Parse text into multiple statements before executing
  • Auto-commit new SQL console contents by default

SAP HANA Database Explorer, Global Preferences

Schemas folder in the catalog browser (New)

Database’s objects are grouped according to their object type. With the search filter you can  search for objects per schema.

SAP HANA Database Explorer, Catalog Browser

Connection Settings (New)

View connection settings button in the SQL console

SAP HANA Database Explorer, Connection Settings

For the documentation, see

Documentation

New features and known issues are documented in

For all SAP HANA cockpit documentation, see

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

 

Be the first to leave a comment
You must be Logged on to comment or reply to a post.