Monitoring SAP HANA Cloud Instances Using Joule

Objective

After completing this lesson, you will be able to monitor SAP HANA Cloud Instances Using Joule.

Using Joule to Analyze Database Alerts

Using Joule to Analyze Database Alerts

SAP HANA Cloud will produce database alerts when threshold values are exceeded, or when the database needs your attention. As a database administrator it is your task to analyze these database alerts, which can be time consuming. To speedup the database alert analysis you can use Joule. The following prompts will instruct Joule to perform a database alert analysis.

Code Snippet
1
Open Alerts

Will open the SAP HANA Cloud Central - Alerts application and display the current database alerts.

Code Snippet
1
Show Alerts Overview

Will trigger Joule to display an Alert Overview, from this Alert Overview you can select an alert for further troubleshooting. Joule makes an analysis and provides a possible solution. Joule also presents you with the link to the Show Resource Usage app. You can use Show Resource Usage app to deeper investigate the memory, compute, storage, and threads usage.

Demonstration: Analyze Database Alerts

The following demonstration shows how you can use Joule to help you with analyzing database alerts.

Summary

This lesson demonstrates how Joule can help database administrators manage daily tasks in SAP HANA Cloud Central by automating user menu settings changes. Key examples include:

  • Changing the color theme
  • Changing Preferred Region
  • Activating App Notifications
  • Starting database administration tools
  • Analyzing database alerts

Each task is performed using specific prompts, and Joule responds with a link to execute the changes, thereby reducing manual effort and minimizing errors.