Show TOC

DBA Cockpit for SAP HANA (New and Changed)Locate this document in the navigation structure

Use

Changes to the User Interface

The functions have been regrouped to improve logical consistency. So, several familiar functions are now to be found in different locations:

  • The Disks section has been merged with the Volumes section. Go to Start of the navigation path Configuration Next navigation step Volumes End of the navigation path.

  • The Trace Configuration section, which was previously in Current Status , can now be found in the Configuration section.

  • Query Cache can now be found in Start of the navigation path Performance Next navigation step SQL Plan Cache End of the navigation path

Execution Trace (New)

The new Execution Trace is similar to the Explain function. Whereas with Explain , the statement is not executed, with Execution Trace , the statement is really executed and analyzed at the same time. The trace can be downloaded.

Choose Start of the navigation path Performance Next navigation step Expensive Statements End of the navigation path.

Choose Start of the navigation path Performance Next navigation step SQL Plan Cache End of the navigation path.

Choose Start of the navigation path Diagnostics Next navigation step Execution Trace End of the navigation path.

In addition, this feature is also available as part of transaction ST05.

LiveCache Support (New)

LiveCache technology is now supported.

Choose Start of the navigation path Performance Next navigation step OMS Versions End of the navigation path.

Choose Start of the navigation path Performance Next navigation step Procedure Statistics End of the navigation path.

Choose Start of the navigation path Diagnostics Next navigation step Heap Usage End of the navigation path.

Choose Start of the navigation path Diagnostics Next navigation step Locks End of the navigation path.

Self-Monitoring of DBA Cockpit (New)

If there are issues with the setup and infrastructure of the DBA Cockpit, error messages are displayed on the relevant screens.

Information about Table Partitions (New)

You can display an overview of all the partitions for a particular table. It is now possible to see which partitions a table is stored on.

Choose Start of the navigation path Diagnostics Next navigation step Tables/Views End of the navigation path.

Procedures (New)

You can now display all the database procedures. You can search or drill down.

Choose Start of the navigation path Diagnostics Next navigation step Procedures End of the navigation path.

Scheduling Data Backups with External Backup Tools (New)

In the DBA Planning Calendar it is now possible to schedule data backups with the Backint for SAP HANA interface.

Displaying the SAP HANA License Key (New)

Choose Start of the navigation path System Information Next navigation step License End of the navigation path to view details about your SAP HANA license key. You can also install a new license key here.

Additional System Information (New)

Choose Start of the navigation path System Information Next navigation step Others End of the navigation path to view the following system information: Component memory usage, connection attempts and status, database information, HANA usage, lock waiting history, merge statistics, open transactions, overall workload, schema size of loaded tables, session context, sessions, size of tables on disk, used memory by tables, and column tables memory usage.

More Information

Database Administration for SAP HANA on Start of the navigation path http://help.sap.com Next navigation step SAP NetWeaver Library: Function-Oriented View End of the navigation path