# SAP HANA Alert Management

Effective alert management is essential for maintaining the stability, performance, and overall health of an SAP HANA system. HANA Alert Management helps administrators stay informed through timely alerts, enabling efficient handling of system health via proactive monitoring and defined threshold settings.

HANA alerts are triggered at various priority levels based on the severity of issues. SAP HANA’s internal monitoring infrastructure continuously gathers and evaluates data on system status, performance, and resource usage. Regular checks on system tables and views are conducted, with alerts generated when specific thresholds are exceeded. For instance, if 90% of disk space is used, a low-priority alert is issued; at 98% usage, a high-priority alert is triggered.

Alerts are categorized by severity to help administrators prioritize their responses. The scale ranges from 1 to 4, with 1 being informational and 4 being critical.

It is important to have a well-defined alert management strategy to ensure alerts are handled effectively and that critical issues are addressed promptly. Proper configuration and management of these alerts enable the maintenance of optimal system performance.

### HANA Alert Exclusion

HANA Alerts can be excluded by creating alert configurations or thresholds to prevent specific alerts from being triggered. Alternatively, administrators can use the SAP HANA Cockpit or SAP HANA Studio to manually suppress alerts during maintenance or for known conditions, reducing false alarms during these periods. This allows for continued monitoring of critical alerts while excluding unnecessary or low-priority HANA alert notifications.

IT-Conductor provides a simple alternative for managing HANA alerts using the HANA Alert Retriever, Threshold Override, and RegEx (Regular Expression).

### Exclude HANA Alerts Using IT-Conductor HANA Alert Retriever <a href="#exclusion-using-it-conductor-hana-alert-retriever" id="exclusion-using-it-conductor-hana-alert-retriever"></a>

This method prevents IT-Conductor from retrieving specific HANA alerts based on the provided Alert ID. The excluded alert is neither displayed on the monitoring chart nor triggers notifications.

{% hint style="info" %}
**Note:** This exclusion is only effective for one HANA system.
{% endhint %}

1. Navigate to **Dashboards** **→** **Default**. Locate the **Alerts** panel and select the HANA alert you want to exclude.

<figure><img src="https://377464071-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXhp08OmU8050PePmMgDt%2Fuploads%2FJbgaANQWoMyKumuSTsPn%2Fitconductor-default-dashboard-alerts.png?alt=media&#x26;token=7d8044fa-fb05-4a03-a327-dd40b82118ef" alt=""><figcaption><p>Figure 1: Default Dashboard in IT-Conductor</p></figcaption></figure>

Alternatively, the **Alerts** page can be accessed by navigating to **Management → Monitoring → Alerts**.

2. Take note of the **Alert ID** (e.g., 106).

<figure><img src="https://377464071-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXhp08OmU8050PePmMgDt%2Fuploads%2FsYTMHdwOIjuFBvGkMFfa%2Fhana-alert-details-page.png?alt=media&#x26;token=f222e75b-6bea-4f67-a5e8-7f43dd743cb0" alt=""><figcaption><p>Figure 2: HANA Alert Details Page</p></figcaption></figure>

3. Navigate to the relevant HANA system in the Service Grid and click **Retrievers**.

<figure><img src="https://377464071-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXhp08OmU8050PePmMgDt%2Fuploads%2F2WUQXpIdYdAyeyaMH11r%2Fhana-system-grid.png?alt=media&#x26;token=9f79ad82-70d1-4b0d-85cb-8a5dc4923f6c" alt=""><figcaption><p>Figure 3: HANA System View in Service Grid</p></figcaption></figure>

4. Click **Alert Retriever** from the list.

<figure><img src="https://377464071-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXhp08OmU8050PePmMgDt%2Fuploads%2FMCFU1hLQamS4JyJ7JL2x%2Fhana-retrievers.png?alt=media&#x26;token=04edb92a-99c4-46d5-81c6-c1894a5da39e" alt=""><figcaption><p>Figure 4: HANA Retrievers</p></figcaption></figure>

5. Under the **Exclusion Criteria** section, click **Add New Row** <img src="https://377464071-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXhp08OmU8050PePmMgDt%2Fuploads%2Fgit-blob-7f816831472c5030e6dfbcb513035d87da645a67%2Fadd.png?alt=media" alt="" data-size="line">.
6. In the **Attribute** dropdown, select `HANAAlert.ALERT_ID`.
7. Choose the appropriate operator (e.g., **=** for a single value or **in** for multiple values).
8. Enter the Alert ID (e.g., 106) in the **Value** field.
9. Click **Create** <img src="https://377464071-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXhp08OmU8050PePmMgDt%2Fuploads%2Fgit-blob-7f816831472c5030e6dfbcb513035d87da645a67%2Fadd.png?alt=media" alt="" data-size="line"> to add the entry, then click **Save** <img src="https://377464071-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXhp08OmU8050PePmMgDt%2Fuploads%2FKGMKWbeytvsPZu8WBj0y%2Fsave-icon.gif?alt=media&#x26;token=2a566496-96e3-4381-b49d-5ec8d6972f88" alt="" data-size="line"> to apply the changes.

You can later edit this row using **Modify Row** <img src="https://377464071-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXhp08OmU8050PePmMgDt%2Fuploads%2FH0QMQdYJ77TOpnkRbCIt%2Fmodify-icon.png?alt=media&#x26;token=153341d5-128e-4ab4-b3e5-bfc31cbc6f7f" alt="" data-size="line">.

<figure><img src="https://377464071-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXhp08OmU8050PePmMgDt%2Fuploads%2F7TCWyC5eD06I6VQfmrZ2%2Fmodify-hana-alert-retriever.png?alt=media&#x26;token=ca224513-20a3-4e8e-a047-a78433baea9d" alt=""><figcaption><p>Figure 5: Modify HANA Alert Retriever</p></figcaption></figure>

### Exclude HANA Alerts Using IT-Conductor HANA Alert Threshold Override <a href="#exclusion-using-it-conductor-hana-alert-threshold-override" id="exclusion-using-it-conductor-hana-alert-threshold-override"></a>

This second approach allows for the collection and display of HANA alerts on the monitoring chart, but it doesn't trigger notifications. Unlike the first method, this one ensures data is still captured and visible for monitoring trends and severity.

This exclusion method offers more flexibility. It can be applied to individual HANA systems, groups of systems, specific environments (DEV, QA, or PROD), and individual organizations within your tenant. It can also be applied globally across all systems in your environment. This granular control allows you to tailor alert exclusion to your specific needs across your entire environment.

1. Click **All Alerts** <img src="https://377464071-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXhp08OmU8050PePmMgDt%2Fuploads%2FN4lP9zXl8b0E5W0hFVVI%2Fall-alerts-icon.png?alt=media&#x26;token=b6bbc9f0-95d8-4341-9425-8c0415504f81" alt="" data-size="line"> to open the **Object** **menu**, then click **Overrides**.

<figure><img src="https://377464071-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXhp08OmU8050PePmMgDt%2Fuploads%2FGyavp1e9DZrovbIIo5St%2Fnavigate-to-overrides.png?alt=media&#x26;token=28f8de81-cb21-48a7-b703-9da00169ca2b" alt=""><figcaption><p>Figure 6: Overrides Menu Option</p></figcaption></figure>

2. Click the override name (e.g., **HANA: High Priority Alerts**).

<figure><img src="https://377464071-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXhp08OmU8050PePmMgDt%2Fuploads%2FvGny4HQ6tDM0yCzdExIg%2Fhana-alert-override.png?alt=media&#x26;token=a2a65564-1d63-43f5-8639-72a69791448d" alt=""><figcaption><p>Figure 7: HANA Alert Override</p></figcaption></figure>

3. In the **Object Criteria** section, click the **Add New Row** button.
4. Select `HANAAlert.ALERT_ID` from the **Attribute Name** dropdown.
5. Choose the appropriate operator (e.g., **=** for a single value or **in** for multiple values).
6. Enter the Alert ID (e.g., 106) in the **Value** field.
7. Click **Create** <img src="https://377464071-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXhp08OmU8050PePmMgDt%2Fuploads%2Fgit-blob-7f816831472c5030e6dfbcb513035d87da645a67%2Fadd.png?alt=media" alt="" data-size="line"> to add the entry, then click **Save** <img src="https://377464071-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXhp08OmU8050PePmMgDt%2Fuploads%2FKGMKWbeytvsPZu8WBj0y%2Fsave-icon.gif?alt=media&#x26;token=2a566496-96e3-4381-b49d-5ec8d6972f88" alt="" data-size="line"> to apply the changes.

<figure><img src="https://377464071-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXhp08OmU8050PePmMgDt%2Fuploads%2Frdz6XLQ5wDqkMXGg1PRN%2Fhana-override-object-criteria.png?alt=media&#x26;token=5ae08cb4-28aa-44e1-8c39-007fabde2b53" alt=""><figcaption><p>Figure 8: HANA Override Object Criteria</p></figcaption></figure>

### Exclude HANA Alerts Using RegEx <a href="#using-regex-for-hana-alerts-exclusion" id="using-regex-for-hana-alerts-exclusion"></a>

Regular expressions, which are powerful tools for pattern matching, can be used to exclude HANA alerts in either the HANA Alert Retriever or the Threshold Override Rule. This is particularly useful when you need to match alerts based on specific patterns or criteria.

In the example below, the steps are demonstrated using the Threshold Override Object Criteria; however, similar steps can be applied when using the HANA Alert Retriever method.

1. Add a new rule to the **Object Criteria** by clicking **New Row** <img src="https://377464071-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXhp08OmU8050PePmMgDt%2Fuploads%2Fgit-blob-7f816831472c5030e6dfbcb513035d87da645a67%2Fadd.png?alt=media" alt="" data-size="line">.
2. Select the appropriate attribute (e.g., `HANAAlert.ALERT_NAME`).
3. Choose the RegEx operator (e.g., `!regex`).
4. Enter the value that matches the HANA alert pattern you want to exclude.
5. Click **Create** <img src="https://377464071-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXhp08OmU8050PePmMgDt%2Fuploads%2Fgit-blob-7f816831472c5030e6dfbcb513035d87da645a67%2Fadd.png?alt=media" alt="" data-size="line"> to add the entry, then click **Save** <img src="https://377464071-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXhp08OmU8050PePmMgDt%2Fuploads%2FKGMKWbeytvsPZu8WBj0y%2Fsave-icon.gif?alt=media&#x26;token=2a566496-96e3-4381-b49d-5ec8d6972f88" alt="" data-size="line"> to apply the changes.

<figure><img src="https://377464071-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXhp08OmU8050PePmMgDt%2Fuploads%2F6yVLavKsKuIVdhjMcQpU%2Fhana-override-object-criteria-regex.png?alt=media&#x26;token=d7d2d368-7b20-4706-9844-65b37b9d7ed4" alt=""><figcaption><p>Figure 9: HANA Override Object Criteria Using RegEx</p></figcaption></figure>

{% hint style="info" %}
**Note:** Regular reviews of alert configurations are recommended to determine when to revert to previous settings or disable unnecessary alerts. This helps keep the system organized and prevents excessive notifications or noise.
{% endhint %}

### Video

{% embed url="<https://www.youtube.com/watch?v=9xWZcFVpkI0>" %}
