SAP ASE Database Monitoring

Background

IT-Conductor SAP ASE Monitoring helps to keep track of the availability, alerts, and performance metrics such as the spaces and engines of ASE database servers. Alerts and notifications are generated automatically depending on the configured thresholds. Performance graphs and report logs are available in an instant which makes it easier to monitor the system in real-time. You can also view the historical data depending on the selected time range.

Features

Availability

Availability Monitoring is essential to determine whether an application or a particular service is running.

Figure 1: SAP ASE Server Availability Feature
Figure 2: SAP ASE Server Availability Sample Graph

Error Logs

Any error logs in the ASE System are being captured and are time-synchronized. It provides a list of events/errors to look over.

Figure 3: SAP ASE Server Error Log Feature
Figure 4: SAP ASE Server Error Log Graph and Sample Logs

Space Usage

It continually monitors the disk space consumed by the system processes as well as the free space.

Figure 5: SAP ASE Server Space Usage Feature
Figure 6: SAP ASE Server Used Space and Free Space Sample Graphs

Instances

It monitors data cache, including hit ratio, which is critical in improving application performance, especially when having multiple CPU systems or clusters.

Figure 7: SAP ASE Server Instances Feature

Engines

Track and display the current condition of the database and monitor the critical metrics of the system, such as status, percent i/o busy, etc.

Figure 8: SAP ASE Server Engines Feature and Percent I/O Busy Sample Graph

SQL Jobs

Another feature in monitoring the SAP ASE Database is to check/run the SQL Jobs.

Figure 9: SQL Job Feature

The page will show the list of active SQL jobs. By clicking on the name of the job, it will show the important details, including the execution logs that automatically report the output.

Figure 10: SAP ASE SQL Jobs

By clicking the "Restart Activity" icon, you have the option to reprocess the job.

Figure 11: Reprocessing SQL Jobs

By clicking on the "Log" icon, the page will show the individual jobs where you can check the logs of the instances.

Figure 12: Checking SQL Jobs
Figure 13: Sample List of Individual Jobs

Video

Last updated

#660:

Change request updated