Fired when a SAP HANA system hasn't reported a PING alive

Shamil Ahmed 1 Reputation point
2022-06-13T01:44:17.743+00:00

Hello Team,
We have setup the Azure Monitor for SAP Solution for HANA DB with HANA Provider.
Here the problem is that we get the alert for HANA DB unavailability even though HANA DB is up and running fine.
AMS is not able to PING to the server to get the DB status.
Can please assist to fix it.
Alert : Fired when a SAP HANA system hasn't reported a PING alive for the last 20 mins.
let StartTime=now(); SapHana_SystemAvailability_CL
| where PROVIDER_INSTANCE_s == 'xxxxxxxx'
| where EVENT_NAME_s == 'PING' |top 1 by TimeGenerated desc
| extend AggregateValue = iff(StartTime - TimeGenerated > 20min, 1, 0)
| summarize AggregatedValue = max(AggregateValue) by bin(TimeGenerated, 5m)

Azure Monitor
Azure Monitor
An Azure service that is used to collect, analyze, and act on telemetry data from Azure and on-premises environments.
2,971 questions
SAP HANA on Azure Large Instances
SAP HANA on Azure Large Instances
Microsoft branding terminology for an Azure offer to run HANA instances on SAP HANA hardware deployed in Large Instance stamps in different Azure regions.
120 questions
{count} votes