SAP HANA Cockpit 2.0 SP 08 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 08, released October 2018.

For the full SAP HANA cockpit playlist on YouTube, see

• SAP HANA Cockpit 2.0 – What’s New?

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

• What’s New – SAP HANA cockpit 2.0  – by the SAP HANA Academy

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

• Getting Started with SAP HANA Cockpit 2.0 – by the SAP HANA Academy

Installation and Update

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

Video Tutorial

Administration and Monitoring

Tutorial Video

Navigation Enhancements

Several enhancements have been made to make it easier to work your way around in Cockpit:

• Lateral navigation
• Recent Activity and Frequently Used in the Me area
• Navigate directly to a targeted resource from Cockpit Manager to Cockpit

Password Reset

Change password for Cockpit users is now self-service through Me area > Settings. Previously only a cockpit user administrator could change passwords.

For the documentation, see

• Personalizing the SAP HANA Cockpit

Global Collection Settings Override

For APCA (availability, performance, capacity, and alerts) collections, use the Cockpit Manager to manage global settings, or edit a registered resource and override the global settings for that particular resource.

For the documentation, see

• Setting Data Collection
• Override Data Collection for a Resource

Workload Management

Configure a query timeout and/or choose between relative or absolute values for the statement thread and statement memory limit, and when importing workload classes, a message dialog keeps you informed on the number that have imported, skipped or overwritten.

For the documentation, see

• Managing Workload Classes in SAP HANA Cockpit

SAP HANA Database Explorer

Tutorial Video

Autosave

The content of the SQL console is saved 30 seconds after your last keystroke, when you use the Run menu, your console is connected to a database, or when you close your console or browser. All saved SQL consoles are re-opened with their content (but not result sets) when you next open database explorer.

Report Code Coverage

The Analyze menu of the SQL console now includes the Report Code Coverage option, which gathers position (line, column, start, end) coverage information for SQLScript procedures, functions, and anonymous blocks.

The Hide/Show Columns icon on the toolbar allows you to specify which type of data to download: hidden columns, filtered rows, or both.

For the documentation, see

• SAP HANA Database Explorer

User Management and Security Administration

Tutorial Video

Auditing

XS Advanced auditing logs are included in the audit table viewer and step-by-step guidance (“wizard”) has been added for creating audit policies.

For the documentation, see

• Audit Trail View
• Create an Audit Policy

User Management

Last log on time and deactivated since are displayed in User Management.

JWT identify provider management (create, update, delete) is now available as an app. Previously, only the SQL interface was provided.

Navigation between role assignment and role definition has been simplified.

For HDI roles, you can choose between the HDI Container API procedure (requires EXECUTE on the GRANT_CONTAINER_SCHEMA_ROLES procedure in the container’s API schema) or using SQL (role admin).

For the documentation, see

• Assign Roles to a Database User
• Add a JWT Identity Provider in SAP HANA Cockpit
• Database User Details

Encryption

The encryption algorithm used in now displayed in the app.

Backup and Recovery

Scheduling Backup

Schedule tenant backups from the system database (system-wide backups):

For the documentation, see

• Schedule Backups

Performance Monitoring and Analysis

Tutorial Video

Capture and Replay

On the Capture Configuration page, turn on the Abstract SQL Plan to capture abstract SQL plans on the source system and to export them to the file system, or turn on the SQL Input Parameters option to see the parameter values in the replay report.

From the Replay Management page:

• Open the Replay List tab to see the status of the started replays with more information under Details
• Stop a started replay using the Stop button in the Replay Status column.
• Start the preprocess from the Preprocess Status column in the Replay Candidate tab.

On the Replay Report:

• Filter the slower statements by elapsed time, CPU time, and execution time using the drop-down button in the Slower Statement section.
• Sort the displayed statements by clicking directly the column header.

For the documentation, see

• Capturing and Replaying Workloads

Performance Monitoring

Monitor Statements consolidates Statement Monitor, SQL Plan Cache, and Expensive Trace Monitor from previous releases into a single view.

Configure the SQL plan cache size or clear all plan cache.

Save SQL plans within the SAP HANA database as PLV files under SAP HANA trace folder, and download the files to your hard drive.

Choose from predefined KPI preset views and define custom views on the Performance Monitor page.

Perform remote imports of nameserver history trace.

For the documentation, see

• Monitoring and Analyzing with the Performance Monitor
• Monitoring and Analyzing Statements
• Monitor and Analyze Statements with SQL Plan Cache

SQL Analyzer

View details on the query compilation process in the Compilation Summary section of the SQL Analyzer with Recommendations on how to improve the SQL performance provided.

Delete PLV files from the SAP HANA trace folder on the Manage Saved Plans page; update the  location for abstract SQL plans; migrate abstract SQL plans to the latest SAP HANA database release:

For the documentation, see

• Analyzing SQL and Saving Plans
• Manage Saved Plans
• Analyzing Statement Performance
• Analyze Statement Performance
• Managing Plan Stability

Workload Analyzer

To access Workload Analyzer, select the CPU Usage, Disk Usage, Memory Usage, or SQL Statements tiles from Overview or through the Capture Management page for analysis of captured workloads as the dedicated tile has been removed from the Overview page.

For the documentation, see

• Analyzing Workloads

Memory Analysis

Filter the display of tables using Chart Value, Show Top, Filter by Schema(s), and Time Range filter options.

For the documentation, see

• Analyze Memory Statistics

Administration and Monitoring (Other)

Access to SAP HANA Add-On Capabilities

New tiles for SAP HANA options on the System Overview page (Accelerator for ASE, Dynamic Tiering, Remote Data Sync, Smart Data Access, and Streaming Analytics).

Table Distribution and Table Placement Editor

Specify rules for where new tables/partitions are placed or where tables/partitions are moved during a redistribution with the table placement editor.

Additionally, several enhancements have been made to table distribution. For the documentation, see

• Managing Table Redistribution in SAP HANA Cockpit
• Add or Edit Table Placement Rules

Log Viewing

Find and read entries in the cockpit’s operational logs and view the logs to troubleshoot problems like missing monitoring data on cockpit pages, resource registration failure, and connection timeouts.

For the documentation, see

• View Logs to Troubleshoot the Cockpit

Documentation

New features and known issues are documented in

• SAP HANA Cockpit SP 08 Features – What’s New in the SAP HANA Cockpit 2.0
• 2679059 – SAP HANA Cockpit 2.0 SP 08 – SAP Note

For all SAP HANA cockpit documentation, see

• SAP HANA Cockpit – SAP Help Portal

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
• Facebook facebook.com/saphanaacademy