How to monitor SAP HANA using DBACOCKPIT

After completing this lesson, you will be able to:
• Explain how to monitor SAP HANA using DBACOCKPIT

In the BW modeling perspective, open SAP GUI and go to transaction DBACOCKPIT

Monitor: Current Status

The current status provides the overview of statuses of most important database resources.

You can see the information about:

• The status of available disk space and physical memory
• The status of services
• The time at which database was started
• Current alerts
• Memory and CPU consumption from the perspective of HANA database and operating system
• Disk consumption from the perspective of HANA database and operating system

The same information is shown in the Overview tab in SAP HANA studio Administration console.

By clicking on the links, you can get deeper insights into the respective statuses and services.

Monitor: Performance

You can analyze performance data of your database system using the Performance Warehouse. As a prerequisite an SAP Solution Manager system with Solution Manager Diagnostics (SMD) enabled is required.

The performance reports can be seen in chart or in table form.

Monitor: Diagnostics

There are following sections in Diagnostics node:

Audit log:

Audit log records all the changes made to the database.

Missing tables and indexes:

It shows differences between database in SAP system and ABAP dictionary.

Explain:

This shows execution plan for statements like SELECT, INSERT, UPDATE and DELETE

SQL Editor:

It can be used to execute SQL statements

Tables/Views

Used to display a table or a view or a monitoring view.

Diagnosis Files

Used for HANA databases that are offline (cannot be reached by SQL)

Execution Trace

Used for activating, deactivating, analyzing trace

Monitor: System Information

Connections:

Provides detailed information about open connections

Transactions:

This section displays open transactions

Connection Statistics

Provides information about statistics such as IO statistics

Caches

Provides information about caches created by SAP HANA database.

Query cache

Provides information about query cache which is where SQL statements are executed

Large tables

Provides information about largest tables in SAP HANA system. You can analyze system performance by seeing fastest growing tables, table size in main memory and delta size.

SQL Workload

Provides an overview of statements that were executed.