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.
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.
There are following sections in Diagnostics node:
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.
This shows execution plan for statements like SELECT, INSERT, UPDATE and DELETE
It can be used to execute SQL statements
Used to display a table or a view or a monitoring view.
Used for HANA databases that are offline (cannot be reached by SQL)
Used for activating, deactivating, analyzing trace
Monitor: System Information
Provides detailed information about open connections
This section displays open transactions
Provides information about statistics such as IO statistics
Provides information about caches created by SAP HANA database.
Provides information about query cache which is where SQL statements are executed
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.
Provides an overview of statements that were executed.