Dashboard Templates - Grafana¶
View templates online
Templates can be found online made by the community here
Custom Templates¶
WS22 - Monitoring Template
- A monitoring template sent with Windows Exporter from WS22
- This template was found here, but manually translated by me (Franz).
{
"annotations": {
"list": [
{
"builtIn": 1,
"datasource": {
"type": "datasource",
"uid": "grafana"
},
"enable": true,
"hide": true,
"iconColor": "rgba(0, 211, 255, 1)",
"name": "Annotations & Alerts",
"type": "dashboard"
}
]
},
"description": "Prometheus monitoring dashboard for Windows: added resource summary display, optimized detail view, and updated support for windows_exporter 0.13.0.",
"editable": false,
"fiscalYearStartMonth": 0,
"graphTooltip": 1,
"id": 9,
"links": [
{
"asDropdown": true,
"icon": "external link",
"tags": [],
"targetBlank": true,
"type": "dashboards"
}
],
"panels": [
{
"collapsed": false,
"gridPos": {
"h": 1,
"w": 24,
"x": 0,
"y": 0
},
"id": 41,
"panels": [],
"title": "Resource overview (linked to JOB item) | Currently selected host: [$show_hostname] | Instance: $instance",
"type": "row"
},
{
"datasource": {
"type": "prometheus",
"uid": "aehf7d1qq6xa8c"
},
"fieldConfig": {
"defaults": {
"custom": {
"align": "right",
"cellOptions": {
"type": "auto"
},
"inspect": false
},
"decimals": 2,
"displayName": "",
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green"
},
{
"color": "red",
"value": 80
}
]
},
"unit": "short"
},
"overrides": [
{
"matcher": {
"id": "byName",
"options": "product"
},
"properties": [
{
"id": "displayName",
"value": "Operating system"
},
{
"id": "unit",
"value": "short"
},
{
"id": "decimals",
"value": 2
},
{
"id": "custom.align"
}
]
},
{
"matcher": {
"id": "byName",
"options": "hostname"
},
"properties": [
{
"id": "displayName",
"value": "Host name"
},
{
"id": "unit",
"value": "short"
},
{
"id": "decimals",
"value": 2
},
{
"id": "custom.align"
}
]
},
{
"matcher": {
"id": "byName",
"options": "instance"
},
"properties": [
{
"id": "displayName",
"value": "Instance (linked to details)"
},
{
"id": "unit",
"value": "short"
},
{
"id": "decimals",
"value": 2
},
{
"id": "links",
"value": [
{
"targetBlank": false,
"title": "${__cell_4}",
"url": "/d/Kdh0OoSGz/?var-job=${__cell_5}&var-hostname=All&var-instance=${__cell_4}"
}
]
},
{
"id": "custom.align"
}
]
},
{
"matcher": {
"id": "byName",
"options": "Value #B"
},
"properties": [
{
"id": "displayName",
"value": "Number of CPU cores"
},
{
"id": "unit",
"value": "short"
},
{
"id": "decimals",
"value": 2
},
{
"id": "custom.align"
}
]
},
{
"matcher": {
"id": "byName",
"options": "Value #C"
},
"properties": [
{
"id": "displayName",
"value": "Total memory"
},
{
"id": "unit",
"value": "bytes"
},
{
"id": "custom.align"
}
]
},
{
"matcher": {
"id": "byName",
"options": "Value #D"
},
"properties": [
{
"id": "displayName",
"value": "Uptime"
},
{
"id": "unit",
"value": "s"
},
{
"id": "custom.cellOptions",
"value": {
"type": "color-background"
}
},
{
"id": "custom.align"
},
{
"id": "thresholds",
"value": {
"mode": "absolute",
"steps": [
{
"color": "rgba(245, 54, 54, 0.9)"
},
{
"color": "rgba(237, 129, 40, 0.89)",
"value": 259200
},
{
"color": "rgba(50, 172, 45, 0.97)",
"value": 432000
}
]
}
}
]
},
{
"matcher": {
"id": "byName",
"options": "Value #E"
},
"properties": [
{
"id": "displayName",
"value": "C drive usage rate"
},
{
"id": "unit",
"value": "percentunit"
},
{
"id": "decimals",
"value": 2
},
{
"id": "custom.cellOptions",
"value": {
"type": "color-background"
}
},
{
"id": "custom.align"
},
{
"id": "thresholds",
"value": {
"mode": "absolute",
"steps": [
{
"color": "rgba(50, 172, 45, 0.97)"
},
{
"color": "rgba(237, 129, 40, 0.89)",
"value": 60
},
{
"color": "rgba(245, 54, 54, 0.9)",
"value": 80
}
]
}
}
]
},
{
"matcher": {
"id": "byName",
"options": "Value #F"
},
"properties": [
{
"id": "displayName",
"value": "Most used partition%"
},
{
"id": "unit",
"value": "percentunit"
},
{
"id": "decimals",
"value": 2
},
{
"id": "custom.cellOptions",
"value": {
"type": "color-background"
}
},
{
"id": "custom.align"
},
{
"id": "thresholds",
"value": {
"mode": "absolute",
"steps": [
{
"color": "rgba(50, 172, 45, 0.97)"
},
{
"color": "rgba(237, 129, 40, 0.89)",
"value": 60
},
{
"color": "rgba(245, 54, 54, 0.9)",
"value": 80
}
]
}
}
]
},
{
"matcher": {
"id": "byName",
"options": "Value #G"
},
"properties": [
{
"id": "displayName",
"value": "Number of processes"
},
{
"id": "unit",
"value": "short"
},
{
"id": "decimals",
"value": 2
},
{
"id": "custom.align"
}
]
},
{
"matcher": {
"id": "byName",
"options": "Value #H"
},
"properties": [
{
"id": "displayName",
"value": "Running services"
},
{
"id": "unit",
"value": "short"
},
{
"id": "decimals",
"value": 2
},
{
"id": "custom.align"
}
]
},
{
"matcher": {
"id": "byName",
"options": "Value #I"
},
"properties": [
{
"id": "displayName",
"value": "CPU usage rate"
},
{
"id": "unit",
"value": "percent"
},
{
"id": "decimals",
"value": 2
},
{
"id": "custom.cellOptions",
"value": {
"type": "color-background"
}
},
{
"id": "custom.align"
},
{
"id": "thresholds",
"value": {
"mode": "absolute",
"steps": [
{
"color": "rgba(50, 172, 45, 0.97)"
},
{
"color": "rgba(237, 129, 40, 0.89)",
"value": 50
},
{
"color": "rgba(245, 54, 54, 0.9)",
"value": 70
}
]
}
}
]
},
{
"matcher": {
"id": "byName",
"options": "Value #J"
},
"properties": [
{
"id": "displayName",
"value": "Memory usage rate"
},
{
"id": "unit",
"value": "percent"
},
{
"id": "decimals",
"value": 2
},
{
"id": "custom.cellOptions",
"value": {
"type": "color-background"
}
},
{
"id": "custom.align"
},
{
"id": "thresholds",
"value": {
"mode": "absolute",
"steps": [
{
"color": "rgba(50, 172, 45, 0.97)"
},
{
"color": "rgba(237, 129, 40, 0.89)",
"value": 60
},
{
"color": "rgba(245, 54, 54, 0.9)",
"value": 80
}
]
}
}
]
},
{
"matcher": {
"id": "byName",
"options": "Value #K"
},
"properties": [
{
"id": "displayName",
"value": "CPU frequency"
},
{
"id": "unit",
"value": "rothz"
},
{
"id": "decimals",
"value": 2
},
{
"id": "custom.align"
}
]
}
]
},
"gridPos": {
"h": 6,
"w": 24,
"x": 0,
"y": 1
},
"id": 45,
"options": {
"cellHeight": "sm",
"footer": {
"countRows": false,
"fields": "",
"reducer": [
"sum"
],
"show": false
},
"frameIndex": 0,
"showHeader": true
},
"pluginVersion": "11.6.0",
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "aehf7d1qq6xa8c"
},
"expr": "windows_os_info{job=~\"$job\"} * on(instance) group_right(product) windows_cs_hostname",
"format": "table",
"instant": true,
"interval": "",
"legendFormat": "",
"refId": "A"
},
{
"datasource": {
"type": "prometheus",
"uid": "aehf7d1qq6xa8c"
},
"expr": "time() - windows_system_system_up_time{job=~\"$job\"}",
"format": "table",
"instant": true,
"interval": "",
"legendFormat": "",
"refId": "D"
},
{
"datasource": {
"type": "prometheus",
"uid": "aehf7d1qq6xa8c"
},
"expr": "windows_cs_logical_processors{job=~\"$job\"} - 0",
"format": "table",
"instant": true,
"interval": "",
"legendFormat": "",
"refId": "B"
},
{
"datasource": {
"type": "prometheus",
"uid": "aehf7d1qq6xa8c"
},
"expr": "avg by (instance) (windows_cpu_core_frequency_mhz{job=~\"$job\"})",
"format": "table",
"instant": true,
"interval": "",
"legendFormat": "",
"refId": "K"
},
{
"datasource": {
"type": "prometheus",
"uid": "aehf7d1qq6xa8c"
},
"expr": "100 - (avg by (instance) (irate(windows_cpu_time_total{job=~\"$job\",mode=\"idle\"}[2m])) * 100)",
"format": "table",
"instant": true,
"interval": "",
"legendFormat": "CPU usage rate",
"refId": "I"
},
{
"datasource": {
"type": "prometheus",
"uid": "aehf7d1qq6xa8c"
},
"expr": "windows_cs_physical_memory_bytes{job=~\"$job\"} - 0",
"format": "table",
"instant": true,
"interval": "",
"legendFormat": "",
"refId": "C"
},
{
"datasource": {
"type": "prometheus",
"uid": "aehf7d1qq6xa8c"
},
"expr": "100 - 100 * windows_os_physical_memory_free_bytes{job=~\"$job\"} / windows_cs_physical_memory_bytes{job=~\"$job\"}",
"format": "table",
"instant": true,
"interval": "",
"legendFormat": "Memory usage rate",
"refId": "J"
},
{
"datasource": {
"type": "prometheus",
"uid": "aehf7d1qq6xa8c"
},
"expr": "1 - (windows_logical_disk_free_bytes{job=~\"$job\",volume=~\"C:\"}/windows_logical_disk_size_bytes{job=~\"$job\",volume=~\"C:\"})",
"format": "table",
"instant": true,
"interval": "",
"legendFormat": "",
"refId": "E"
},
{
"datasource": {
"type": "prometheus",
"uid": "aehf7d1qq6xa8c"
},
"expr": "max by (instance) (1-windows_logical_disk_free_bytes/windows_logical_disk_size_bytes)",
"format": "table",
"instant": true,
"interval": "",
"legendFormat": "",
"refId": "F"
},
{
"datasource": {
"type": "prometheus",
"uid": "aehf7d1qq6xa8c"
},
"expr": "windows_os_processes{job=~\"$job\"}",
"format": "table",
"instant": true,
"interval": "",
"legendFormat": "",
"refId": "G"
},
{
"datasource": {
"type": "prometheus",
"uid": "aehf7d1qq6xa8c"
},
"expr": "sum by (instance) (windows_service_state{job=~\"$job\",state=~\"running\"})",
"format": "table",
"instant": true,
"interval": "",
"legendFormat": "",
"refId": "H"
}
],
"title": "$job: Server resource overview.",
"type": "table"
},
{
"datasource": {
"type": "prometheus",
"uid": "aehf7d1qq6xa8c"
},
"fieldConfig": {
"defaults": {
"color": {
"mode": "palette-classic"
},
"custom": {
"axisBorderShow": false,
"axisCenteredZero": false,
"axisColorMode": "text",
"axisLabel": "",
"axisPlacement": "auto",
"barAlignment": 0,
"barWidthFactor": 0.6,
"drawStyle": "line",
"fillOpacity": 10,
"gradientMode": "none",
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
},
"insertNulls": false,
"lineInterpolation": "linear",
"lineWidth": 1,
"pointSize": 5,
"scaleDistribution": {
"type": "linear"
},
"showPoints": "never",
"spanNulls": false,
"stacking": {
"group": "A",
"mode": "none"
},
"thresholdsStyle": {
"mode": "off"
}
},
"links": [],
"mappings": [],
"min": 0,
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green"
},
{
"color": "red",
"value": 80
}
]
},
"unit": "percent"
},
"overrides": []
},
"gridPos": {
"h": 6,
"w": 5,
"x": 0,
"y": 7
},
"id": 47,
"options": {
"legend": {
"calcs": [
"mean",
"lastNotNull",
"max"
],
"displayMode": "list",
"placement": "right",
"showLegend": false
},
"tooltip": {
"hideZeros": false,
"mode": "multi",
"sort": "desc"
}
},
"pluginVersion": "11.6.0",
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "aehf7d1qq6xa8c"
},
"expr": "100 - (avg by (instance) (irate(windows_cpu_time_total{job=~\"$job\",mode=\"idle\"}[2m])) * 100)",
"hide": false,
"interval": "",
"intervalFactor": 1,
"legendFormat": "{{instance}}",
"refId": "B"
}
],
"title": "CPU usage rate of each host.",
"type": "timeseries"
},
{
"datasource": {
"type": "prometheus",
"uid": "aehf7d1qq6xa8c"
},
"fieldConfig": {
"defaults": {
"color": {
"mode": "palette-classic"
},
"custom": {
"axisBorderShow": false,
"axisCenteredZero": false,
"axisColorMode": "text",
"axisLabel": "",
"axisPlacement": "auto",
"barAlignment": 0,
"barWidthFactor": 0.6,
"drawStyle": "line",
"fillOpacity": 10,
"gradientMode": "opacity",
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
},
"insertNulls": false,
"lineInterpolation": "linear",
"lineWidth": 2,
"pointSize": 5,
"scaleDistribution": {
"type": "linear"
},
"showPoints": "never",
"spanNulls": false,
"stacking": {
"group": "A",
"mode": "none"
},
"thresholdsStyle": {
"mode": "off"
}
},
"links": [],
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green"
},
{
"color": "red",
"value": 80
}
]
},
"unit": "percent"
},
"overrides": [
{
"matcher": {
"id": "byName",
"options": "Free Physical memory"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "semi-dark-green",
"mode": "fixed"
}
}
]
},
{
"matcher": {
"id": "byName",
"options": "Free physical memory"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "semi-dark-green",
"mode": "fixed"
}
}
]
},
{
"matcher": {
"id": "byName",
"options": "Free virtual memory"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "super-light-blue",
"mode": "fixed"
}
}
]
},
{
"matcher": {
"id": "byName",
"options": "Physical memory"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "dark-red",
"mode": "fixed"
}
}
]
},
{
"matcher": {
"id": "byName",
"options": "Virtual memory"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "dark-blue",
"mode": "fixed"
}
}
]
},
{
"matcher": {
"id": "byRegexp",
"options": "/.*Physical.*/"
},
"properties": [
{
"id": "custom.lineWidth",
"value": 3
}
]
}
]
},
"gridPos": {
"h": 6,
"w": 5,
"x": 5,
"y": 7
},
"id": 49,
"options": {
"legend": {
"calcs": [
"mean",
"lastNotNull",
"max"
],
"displayMode": "list",
"placement": "right",
"showLegend": false
},
"tooltip": {
"hideZeros": false,
"mode": "multi",
"sort": "none"
}
},
"pluginVersion": "11.6.0",
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "aehf7d1qq6xa8c"
},
"expr": "100.0 - 100 * windows_os_physical_memory_free_bytes{job=~\"$job\"} / windows_cs_physical_memory_bytes{job=~\"$job\"}",
"instant": false,
"interval": "",
"legendFormat": "{{instance}}",
"refId": "A"
}
],
"title": "Memory usage rate of each host.",
"type": "timeseries"
},
{
"datasource": {
"type": "prometheus",
"uid": "aehf7d1qq6xa8c"
},
"fieldConfig": {
"defaults": {
"color": {
"mode": "palette-classic"
},
"custom": {
"axisBorderShow": false,
"axisCenteredZero": false,
"axisColorMode": "text",
"axisLabel": "Download　　　　Upload",
"axisPlacement": "auto",
"barAlignment": 0,
"barWidthFactor": 0.6,
"drawStyle": "line",
"fillOpacity": 10,
"gradientMode": "none",
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
},
"insertNulls": false,
"lineInterpolation": "linear",
"lineWidth": 1,
"pointSize": 5,
"scaleDistribution": {
"type": "linear"
},
"showPoints": "never",
"spanNulls": false,
"stacking": {
"group": "A",
"mode": "none"
},
"thresholdsStyle": {
"mode": "off"
}
},
"links": [],
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green"
},
{
"color": "red",
"value": 80
}
]
},
"unit": "bps"
},
"overrides": []
},
"gridPos": {
"h": 6,
"w": 5,
"x": 10,
"y": 7
},
"id": 53,
"options": {
"legend": {
"calcs": [
"mean",
"lastNotNull",
"max"
],
"displayMode": "list",
"placement": "right",
"showLegend": false
},
"tooltip": {
"hideZeros": false,
"mode": "multi",
"sort": "desc"
}
},
"pluginVersion": "11.6.0",
"targets": [
{
"application": {
"filter": ""
},
"datasource": {
"type": "prometheus",
"uid": "aehf7d1qq6xa8c"
},
"expr": "max by (instance) (irate(windows_net_bytes_sent_total{job=~\"$job\",nic!~'isatap.*|VPN.*'}[2m]))*8",
"format": "time_series",
"functions": [],
"group": {
"filter": ""
},
"hide": false,
"host": {
"filter": ""
},
"interval": "",
"intervalFactor": 1,
"item": {
"filter": ""
},
"legendFormat": "{{instance}}_upload",
"metric": "mysql_global_status_questions",
"mode": 0,
"options": {
"showDisabledItems": false
},
"refId": "B",
"step": 10
},
{
"application": {
"filter": ""
},
"datasource": {
"type": "prometheus",
"uid": "aehf7d1qq6xa8c"
},
"expr": "-max by (instance) (irate(windows_net_bytes_received_total{job=~\"$job\",nic!~'isatap.*|VPN.*'}[2m]))*8",
"format": "time_series",
"functions": [],
"group": {
"filter": ""
},
"hide": false,
"host": {
"filter": ""
},
"interval": "",
"intervalFactor": 1,
"item": {
"filter": ""
},
"legendFormat": "{{instance}}_download",
"metric": "mysql_global_status_questions",
"mode": 0,
"options": {
"showDisabledItems": false
},
"refId": "A",
"step": 10
}
],
"title": "Network details of the highest-traffic network interface on each host.",
"type": "timeseries"
},
{
"datasource": {
"type": "prometheus",
"uid": "aehf7d1qq6xa8c"
},
"fieldConfig": {
"defaults": {
"color": {
"mode": "palette-classic"
},
"custom": {
"axisBorderShow": false,
"axisCenteredZero": false,
"axisColorMode": "text",
"axisLabel": "Read　　　　Write",
"axisPlacement": "auto",
"barAlignment": 0,
"barWidthFactor": 0.6,
"drawStyle": "line",
"fillOpacity": 20,
"gradientMode": "none",
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
},
"insertNulls": false,
"lineInterpolation": "linear",
"lineWidth": 1,
"pointSize": 5,
"scaleDistribution": {
"type": "linear"
},
"showPoints": "never",
"spanNulls": false,
"stacking": {
"group": "A",
"mode": "none"
},
"thresholdsStyle": {
"mode": "off"
}
},
"links": [],
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green"
},
{
"color": "red",
"value": 80
}
]
},
"unit": "Bps"
},
"overrides": []
},
"gridPos": {
"h": 6,
"w": 5,
"x": 15,
"y": 7
},
"id": 51,
"options": {
"legend": {
"calcs": [
"mean",
"lastNotNull",
"max"
],
"displayMode": "list",
"placement": "right",
"showLegend": false
},
"tooltip": {
"hideZeros": false,
"mode": "multi",
"sort": "desc"
}
},
"pluginVersion": "11.6.0",
"targets": [
{
"application": {
"filter": ""
},
"datasource": {
"type": "prometheus",
"uid": "aehf7d1qq6xa8c"
},
"expr": "-max by (instance) (irate(windows_logical_disk_read_bytes_total[2m]))",
"format": "time_series",
"functions": [],
"group": {
"filter": ""
},
"hide": false,
"host": {
"filter": ""
},
"interval": "",
"intervalFactor": 1,
"item": {
"filter": ""
},
"legendFormat": "{{instance}}_Read",
"metric": "mysql_global_status_questions",
"mode": 0,
"options": {
"showDisabledItems": false
},
"refId": "A",
"step": 20
},
{
"application": {
"filter": ""
},
"datasource": {
"type": "prometheus",
"uid": "aehf7d1qq6xa8c"
},
"expr": "max by (instance) (irate(windows_logical_disk_write_bytes_total[2m]))",
"format": "time_series",
"functions": [],
"group": {
"filter": ""
},
"hide": false,
"host": {
"filter": ""
},
"interval": "",
"intervalFactor": 1,
"item": {
"filter": ""
},
"legendFormat": "{{instance}}_Write",
"metric": "mysql_global_status_questions",
"mode": 0,
"options": {
"showDisabledItems": false
},
"refId": "B",
"step": 20
}
],
"title": "Details of the highest disk read/write activity on each host.",
"type": "timeseries"
},
{
"datasource": {
"type": "prometheus",
"uid": "aehf7d1qq6xa8c"
},
"fieldConfig": {
"defaults": {
"color": {
"mode": "palette-classic"
},
"custom": {
"axisBorderShow": false,
"axisCenteredZero": false,
"axisColorMode": "text",
"axisLabel": "Read　　　　Write",
"axisPlacement": "auto",
"barAlignment": 0,
"barWidthFactor": 0.6,
"drawStyle": "line",
"fillOpacity": 10,
"gradientMode": "none",
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
},
"insertNulls": false,
"lineInterpolation": "linear",
"lineWidth": 1,
"pointSize": 5,
"scaleDistribution": {
"type": "linear"
},
"showPoints": "never",
"spanNulls": false,
"stacking": {
"group": "A",
"mode": "none"
},
"thresholdsStyle": {
"mode": "off"
}
},
"links": [],
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green"
},
{
"color": "red",
"value": 80
}
]
},
"unit": "iops"
},
"overrides": []
},
"gridPos": {
"h": 6,
"w": 4,
"x": 20,
"y": 7
},
"id": 55,
"options": {
"legend": {
"calcs": [
"mean",
"lastNotNull",
"max"
],
"displayMode": "list",
"placement": "right",
"showLegend": false
},
"tooltip": {
"hideZeros": false,
"mode": "multi",
"sort": "desc"
}
},
"pluginVersion": "11.6.0",
"targets": [
{
"application": {
"filter": ""
},
"datasource": {
"type": "prometheus",
"uid": "aehf7d1qq6xa8c"
},
"expr": "-max by (instance) (irate(windows_logical_disk_reads_total[2m]))",
"format": "time_series",
"functions": [],
"group": {
"filter": ""
},
"hide": false,
"host": {
"filter": ""
},
"interval": "",
"intervalFactor": 1,
"item": {
"filter": ""
},
"legendFormat": "{{instance}}_Read",
"metric": "mysql_global_status_questions",
"mode": 0,
"options": {
"showDisabledItems": false
},
"refId": "B",
"step": 20
},
{
"application": {
"filter": ""
},
"datasource": {
"type": "prometheus",
"uid": "aehf7d1qq6xa8c"
},
"expr": "max by (instance) (irate(windows_logical_disk_writes_total[2m]))",
"format": "time_series",
"functions": [],
"group": {
"filter": ""
},
"hide": false,
"host": {
"filter": ""
},
"interval": "",
"intervalFactor": 1,
"item": {
"filter": ""
},
"legendFormat": "{{instance}}_Write",
"metric": "mysql_global_status_questions",
"mode": 0,
"options": {
"showDisabledItems": false
},
"refId": "C",
"step": 20
}
],
"title": "Details of the highest disk I/O activity on each host.",
"type": "timeseries"
},
{
"collapsed": false,
"gridPos": {
"h": 1,
"w": 24,
"x": 0,
"y": 13
},
"id": 43,
"panels": [],
"title": "Resource details [$show_hostname: $instance] ",
"type": "row"
},
{
"datasource": {
"type": "prometheus",
"uid": "aehf7d1qq6xa8c"
},
"description": "",
"fieldConfig": {
"defaults": {
"decimals": 0,
"mappings": [
{
"options": {
"match": "null",
"result": {
"text": "N/A"
}
},
"type": "special"
}
],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green"
},
{
"color": "red",
"value": 80
}
]
},
"unit": "s"
},
"overrides": []
},
"gridPos": {
"h": 2,
"w": 2,
"x": 0,
"y": 14
},
"id": 33,
"maxDataPoints": 100,
"options": {
"colorMode": "value",
"graphMode": "none",
"justifyMode": "auto",
"orientation": "horizontal",
"percentChangeColorMode": "standard",
"reduceOptions": {
"calcs": [
"lastNotNull"
],
"fields": "/^{instance=\"172.18.50.249:9182\", job=\"windows-exporter\"}$/",
"values": false
},
"showPercentChange": false,
"textMode": "auto",
"wideLayout": true
},
"pluginVersion": "11.6.0",
"repeat": "host",
"repeatDirection": "v",
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "aehf7d1qq6xa8c"
},
"expr": "time() - windows_system_system_up_time{job=~\"$job\",instance=~\"$instance\"}",
"instant": false,
"interval": "",
"legendFormat": "",
"refId": "A"
}
],
"title": "Uptime",
"type": "stat"
},
{
"datasource": {
"type": "prometheus",
"uid": "aehf7d1qq6xa8c"
},
"fieldConfig": {
"defaults": {
"mappings": [
{
"options": {
"": {
"text": ""
}
},
"type": "value"
}
],
"max": 100,
"min": 0,
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "#299c46"
},
{
"color": "rgba(237, 129, 40, 0.89)",
"value": 60
},
{
"color": "#d44a3a",
"value": 90
}
]
},
"unit": "percent"
},
"overrides": []
},
"gridPos": {
"h": 3,
"w": 2,
"x": 2,
"y": 14
},
"id": 19,
"maxDataPoints": 100,
"options": {
"colorMode": "value",
"graphMode": "area",
"justifyMode": "auto",
"orientation": "horizontal",
"percentChangeColorMode": "standard",
"reduceOptions": {
"calcs": [
"lastNotNull"
],
"fields": "",
"values": false
},
"showPercentChange": false,
"textMode": "auto",
"wideLayout": true
},
"pluginVersion": "11.6.0",
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "aehf7d1qq6xa8c"
},
"expr": "100 - (avg(irate(windows_cpu_time_total{job=~\"$job\",instance=~\"$instance\",mode=\"idle\"}[2m])))*100",
"format": "time_series",
"interval": "",
"intervalFactor": 1,
"legendFormat": "",
"refId": "A"
}
],
"title": "CPU usage rate",
"type": "stat"
},
{
"datasource": {
"type": "prometheus",
"uid": "aehf7d1qq6xa8c"
},
"fieldConfig": {
"defaults": {
"color": {
"mode": "thresholds"
},
"mappings": [],
"max": 100,
"min": 0,
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green"
},
{
"color": "#EAB839",
"value": 80
},
{
"color": "red",
"value": 90
}
]
},
"unit": "percent"
},
"overrides": []
},
"gridPos": {
"h": 6,
"w": 4,
"x": 4,
"y": 14
},
"id": 23,
"options": {
"displayMode": "lcd",
"legend": {
"calcs": [],
"displayMode": "list",
"placement": "bottom",
"showLegend": false
},
"maxVizHeight": 300,
"minVizHeight": 16,
"minVizWidth": 8,
"namePlacement": "auto",
"orientation": "horizontal",
"reduceOptions": {
"calcs": [
"lastNotNull"
],
"fields": "",
"values": false
},
"showUnfilled": true,
"sizing": "auto",
"valueMode": "color"
},
"pluginVersion": "11.6.0",
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "aehf7d1qq6xa8c"
},
"expr": "100 - (windows_logical_disk_free_bytes{job=~\"$job\",instance=~\"$instance\"} / windows_logical_disk_size_bytes{job=~\"$job\",instance=~\"$instance\"})*100",
"instant": false,
"interval": "",
"legendFormat": "{{volume}}",
"refId": "A"
}
],
"title": "Usage rate of each partition",
"type": "bargauge"
},
{
"datasource": {
"type": "prometheus",
"uid": "aehf7d1qq6xa8c"
},
"fieldConfig": {
"defaults": {
"color": {
"mode": "palette-classic"
},
"custom": {
"axisBorderShow": false,
"axisCenteredZero": false,
"axisColorMode": "text",
"axisLabel": "",
"axisPlacement": "auto",
"barAlignment": 0,
"barWidthFactor": 0.6,
"drawStyle": "line",
"fillOpacity": 100,
"gradientMode": "none",
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
},
"insertNulls": false,
"lineInterpolation": "linear",
"lineWidth": 0,
"pointSize": 5,
"scaleDistribution": {
"type": "linear"
},
"showPoints": "never",
"spanNulls": false,
"stacking": {
"group": "A",
"mode": "normal"
},
"thresholdsStyle": {
"mode": "off"
}
},
"links": [],
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green"
},
{
"color": "red",
"value": 80
}
]
},
"unit": "short"
},
"overrides": [
{
"matcher": {
"id": "byName",
"options": "Received mysqld-exporter:9104"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "#0A50A1",
"mode": "fixed"
}
}
]
},
{
"matcher": {
"id": "byName",
"options": "stopped"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "#2F575E",
"mode": "fixed"
}
}
]
}
]
},
"gridPos": {
"h": 6,
"w": 8,
"x": 8,
"y": 14
},
"id": 7,
"options": {
"legend": {
"calcs": [
"lastNotNull"
],
"displayMode": "table",
"placement": "right",
"showLegend": true
},
"tooltip": {
"hideZeros": false,
"mode": "multi",
"sort": "none"
}
},
"pluginVersion": "11.6.0",
"targets": [
{
"application": {
"filter": ""
},
"datasource": {
"type": "prometheus",
"uid": "aehf7d1qq6xa8c"
},
"expr": "sum(windows_service_state{job=~\"$job\",instance=~\"$instance\"}) by (state)",
"format": "time_series",
"functions": [],
"group": {
"filter": ""
},
"host": {
"filter": ""
},
"interval": "",
"intervalFactor": 1,
"item": {
"filter": ""
},
"legendFormat": "{{state}}",
"mode": 0,
"options": {
"showDisabledItems": false
},
"refId": "A",
"step": 5
}
],
"title": "Service status",
"type": "timeseries"
},
{
"datasource": {
"type": "prometheus",
"uid": "aehf7d1qq6xa8c"
},
"fieldConfig": {
"defaults": {
"color": {
"mode": "palette-classic"
},
"custom": {
"axisBorderShow": false,
"axisCenteredZero": false,
"axisColorMode": "text",
"axisLabel": "",
"axisPlacement": "auto",
"barAlignment": 0,
"barWidthFactor": 0.6,
"drawStyle": "line",
"fillOpacity": 0,
"gradientMode": "none",
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
},
"insertNulls": false,
"lineInterpolation": "linear",
"lineWidth": 2,
"pointSize": 5,
"scaleDistribution": {
"type": "linear"
},
"showPoints": "never",
"spanNulls": false,
"stacking": {
"group": "A",
"mode": "none"
},
"thresholdsStyle": {
"mode": "off"
}
},
"links": [],
"mappings": [],
"min": 0,
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green"
},
{
"color": "red",
"value": 80
}
]
},
"unit": "decbytes"
},
"overrides": [
{
"matcher": {
"id": "byRegexp",
"options": "/Total space.*/"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "#F2495C",
"mode": "fixed"
}
}
]
}
]
},
"gridPos": {
"h": 8,
"w": 8,
"x": 16,
"y": 14
},
"id": 15,
"options": {
"legend": {
"calcs": [
"mean",
"lastNotNull",
"max",
"min"
],
"displayMode": "table",
"placement": "bottom",
"showLegend": true
},
"tooltip": {
"hideZeros": false,
"mode": "multi",
"sort": "desc"
}
},
"pluginVersion": "11.6.0",
"targets": [
{
"application": {
"filter": ""
},
"datasource": {
"type": "prometheus",
"uid": "aehf7d1qq6xa8c"
},
"expr": "windows_logical_disk_free_bytes{job=~\"$job\",instance=~\"$instance\"}",
"format": "time_series",
"functions": [],
"group": {
"filter": ""
},
"hide": false,
"host": {
"filter": ""
},
"interval": "",
"intervalFactor": 1,
"item": {
"filter": ""
},
"legendFormat": "Available space {{volume}}",
"metric": "mysql_global_status_questions",
"mode": 0,
"options": {
"showDisabledItems": false
},
"refId": "A",
"step": 20
},
{
"application": {
"filter": ""
},
"datasource": {
"type": "prometheus",
"uid": "aehf7d1qq6xa8c"
},
"expr": "windows_logical_disk_size_bytes{job=~\"$job\",instance=~\"$instance\"}",
"format": "time_series",
"functions": [],
"group": {
"filter": ""
},
"hide": false,
"host": {
"filter": ""
},
"interval": "",
"intervalFactor": 1,
"item": {
"filter": ""
},
"legendFormat": "Total space {{volume}}",
"metric": "mysql_global_status_questions",
"mode": 0,
"options": {
"showDisabledItems": false
},
"refId": "B",
"step": 20
}
],
"title": "Remaining disk space",
"type": "timeseries"
},
{
"datasource": {
"type": "prometheus",
"uid": "aehf7d1qq6xa8c"
},
"description": "",
"fieldConfig": {
"defaults": {
"decimals": 0,
"mappings": [
{
"options": {
"match": "null",
"result": {
"text": "N/A"
}
},
"type": "special"
}
],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green"
},
{
"color": "red",
"value": 80
}
]
},
"unit": "none"
},
"overrides": []
},
"gridPos": {
"h": 2,
"w": 2,
"x": 0,
"y": 16
},
"id": 35,
"maxDataPoints": 100,
"options": {
"colorMode": "value",
"graphMode": "none",
"justifyMode": "auto",
"orientation": "horizontal",
"percentChangeColorMode": "standard",
"reduceOptions": {
"calcs": [
"lastNotNull"
],
"fields": "/^windows_cs_logical_processors{instance=\"172.18.50.249:9182\", job=\"windows-exporter\"}$/",
"values": false
},
"showPercentChange": false,
"textMode": "auto",
"wideLayout": true
},
"pluginVersion": "11.6.0",
"repeat": "host",
"repeatDirection": "v",
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "aehf7d1qq6xa8c"
},
"expr": "windows_cs_logical_processors{job=~\"$job\",instance=~\"$instance\"}",
"format": "time_series",
"instant": false,
"interval": "",
"intervalFactor": 1,
"legendFormat": "",
"refId": "A"
}
],
"title": "Number of CPU cores.",
"type": "stat"
},
{
"datasource": {
"type": "prometheus",
"uid": "aehf7d1qq6xa8c"
},
"fieldConfig": {
"defaults": {
"mappings": [
{
"options": {
"match": "null",
"result": {
"text": "N/A"
}
},
"type": "special"
}
],
"max": 100,
"min": 0,
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "#299c46"
},
{
"color": "rgba(237, 129, 40, 0.89)",
"value": 80
},
{
"color": "#d44a3a",
"value": 90
}
]
},
"unit": "percent"
},
"overrides": []
},
"gridPos": {
"h": 3,
"w": 2,
"x": 2,
"y": 17
},
"id": 21,
"maxDataPoints": 100,
"options": {
"colorMode": "value",
"graphMode": "area",
"justifyMode": "auto",
"orientation": "horizontal",
"percentChangeColorMode": "standard",
"reduceOptions": {
"calcs": [
"lastNotNull"
],
"fields": "/^{instance=\"172.18.50.249:9182\", job=\"windows-exporter\"}$/",
"values": false
},
"showPercentChange": false,
"textMode": "auto",
"wideLayout": true
},
"pluginVersion": "11.6.0",
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "aehf7d1qq6xa8c"
},
"expr": "100 - (windows_os_physical_memory_free_bytes{job=~\"$job\",instance=~\"$instance\"} / windows_cs_physical_memory_bytes{job=~\"$job\",instance=~\"$instance\"})*100",
"instant": false,
"refId": "A"
}
],
"title": "Memory usage rate",
"type": "stat"
},
{
"datasource": {
"type": "prometheus",
"uid": "aehf7d1qq6xa8c"
},
"description": "",
"fieldConfig": {
"defaults": {
"decimals": 1,
"mappings": [
{
"options": {
"match": "null",
"result": {
"text": "N/A"
}
},
"type": "special"
}
],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green"
},
{
"color": "red",
"value": 80
}
]
},
"unit": "bytes"
},
"overrides": []
},
"gridPos": {
"h": 2,
"w": 2,
"x": 0,
"y": 18
},
"id": 37,
"maxDataPoints": 100,
"options": {
"colorMode": "value",
"graphMode": "none",
"justifyMode": "auto",
"orientation": "horizontal",
"percentChangeColorMode": "standard",
"reduceOptions": {
"calcs": [
"lastNotNull"
],
"fields": "/^windows_cs_physical_memory_bytes{instance=\"172.18.50.249:9182\", job=\"windows-exporter\"}$/",
"values": false
},
"showPercentChange": false,
"textMode": "auto",
"wideLayout": true
},
"pluginVersion": "11.6.0",
"repeat": "host",
"repeatDirection": "v",
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "aehf7d1qq6xa8c"
},
"expr": "windows_cs_physical_memory_bytes{job=~\"$job\",instance=~\"$instance\"}",
"format": "time_series",
"instant": false,
"interval": "",
"intervalFactor": 1,
"legendFormat": "",
"refId": "A"
}
],
"title": "Total memory",
"type": "stat"
},
{
"datasource": {
"type": "prometheus",
"uid": "aehf7d1qq6xa8c"
},
"fieldConfig": {
"defaults": {
"color": {
"mode": "palette-classic"
},
"custom": {
"axisBorderShow": false,
"axisCenteredZero": false,
"axisColorMode": "text",
"axisLabel": "",
"axisPlacement": "auto",
"barAlignment": 0,
"barWidthFactor": 0.6,
"drawStyle": "line",
"fillOpacity": 10,
"gradientMode": "none",
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
},
"insertNulls": false,
"lineInterpolation": "linear",
"lineWidth": 1,
"pointSize": 5,
"scaleDistribution": {
"type": "linear"
},
"showPoints": "never",
"spanNulls": false,
"stacking": {
"group": "A",
"mode": "normal"
},
"thresholdsStyle": {
"mode": "off"
}
},
"links": [],
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green"
},
{
"color": "red",
"value": 80
}
]
},
"unit": "percent"
},
"overrides": []
},
"gridPos": {
"h": 8,
"w": 8,
"x": 0,
"y": 20
},
"id": 25,
"options": {
"legend": {
"calcs": [
"mean",
"lastNotNull",
"max",
"min"
],
"displayMode": "list",
"placement": "bottom",
"showLegend": true
},
"tooltip": {
"hideZeros": false,
"mode": "multi",
"sort": "none"
}
},
"pluginVersion": "11.6.0",
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "aehf7d1qq6xa8c"
},
"expr": "100 - avg(irate(windows_cpu_time_total{job=~\"$job\",instance=~\"$instance\",mode=\"idle\"}[5m]))*100",
"hide": false,
"interval": "",
"legendFormat": "CPU usage rate",
"refId": "A"
}
],
"title": "CPU usage rate",
"type": "timeseries"
},
{
"datasource": {
"type": "prometheus",
"uid": "aehf7d1qq6xa8c"
},
"fieldConfig": {
"defaults": {
"color": {
"mode": "palette-classic"
},
"custom": {
"axisBorderShow": false,
"axisCenteredZero": false,
"axisColorMode": "text",
"axisLabel": "",
"axisPlacement": "auto",
"barAlignment": 0,
"barWidthFactor": 0.6,
"drawStyle": "line",
"fillOpacity": 30,
"gradientMode": "opacity",
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
},
"insertNulls": false,
"lineInterpolation": "linear",
"lineWidth": 0,
"pointSize": 5,
"scaleDistribution": {
"type": "linear"
},
"showPoints": "never",
"spanNulls": false,
"stacking": {
"group": "A",
"mode": "none"
},
"thresholdsStyle": {
"mode": "off"
}
},
"links": [],
"mappings": [],
"min": 0,
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green"
},
{
"color": "red",
"value": 80
}
]
},
"unit": "bytes"
},
"overrides": [
{
"matcher": {
"id": "byName",
"options": "Free Physical memory"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "semi-dark-green",
"mode": "fixed"
}
}
]
},
{
"matcher": {
"id": "byName",
"options": "Free physical memory"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "semi-dark-green",
"mode": "fixed"
}
}
]
},
{
"matcher": {
"id": "byName",
"options": "Free virtual memory"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "yellow",
"mode": "fixed"
}
}
]
},
{
"matcher": {
"id": "byName",
"options": "Physical memory"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "dark-red",
"mode": "fixed"
}
}
]
},
{
"matcher": {
"id": "byName",
"options": "Virtual memory"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "dark-purple",
"mode": "fixed"
}
}
]
},
{
"matcher": {
"id": "byName",
"options": "Available physical memory"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "green",
"mode": "fixed"
}
}
]
},
{
"matcher": {
"id": "byName",
"options": "Total physical memory"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "dark-red",
"mode": "fixed"
}
}
]
},
{
"matcher": {
"id": "byRegexp",
"options": "/.*Physical memory.*/"
},
"properties": [
{
"id": "custom.lineWidth",
"value": 2
}
]
}
]
},
"gridPos": {
"h": 8,
"w": 8,
"x": 8,
"y": 20
},
"id": 14,
"options": {
"legend": {
"calcs": [
"mean",
"lastNotNull",
"max",
"min"
],
"displayMode": "table",
"placement": "bottom",
"showLegend": true
},
"tooltip": {
"hideZeros": false,
"mode": "multi",
"sort": "desc"
}
},
"pluginVersion": "11.6.0",
"targets": [
{
"application": {
"filter": ""
},
"datasource": {
"type": "prometheus",
"uid": "aehf7d1qq6xa8c"
},
"expr": "windows_cs_physical_memory_bytes{job=~\"$job\",instance=~\"$instance\"}",
"format": "time_series",
"functions": [],
"group": {
"filter": ""
},
"hide": false,
"host": {
"filter": ""
},
"interval": "",
"intervalFactor": 1,
"item": {
"filter": ""
},
"legendFormat": "Total physical memory",
"metric": "mysql_global_status_questions",
"mode": 0,
"options": {
"showDisabledItems": false
},
"refId": "B",
"step": 5
},
{
"application": {
"filter": ""
},
"datasource": {
"type": "prometheus",
"uid": "aehf7d1qq6xa8c"
},
"expr": "windows_os_physical_memory_free_bytes{job=~\"$job\",instance=~\"$instance\"}",
"format": "time_series",
"functions": [],
"group": {
"filter": ""
},
"hide": false,
"host": {
"filter": ""
},
"interval": "",
"intervalFactor": 1,
"item": {
"filter": ""
},
"legendFormat": "Available physical memory",
"metric": "mysql_global_status_questions",
"mode": 0,
"options": {
"showDisabledItems": false
},
"refId": "C",
"step": 5
},
{
"application": {
"filter": ""
},
"datasource": {
"type": "prometheus",
"uid": "aehf7d1qq6xa8c"
},
"expr": "windows_os_virtual_memory_bytes{job=~\"$job\",instance=~\"$instance\"}",
"format": "time_series",
"functions": [],
"group": {
"filter": ""
},
"hide": false,
"host": {
"filter": ""
},
"intervalFactor": 1,
"item": {
"filter": ""
},
"legendFormat": "Virtual memory",
"metric": "mysql_global_status_questions",
"mode": 0,
"options": {
"showDisabledItems": false
},
"refId": "A",
"step": 5
},
{
"datasource": {
"type": "prometheus",
"uid": "aehf7d1qq6xa8c"
},
"expr": "windows_os_virtual_memory_free_bytes{job=~\"$job\",instance=~\"$instance\"}",
"format": "time_series",
"intervalFactor": 1,
"legendFormat": "Free virtual memory",
"refId": "D"
}
],
"title": "Memory details",
"type": "timeseries"
},
{
"datasource": {
"type": "prometheus",
"uid": "aehf7d1qq6xa8c"
},
"fieldConfig": {
"defaults": {
"color": {
"mode": "palette-classic"
},
"custom": {
"axisBorderShow": false,
"axisCenteredZero": false,
"axisColorMode": "text",
"axisLabel": "",
"axisPlacement": "auto",
"barAlignment": 0,
"barWidthFactor": 0.6,
"drawStyle": "line",
"fillOpacity": 10,
"gradientMode": "none",
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
},
"insertNulls": false,
"lineInterpolation": "linear",
"lineWidth": 1,
"pointSize": 5,
"scaleDistribution": {
"type": "linear"
},
"showPoints": "never",
"spanNulls": false,
"stacking": {
"group": "A",
"mode": "none"
},
"thresholdsStyle": {
"mode": "off"
}
},
"links": [],
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green"
},
{
"color": "red",
"value": 80
}
]
},
"unit": "iops"
},
"overrides": []
},
"gridPos": {
"h": 8,
"w": 8,
"x": 16,
"y": 22
},
"id": 9,
"options": {
"legend": {
"calcs": [
"mean",
"lastNotNull",
"max",
"min"
],
"displayMode": "table",
"placement": "bottom",
"showLegend": true
},
"tooltip": {
"hideZeros": false,
"mode": "multi",
"sort": "none"
}
},
"pluginVersion": "11.6.0",
"targets": [
{
"application": {
"filter": ""
},
"datasource": {
"type": "prometheus",
"uid": "aehf7d1qq6xa8c"
},
"expr": "irate(windows_logical_disk_reads_total{job=~\"$job\",instance=~\"$instance\"}[5m])",
"format": "time_series",
"functions": [],
"group": {
"filter": ""
},
"hide": false,
"host": {
"filter": ""
},
"intervalFactor": 1,
"item": {
"filter": ""
},
"legendFormat": "read {{volume}}",
"metric": "mysql_global_status_questions",
"mode": 0,
"options": {
"showDisabledItems": false
},
"refId": "B",
"step": 20
},
{
"application": {
"filter": ""
},
"datasource": {
"type": "prometheus",
"uid": "aehf7d1qq6xa8c"
},
"expr": "irate(windows_logical_disk_writes_total{job=~\"$job\",instance=~\"$instance\"}[5m])",
"format": "time_series",
"functions": [],
"group": {
"filter": ""
},
"hide": false,
"host": {
"filter": ""
},
"intervalFactor": 1,
"item": {
"filter": ""
},
"legendFormat": "write {{volume}}",
"metric": "mysql_global_status_questions",
"mode": 0,
"options": {
"showDisabledItems": false
},
"refId": "C",
"step": 20
}
],
"title": "Disk I/O",
"type": "timeseries"
},
{
"datasource": {
"type": "prometheus",
"uid": "aehf7d1qq6xa8c"
},
"fieldConfig": {
"defaults": {
"color": {
"mode": "palette-classic"
},
"custom": {
"axisBorderShow": false,
"axisCenteredZero": false,
"axisColorMode": "text",
"axisLabel": "",
"axisPlacement": "auto",
"barAlignment": 0,
"barWidthFactor": 0.6,
"drawStyle": "line",
"fillOpacity": 10,
"gradientMode": "none",
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
},
"insertNulls": false,
"lineInterpolation": "linear",
"lineWidth": 1,
"pointSize": 5,
"scaleDistribution": {
"type": "linear"
},
"showPoints": "never",
"spanNulls": false,
"stacking": {
"group": "A",
"mode": "none"
},
"thresholdsStyle": {
"mode": "off"
}
},
"links": [],
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green"
},
{
"color": "red",
"value": 80
}
]
},
"unit": "bps"
},
"overrides": []
},
"gridPos": {
"h": 8,
"w": 8,
"x": 0,
"y": 28
},
"id": 11,
"options": {
"legend": {
"calcs": [
"mean",
"lastNotNull",
"max",
"min"
],
"displayMode": "table",
"placement": "bottom",
"showLegend": true
},
"tooltip": {
"hideZeros": false,
"mode": "multi",
"sort": "desc"
}
},
"pluginVersion": "11.6.0",
"targets": [
{
"application": {
"filter": ""
},
"datasource": {
"type": "prometheus",
"uid": "aehf7d1qq6xa8c"
},
"expr": "irate(windows_net_bytes_sent_total{job=~\"$job\",instance=~\"$instance\",nic!~'isatap.*|VPN.*'}[5m])*8>0\r",
"format": "time_series",
"functions": [],
"group": {
"filter": ""
},
"hide": false,
"host": {
"filter": ""
},
"interval": "",
"intervalFactor": 1,
"item": {
"filter": ""
},
"legendFormat": "{{nic}}-Sent-upload",
"metric": "mysql_global_status_questions",
"mode": 0,
"options": {
"showDisabledItems": false
},
"refId": "B",
"step": 10
},
{
"application": {
"filter": ""
},
"datasource": {
"type": "prometheus",
"uid": "aehf7d1qq6xa8c"
},
"expr": "irate(windows_net_bytes_received_total{job=~\"$job\",instance=~\"$instance\",nic!~'isatap.*|VPN.*'}[5m])*8\n",
"format": "time_series",
"functions": [],
"group": {
"filter": ""
},
"hide": false,
"host": {
"filter": ""
},
"intervalFactor": 1,
"item": {
"filter": ""
},
"legendFormat": "{{nic}}-Received-download",
"metric": "mysql_global_status_questions",
"mode": 0,
"options": {
"showDisabledItems": false
},
"refId": "A",
"step": 10
}
],
"title": "Network details",
"type": "timeseries"
},
{
"datasource": {
"type": "prometheus",
"uid": "aehf7d1qq6xa8c"
},
"fieldConfig": {
"defaults": {
"color": {
"mode": "palette-classic"
},
"custom": {
"axisBorderShow": false,
"axisCenteredZero": false,
"axisColorMode": "text",
"axisLabel": "",
"axisPlacement": "auto",
"barAlignment": 0,
"barWidthFactor": 0.6,
"drawStyle": "line",
"fillOpacity": 20,
"gradientMode": "none",
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
},
"insertNulls": false,
"lineInterpolation": "linear",
"lineWidth": 1,
"pointSize": 5,
"scaleDistribution": {
"type": "linear"
},
"showPoints": "never",
"spanNulls": false,
"stacking": {
"group": "A",
"mode": "none"
},
"thresholdsStyle": {
"mode": "off"
}
},
"links": [],
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green"
},
{
"color": "red",
"value": 80
}
]
},
"unit": "Bps"
},
"overrides": []
},
"gridPos": {
"h": 8,
"w": 8,
"x": 8,
"y": 28
},
"id": 8,
"options": {
"legend": {
"calcs": [
"mean",
"lastNotNull",
"max",
"min"
],
"displayMode": "table",
"placement": "bottom",
"showLegend": true
},
"tooltip": {
"hideZeros": false,
"mode": "multi",
"sort": "none"
}
},
"pluginVersion": "11.6.0",
"targets": [
{
"application": {
"filter": ""
},
"datasource": {
"type": "prometheus",
"uid": "aehf7d1qq6xa8c"
},
"expr": "irate(windows_logical_disk_read_bytes_total{job=~\"$job\",instance=~\"$instance\"}[5m])\r",
"format": "time_series",
"functions": [],
"group": {
"filter": ""
},
"hide": false,
"host": {
"filter": ""
},
"intervalFactor": 1,
"item": {
"filter": ""
},
"legendFormat": "read {{volume}}",
"metric": "mysql_global_status_questions",
"mode": 0,
"options": {
"showDisabledItems": false
},
"refId": "A",
"step": 20
},
{
"application": {
"filter": ""
},
"datasource": {
"type": "prometheus",
"uid": "aehf7d1qq6xa8c"
},
"expr": "irate(windows_logical_disk_write_bytes_total{job=~\"$job\",instance=~\"$instance\"}[5m])\r",
"format": "time_series",
"functions": [],
"group": {
"filter": ""
},
"hide": false,
"host": {
"filter": ""
},
"intervalFactor": 1,
"item": {
"filter": ""
},
"legendFormat": "write {{volume}}",
"metric": "mysql_global_status_questions",
"mode": 0,
"options": {
"showDisabledItems": false
},
"refId": "B",
"step": 20
}
],
"title": "Disk read/write",
"type": "timeseries"
},
{
"datasource": {
"type": "prometheus",
"uid": "aehf7d1qq6xa8c"
},
"fieldConfig": {
"defaults": {
"color": {
"mode": "palette-classic"
},
"custom": {
"axisBorderShow": false,
"axisCenteredZero": false,
"axisColorMode": "text",
"axisLabel": "",
"axisPlacement": "auto",
"barAlignment": 0,
"barWidthFactor": 0.6,
"drawStyle": "line",
"fillOpacity": 10,
"gradientMode": "none",
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
},
"insertNulls": false,
"lineInterpolation": "linear",
"lineWidth": 1,
"pointSize": 5,
"scaleDistribution": {
"type": "linear"
},
"showPoints": "never",
"spanNulls": false,
"stacking": {
"group": "A",
"mode": "none"
},
"thresholdsStyle": {
"mode": "off"
}
},
"links": [],
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green"
},
{
"color": "red",
"value": 80
}
]
},
"unit": "none"
},
"overrides": []
},
"gridPos": {
"h": 6,
"w": 6,
"x": 16,
"y": 30
},
"id": 12,
"options": {
"legend": {
"calcs": [
"lastNotNull"
],
"displayMode": "list",
"placement": "bottom",
"showLegend": true
},
"tooltip": {
"hideZeros": false,
"mode": "single",
"sort": "none"
}
},
"pluginVersion": "11.6.0",
"targets": [
{
"application": {
"filter": ""
},
"datasource": {
"type": "prometheus",
"uid": "aehf7d1qq6xa8c"
},
"expr": "windows_system_threads{job=~\"$job\",instance=~\"$instance\"}",
"format": "time_series",
"functions": [],
"group": {
"filter": ""
},
"hide": false,
"host": {
"filter": ""
},
"interval": "",
"intervalFactor": 1,
"item": {
"filter": ""
},
"legendFormat": "system_threads",
"metric": "mysql_global_status_questions",
"mode": 0,
"options": {
"showDisabledItems": false
},
"refId": "A",
"step": 20
}
],
"title": "system_threads",
"type": "timeseries"
},
{
"datasource": {
"type": "prometheus",
"uid": "aehf7d1qq6xa8c"
},
"fieldConfig": {
"defaults": {
"color": {
"mode": "palette-classic"
},
"custom": {
"axisBorderShow": false,
"axisCenteredZero": false,
"axisColorMode": "text",
"axisLabel": "",
"axisPlacement": "auto",
"barAlignment": 0,
"barWidthFactor": 0.6,
"drawStyle": "line",
"fillOpacity": 10,
"gradientMode": "none",
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
},
"insertNulls": false,
"lineInterpolation": "linear",
"lineWidth": 1,
"pointSize": 5,
"scaleDistribution": {
"type": "linear"
},
"showPoints": "never",
"spanNulls": false,
"stacking": {
"group": "A",
"mode": "none"
},
"thresholdsStyle": {
"mode": "off"
}
},
"links": [],
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green"
},
{
"color": "red",
"value": 80
}
]
},
"unit": "short"
},
"overrides": []
},
"gridPos": {
"h": 6,
"w": 6,
"x": 0,
"y": 36
},
"id": 13,
"options": {
"legend": {
"calcs": [
"lastNotNull",
"max"
],
"displayMode": "list",
"placement": "bottom",
"showLegend": true
},
"tooltip": {
"hideZeros": false,
"mode": "single",
"sort": "none"
}
},
"pluginVersion": "11.6.0",
"targets": [
{
"application": {
"filter": ""
},
"datasource": {
"type": "prometheus",
"uid": "aehf7d1qq6xa8c"
},
"expr": "irate(windows_system_exception_dispatches_total{job=~\"$job\",instance=~\"$instance\"}[5m])",
"format": "time_series",
"functions": [],
"group": {
"filter": ""
},
"hide": false,
"host": {
"filter": ""
},
"interval": "",
"intervalFactor": 1,
"item": {
"filter": ""
},
"legendFormat": "exceptions",
"metric": "mysql_global_status_questions",
"mode": 0,
"options": {
"showDisabledItems": false
},
"refId": "A",
"step": 20
}
],
"title": "System exception dispatches",
"type": "timeseries"
},
{
"datasource": {
"type": "prometheus",
"uid": "aehf7d1qq6xa8c"
},
"fieldConfig": {
"defaults": {
"color": {
"mode": "palette-classic"
},
"custom": {
"axisBorderShow": false,
"axisCenteredZero": false,
"axisColorMode": "text",
"axisLabel": "",
"axisPlacement": "auto",
"barAlignment": 0,
"barWidthFactor": 0.6,
"drawStyle": "line",
"fillOpacity": 10,
"gradientMode": "none",
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
},
"insertNulls": false,
"lineInterpolation": "linear",
"lineWidth": 1,
"pointSize": 5,
"scaleDistribution": {
"type": "linear"
},
"showPoints": "never",
"spanNulls": false,
"stacking": {
"group": "A",
"mode": "none"
},
"thresholdsStyle": {
"mode": "off"
}
},
"links": [],
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green"
},
{
"color": "red",
"value": 80
}
]
},
"unit": "pps"
},
"overrides": []
},
"gridPos": {
"h": 6,
"w": 6,
"x": 6,
"y": 36
},
"id": 10,
"options": {
"legend": {
"calcs": [
"lastNotNull"
],
"displayMode": "list",
"placement": "bottom",
"showLegend": true
},
"tooltip": {
"hideZeros": false,
"mode": "multi",
"sort": "desc"
}
},
"pluginVersion": "11.6.0",
"targets": [
{
"application": {
"filter": ""
},
"datasource": {
"type": "prometheus",
"uid": "aehf7d1qq6xa8c"
},
"expr": "irate(windows_net_packets_outbound_discarded{job=~\"$job\",instance=~\"$instance\", nic!~'isatap.*|VPN.*'}[5m]) + irate(windows_net_packets_outbound_errors{job=~\"$job\",instance=~\"$instance\"}[5m])",
"format": "time_series",
"functions": [],
"group": {
"filter": ""
},
"hide": false,
"host": {
"filter": ""
},
"interval": "",
"intervalFactor": 1,
"item": {
"filter": ""
},
"legendFormat": "outbound",
"metric": "mysql_global_status_questions",
"mode": 0,
"options": {
"showDisabledItems": false
},
"refId": "B",
"step": 15
},
{
"application": {
"filter": ""
},
"datasource": {
"type": "prometheus",
"uid": "aehf7d1qq6xa8c"
},
"expr": "irate(windows_net_packets_received_discarded{job=~\"$job\",instance=~\"$instance\", nic!~'isatap.*|VPN.*'}[5m]) + irate(windows_net_packets_received_errors{job=~\"$job\",instance=~\"$instance\"}[5m])",
"format": "time_series",
"functions": [],
"group": {
"filter": ""
},
"hide": false,
"host": {
"filter": ""
},
"interval": "",
"intervalFactor": 1,
"item": {
"filter": ""
},
"legendFormat": "received",
"metric": "mysql_global_status_questions",
"mode": 0,
"options": {
"showDisabledItems": false
},
"refId": "A",
"step": 15
}
],
"title": "Network discarded/error packets",
"type": "timeseries"
},
{
"datasource": {
"type": "prometheus",
"uid": "aehf7d1qq6xa8c"
},
"fieldConfig": {
"defaults": {
"color": {
"mode": "palette-classic"
},
"custom": {
"axisBorderShow": false,
"axisCenteredZero": false,
"axisColorMode": "text",
"axisLabel": "",
"axisPlacement": "auto",
"barAlignment": 0,
"barWidthFactor": 0.6,
"drawStyle": "bars",
"fillOpacity": 100,
"gradientMode": "none",
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
},
"insertNulls": false,
"lineInterpolation": "linear",
"lineWidth": 1,
"pointSize": 5,
"scaleDistribution": {
"type": "linear"
},
"showPoints": "never",
"spanNulls": false,
"stacking": {
"group": "A",
"mode": "normal"
},
"thresholdsStyle": {
"mode": "off"
}
},
"links": [],
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green"
},
{
"color": "red",
"value": 80
}
]
},
"unit": "percent"
},
"overrides": []
},
"gridPos": {
"h": 6,
"w": 6,
"x": 12,
"y": 36
},
"id": 29,
"options": {
"legend": {
"calcs": [
"mean",
"max",
"min"
],
"displayMode": "list",
"placement": "bottom",
"showLegend": false
},
"tooltip": {
"hideZeros": false,
"mode": "multi",
"sort": "none"
}
},
"pluginVersion": "11.6.0",
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "aehf7d1qq6xa8c"
},
"expr": "(irate(windows_net_bytes_total{job=~\"$job\",instance=~\"$instance\",nic!~'isatap.*|VPN.*'}[5m]) * 8 / windows_net_current_bandwidth{job=~\"$job\",instance=~\"$instance\",nic!~'isatap.*|VPN.*'}) * 100",
"legendFormat": "{{nic}}",
"refId": "A"
}
],
"title": "Network usage rate",
"type": "timeseries"
},
{
"datasource": {
"type": "prometheus",
"uid": "aehf7d1qq6xa8c"
},
"fieldConfig": {
"defaults": {
"color": {
"mode": "palette-classic"
},
"custom": {
"axisBorderShow": false,
"axisCenteredZero": false,
"axisColorMode": "text",
"axisLabel": "",
"axisPlacement": "auto",
"barAlignment": 0,
"barWidthFactor": 0.6,
"drawStyle": "line",
"fillOpacity": 10,
"gradientMode": "none",
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
},
"insertNulls": false,
"lineInterpolation": "linear",
"lineWidth": 2,
"pointSize": 5,
"scaleDistribution": {
"type": "linear"
},
"showPoints": "never",
"spanNulls": false,
"stacking": {
"group": "A",
"mode": "none"
},
"thresholdsStyle": {
"mode": "off"
}
},
"decimals": 0,
"links": [],
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green"
},
{
"color": "red",
"value": 80
}
]
},
"unit": "short"
},
"overrides": [
{
"matcher": {
"id": "byName",
"options": "Number of processes"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "#B877D9",
"mode": "fixed"
}
}
]
}
]
},
"gridPos": {
"h": 6,
"w": 8,
"x": 0,
"y": 42
},
"id": 27,
"options": {
"legend": {
"calcs": [
"lastNotNull"
],
"displayMode": "list",
"placement": "right",
"showLegend": false
},
"tooltip": {
"hideZeros": false,
"mode": "multi",
"sort": "none"
}
},
"pluginVersion": "11.6.0",
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "aehf7d1qq6xa8c"
},
"expr": "windows_os_processes{job=~\"$job\",instance=~\"$instance\"}",
"instant": false,
"interval": "",
"legendFormat": "Number of processes",
"refId": "A"
}
],
"title": "Number of processes",
"type": "timeseries"
}
],
"preload": false,
"refresh": "",
"schemaVersion": 41,
"tags": [
"Prometheus",
"windows_exporter"
],
"templating": {
"list": [
{
"current": {
"text": "integrations/windows",
"value": "integrations/windows"
},
"datasource": "aehf7d1qq6xa8c",
"definition": "label_values(windows_cs_hostname, job)",
"includeAll": false,
"label": "JOB",
"name": "job",
"options": [],
"query": "label_values(windows_cs_hostname, job)",
"refresh": 1,
"regex": "",
"sort": 1,
"type": "query"
},
{
"current": {
"text": "All",
"value": "$__all"
},
"datasource": "aehf7d1qq6xa8c",
"definition": "label_values(windows_cs_hostname{job=~\"$job\"}, hostname)",
"includeAll": true,
"label": "Host name",
"name": "hostname",
"options": [],
"query": "label_values(windows_cs_hostname{job=~\"$job\"}, hostname)",
"refresh": 1,
"regex": "",
"sort": 5,
"type": "query"
},
{
"current": {
"text": "2002-Alloy-1",
"value": "2002-Alloy-1"
},
"datasource": "aehf7d1qq6xa8c",
"definition": "label_values(windows_cs_hostname{job=~\"$job\",hostname=~\"$hostname\"}, instance)",
"includeAll": false,
"label": "instance",
"name": "instance",
"options": [],
"query": "label_values(windows_cs_hostname{job=~\"$job\",hostname=~\"$hostname\"}, instance)",
"refresh": 1,
"regex": "",
"sort": 5,
"type": "query"
},
{
"current": {
"text": "2002-Alloy-1",
"value": "2002-Alloy-1"
},
"datasource": "aehf7d1qq6xa8c",
"definition": "label_values(windows_cs_hostname{job=~\"$job\",instance=~\"$instance\"}, hostname)",
"hide": 2,
"includeAll": false,
"label": "Display hostname in use",
"name": "show_hostname",
"options": [],
"query": "label_values(windows_cs_hostname{job=~\"$job\",instance=~\"$instance\"}, hostname)",
"refresh": 1,
"regex": "",
"type": "query"
}
]
},
"time": {
"from": "now-30m",
"to": "now"
},
"timepicker": {
"refresh_intervals": [
"10s",
"30s",
"1m",
"5m",
"15m",
"30m",
"1h",
"2h",
"1d"
]
},
"timezone": "",
"title": "WS22 - Monitoring",
"uid": "Kdh0OoSGz",
"version": 14
}