Customer Relationship Management Blogs by SAP
Stay up-to-date on the latest developments and product news about intelligent customer experience and CRM technologies through blog posts from SAP experts.
cancel
Showing results for 
Search instead for 
Did you mean: 
YannickRobin
Product and Topic Expert
Product and Topic Expert

Introduction


On production environment, you can check primary database DTU size and monitor usage with standard Dynatrace dashboards.

Here is an example from SAP - Infra Usage dashboard.


This dashboard does not show the read-only replica database that is available with any production environment.

In this article, we will explain how to create a dedicated dashboard for this.

SAP - Read replica db dashboard


Manually create the dashboard


Here are the instructions to create a new dashboard to monitor read replica database.

  • Connect to Dynatrace on the lower environment

  • Go to Dashboard > Create Dashboard

  • Enter Dashboard Name: "SAP - Read replica DB"

  • Add 3 graphs:

    • "Azure DTU"

    • "Redo Queue Size (KB)"

    • "Replica lag"







  • For DTU usage, add the metric ReadOnlyAverageAzureDtu, click Run query and click Saves changes to dashboard





  • Do the same for ReadOnlyRedoQueueSizeInKB and ReadOnlySecondaryReplicaLag


Here is the result:



Import the dashboard


If you want to quickly create the dashboard, you can also import the following JSON file into Dynatrace (Go to Dashboard and click Import dashboard button).
{
"metadata": {
"configurationVersions": [
7
],
"clusterVersion": "1.276.214.20231011-173514"
},
"id": "e2c9e980-4182-4d16-80e1-cd3663e11c4f",
"dashboardMetadata": {
"name": "SAP – Read Replica DB",
"shared": false,
"owner": "i303937",
"hasConsistentColors": false
},
"tiles": [
{
"name": "Average DTU",
"tileType": "DATA_EXPLORER",
"configured": true,
"bounds": {
"top": 0,
"left": 0,
"width": 836,
"height": 228
},
"tileFilter": {},
"isAutoRefreshDisabled": false,
"customName": "Data explorer results",
"queries": [
{
"id": "A",
"metric": "ext:custom.jmx.AzureDatabases.metric_ReadOnlyAverageAzureDtu",
"spaceAggregation": "AUTO",
"timeAggregation": "DEFAULT",
"splitBy": [],
"sortBy": "DESC",
"sortByDimension": "",
"filterBy": {
"nestedFilters": [],
"criteria": []
},
"limit": 20,
"rate": "NONE",
"enabled": true
}
],
"visualConfig": {
"type": "GRAPH_CHART",
"global": {},
"rules": [
{
"matcher": "A:",
"properties": {
"color": "DEFAULT"
},
"seriesOverrides": []
}
],
"axes": {
"xAxis": {
"displayName": "",
"visible": true
},
"yAxes": [
{
"displayName": "",
"visible": true,
"min": "AUTO",
"max": "AUTO",
"position": "LEFT",
"queryIds": [
"A"
],
"defaultAxis": true
}
]
},
"heatmapSettings": {
"yAxis": "VALUE",
"showLabels": false
},
"singleValueSettings": {
"showTrend": true,
"showSparkLine": true,
"linkTileColorToThreshold": true
},
"thresholds": [
{
"axisTarget": "LEFT",
"rules": [
{
"color": "#7dc540"
},
{
"color": "#f5d30f"
},
{
"color": "#dc172a"
}
],
"visible": true
}
],
"tableSettings": {
"hiddenColumns": []
},
"graphChartSettings": {
"connectNulls": false
},
"honeycombSettings": {
"showHive": true,
"showLegend": true,
"showLabels": false
}
},
"queriesSettings": {
"resolution": ""
},
"metricExpressions": [
"resolution=null&(ext:custom.jmx.AzureDatabases.metric_ReadOnlyAverageAzureDtu:splitBy():sort(value(auto,descending)):limit(20)):limit(100):names"
]
},
{
"name": "Replica lag",
"tileType": "DATA_EXPLORER",
"configured": true,
"bounds": {
"top": 494,
"left": 0,
"width": 836,
"height": 266
},
"tileFilter": {},
"isAutoRefreshDisabled": false,
"customName": "Data explorer results",
"queries": [
{
"id": "A",
"metric": "ext:custom.jmx.AzureDatabases.metric_ReadOnlySecondaryReplicaLag",
"spaceAggregation": "AUTO",
"timeAggregation": "DEFAULT",
"splitBy": [],
"sortBy": "DESC",
"sortByDimension": "",
"filterBy": {
"nestedFilters": [],
"criteria": []
},
"limit": 20,
"rate": "NONE",
"enabled": true
}
],
"visualConfig": {
"type": "GRAPH_CHART",
"global": {},
"rules": [
{
"matcher": "A:",
"properties": {
"color": "DEFAULT"
},
"seriesOverrides": []
}
],
"axes": {
"xAxis": {
"displayName": "",
"visible": true
},
"yAxes": [
{
"displayName": "",
"visible": true,
"min": "AUTO",
"max": "AUTO",
"position": "LEFT",
"queryIds": [
"A"
],
"defaultAxis": true
}
]
},
"heatmapSettings": {
"yAxis": "VALUE",
"showLabels": false
},
"singleValueSettings": {
"showTrend": true,
"showSparkLine": true,
"linkTileColorToThreshold": true
},
"thresholds": [
{
"axisTarget": "LEFT",
"rules": [
{
"color": "#7dc540"
},
{
"color": "#f5d30f"
},
{
"color": "#dc172a"
}
],
"visible": true
}
],
"tableSettings": {
"hiddenColumns": []
},
"graphChartSettings": {
"connectNulls": false
},
"honeycombSettings": {
"showHive": true,
"showLegend": true,
"showLabels": false
}
},
"queriesSettings": {
"resolution": ""
},
"metricExpressions": [
"resolution=null&(ext:custom.jmx.AzureDatabases.metric_ReadOnlySecondaryReplicaLag:splitBy():sort(value(auto,descending)):limit(20)):limit(100):names"
]
},
{
"name": "Redo Queue Size (KB)",
"tileType": "DATA_EXPLORER",
"configured": true,
"bounds": {
"top": 228,
"left": 0,
"width": 836,
"height": 266
},
"tileFilter": {},
"isAutoRefreshDisabled": false,
"customName": "Data explorer results",
"queries": [
{
"id": "A",
"metric": "ext:custom.jmx.AzureDatabases.metric_ReadOnlyRedoQueueSizeInKB",
"spaceAggregation": "AUTO",
"timeAggregation": "DEFAULT",
"splitBy": [],
"sortBy": "DESC",
"sortByDimension": "",
"filterBy": {
"nestedFilters": [],
"criteria": []
},
"limit": 20,
"rate": "NONE",
"enabled": true
}
],
"visualConfig": {
"type": "GRAPH_CHART",
"global": {},
"rules": [
{
"matcher": "A:",
"properties": {
"color": "DEFAULT"
},
"seriesOverrides": []
}
],
"axes": {
"xAxis": {
"displayName": "",
"visible": true
},
"yAxes": [
{
"displayName": "",
"visible": true,
"min": "AUTO",
"max": "AUTO",
"position": "LEFT",
"queryIds": [
"A"
],
"defaultAxis": true
}
]
},
"heatmapSettings": {
"yAxis": "VALUE",
"showLabels": false
},
"singleValueSettings": {
"showTrend": true,
"showSparkLine": true,
"linkTileColorToThreshold": true
},
"thresholds": [
{
"axisTarget": "LEFT",
"rules": [
{
"color": "#7dc540"
},
{
"color": "#f5d30f"
},
{
"color": "#dc172a"
}
],
"visible": true
}
],
"tableSettings": {
"hiddenColumns": []
},
"graphChartSettings": {
"connectNulls": false
},
"honeycombSettings": {
"showHive": true,
"showLegend": true,
"showLabels": false
}
},
"queriesSettings": {
"resolution": ""
},
"metricExpressions": [
"resolution=null&(ext:custom.jmx.AzureDatabases.metric_ReadOnlyRedoQueueSizeInKB:splitBy():sort(value(auto,descending)):limit(20)):limit(100):names"
]
}
]
}