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


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

 



 

For the 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

 

Installation and Update


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

Video Tutorial


https://youtu.be/wFAZiue_FFM

 

Administration and Monitoring


Tutorial Video


https://youtu.be/4wlRqxH3d7Q

https://youtu.be/j4hJc97tvh4

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

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

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

SAP HANA Database Explorer


Tutorial Video


https://youtu.be/-zO8hWjcWl0

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

User Management and Security Administration


Tutorial Video


https://youtu.be/08WncLETLGA

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

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

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

Performance Monitoring and Analysis


Tutorial Video


https://youtu.be/Om-6-mmNDlU

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

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

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

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

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

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

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

 

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

 

6 Comments