Skip to Content
Product Information
Author's profile photo Jose Ramos

What’s New in SAP HANA Cockpit SP 13 + Webcast

SAP HANA cockpit SP 13 is now available for download in the SAP Software Download Center.  In this new release, SAP HANA database administrators can take advantage of new functionality in the areas of administration and monitoring, performance management tools, security, backup and recovery, and the SAP HANA database explorer.

A 90-minute webcast and live demonstration of the new features is scheduled for Tuesday June 22nd, 2021 at 11:00 AM EDT / 5:00 PM CEST – to attend this session, please click here to register.

Here is a summary of the new functionality:

Administration and Monitoring

  • CPU, memory, and network information are now displayed in the Database Information page.
  • You can set individual statement limits and total aggregated statement limits for global limits in the Workload Class application.
  • Usability improvements to the Table Group Advisor and Table Group Advisor Preview apps.
  • Monitor persistent memory and TMPFS usage
  • In the Memory Paging Monitor, you can now filter tables based on load unit, review more information on the amount of data stored in delta memory, and sort tables according to the delta memory.

Performance Management Tools

  • Notification when a replay stopped processing, allowing you to investigate why that happened.
  • You can now select a customized time range to replay.
  • In the SQL Plan application, you can now see a detail page of a query with a historical chart of abstract SQL plans and choose to enable them.
  • Plan Trace is now publicly available so that any user can access traced queries without special privileges.

Security

  • The Role Assignment application now shows you all the roles a user has been assigned, not only those assigned directly to the user but also those assigned indirectly through inheritance.
  • You can now open the Role Assignment application directly in the Users application.
  • In the Privilege Assignment app, when assigning object privileges to a user or role, you can now select multiple objects of the same type and assign the same privileges to all selected objects.
  • When creating audit policies, you can now specify a retention period when you choose Database Table with Retention as the audit trail target.
  • If the audit trail is Database table, it is now possible to download audit entries to a CSV file.

Backup and Recovery

  • You now have the option to create compressed backups.
  • By analyzing available backups and the log area, it is possible to verify that SAP HANA can be recovered to a specific point in time.
  • You have the option to recover an SAP HANA tenant database through its system database, using a complete data backup only.

SAP HANA Database Explorer

  • You can now use a filter to quickly find a database and can create database groups to better organize databases.
  • Multiple usability enhancements have been made to enhance working with, finding, and viewing diagnostic files.
  • ESRI shapefiles are now a supported option in the data import wizard.
  • In the messages tab of the SQL Console, resource consumption metrics (peak memory consumed, CPU time, prepare time, and execute time) are displayed.

For more information about the SAP HANA cockpit, please consult the SAP HANA cockpit documentation in the SAP HANA Help Portal.  Enjoy this new version of the SAP HANA cockpit in your day-to-day SAP HANA administration and monitoring activities!

Assigned tags

      2 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Eric Bickers
      Eric Bickers

      On the backup compression that is now available, is that built into the HANA Cockpit only? I assume it's not natively built into the database. If I compress a backup can I then only restore that backup from the Cockpit? Or can I restore it using either HDBSQL or HANA Studio?

      Also, just checking out some of these new features, not seeing where I can turn on backup compression in SP13 patch 4 like I could in SP12 patch 18 under the system wide backup configuration. The recoverability checker seems to work well though.

      Thanks

      Eric

      Author's profile photo Jose Ramos
      Jose Ramos
      Blog Post Author

      Hi Eric,

      You perform a compression via SQL as there's an extension to the SQL statement for compression.  It is completely done in the engine and the HANA cockpit simply extends the SQL. It is also possible to compress a single backup and then to restore it.

      I hope that helps!

      BR,
      José