Goal of this blog post
In this blog, we will create 2 panels displaying analytics for Real User Monitoring data managed by SAP Cloud ALM with the ALM Grafana plugin.
Pre-requisites
- You have created a service key to your SAP Cloud ALM tenants (check this blog).
- You should configure a Grafana data source connected to your SAP Cloud ALM tenant.
- You have configured at least one project in your SAP Cloud ALM tenant. (check the SAP support portal)
ALM Real User Monitoring Data Provider
The SAP Cloud ALM Real User Monitoring data provider supports the following dimensions:
| Dimensions | Description | Filter |
| serviceType | Service type | yes |
| serviceId | Service id | yes |
| serviceName | Service name | |
| requestType | Type of requests | yes |
| request | name of the request | yes |
| responseTime | response Time (Measures) | |
| users | number of users (Measures) | |
| requests | number of requests (Measures) | |
| okStatus | number of requests with ok status (Measures) | |
| warningStatus | number of requests with warning status (Measures) | |
| criticalStatus | number of requests with critical status (Measures) |
Query
From your Grafana instance, create a panel and add the following query:
- Select your SAP Cloud ALM “Data source”.
- Select the “Time Series” format.
- Select the data provider: “ALM Real User Monitoring”
- Select the filters:
- serviceType
- serviceId
- Select the following dimensions:
- requestType
- Select the following dimensions:
- responseTime
Add a configuration to select the 30 minutes resolutions:
Visualisation
Select the “Time Series” visualisation
Result
The result will show a time series chart with the response time per requests type for the selected services.
Query
From your Grafana instance, add the following queries:
query 1:
- Select your SAP Cloud ALM “Data source”.
- Select the “Time Series” format.
- Select the data provider: “ALM Real User Monitoring”
- Select the filters:
- serviceType,
- serviceId
- Select the following dimensions:
- okStatus
query 2:
- Select your SAP Cloud ALM “Data source”.
- Select the “Time Series” format.
- Select the data provider: “ALM Real User Monitoring”
- Select the filters:
- serviceType,
- serviceId
- Select the following dimensions:
- requests
Add a configuration to select the 5 minutes resolution:
Add a transformation “Add field from calculation” to compute the percentage of requests with an ok status:
Visualisation
Select the “Status History” visualisation
Result
The result will show a status history chart with the percentage of requests with good performance for your service or system.
