> For the complete documentation index, see [llms.txt](https://docs.itconductor.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.itconductor.com/~/changes/j1RdUn49WBcajmJEmXUf/users-guide/monitoring/database-monitoring/itc-sap-ase-database-monitoring.md).

# SAP ASE Database Monitoring

### **Background** <a href="#background" id="background"></a>

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** <a href="#features" id="features"></a>

#### **Availability** <a href="#availability" id="availability"></a>

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

![Figure 1: SAP ASE Server Availability Feature](/files/QQpvFjgyX8pNhQsv3lpe)

![Figure 2: SAP ASE Server Availability Sample Graph](/files/faynzykvpbqG9xGcN5Ai)

#### **Error Logs** <a href="#error-logs" id="error-logs"></a>

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](/files/e183SMdtGNbnrXTfXZrH)

![Figure 4: SAP ASE Server Error Log Graph and Sample Logs](/files/qyHZwyuPV4t6rJ8m03hu)

#### **Space Usage** <a href="#space-usage" id="space-usage"></a>

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](/files/Sttt3qYjNqFWGfdFvxcm)

![Figure 6: SAP ASE Server Used Space and Free Space Sample Graphs](/files/kli2g8g6ebykdhWOgbPR)

#### **Instances** <a href="#instances" id="instances"></a>

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](/files/NwPoh8dgdyMVxKJATFmC)

#### **Engines** <a href="#engines" id="engines"></a>

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](/files/fuEXwnlucSycnl9ouslY)

#### **SQL Jobs** <a href="#sql-jobs" id="sql-jobs"></a>

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

![Figure 9: SQL Job Feature](/files/ao8rF86ziGQNaIscjNtW)

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](/files/RndLtDoO90outxYDGXln)

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

![Figure 11: Reprocessing SQL Jobs](/files/7l5DhDVivA31lkTLw5WA)

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](/files/UmZTm1mPLe0B4PpzQ2S5)

![Figure 13: Sample List of Individual Jobs](/files/G8CrDlfpZxRvjPvAXo9O)

### Video

{% embed url="<https://vimeo.com/252786778>" %}

### Related Articles

* [**SAP ASE Server**](/~/changes/j1RdUn49WBcajmJEmXUf/start-here/systems-setup/sap-ase-server.md)


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.itconductor.com/~/changes/j1RdUn49WBcajmJEmXUf/users-guide/monitoring/database-monitoring/itc-sap-ase-database-monitoring.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
