Skip to content

SAP HANA Cockpit 2.0 SP 05 What’s New

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

 

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 

 

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. 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 accesible 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 make 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 on 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 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

 

No comments yet

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s

%d bloggers like this: