目录
前言
Grafana选择监控仪表盘
访问地址：https://grafana.com/dashboards --- serch框输入windows ---- 选择心仪模板 (注意模板所支持的数据源为prometheus) ----- 进行 ID 或者JOSN文件两种方式导入。
自定义简约型-只显示资源总览，各个主机详情
监控仪表盘JSON数据
{ "annotations": { "list": [ { "builtIn": 1, "datasource": "-- Grafana --", "enable": true, "hide": true, "iconColor": "rgba(0, 211, 255, 1)", "name": "Annotations & Alerts", "type": "dashboard" } ] }, "description": "Windows的Prometheus监控看板展示，增加了资源汇总展示，优化了明细展示。更新支持windows_exporter 0.13.0。", "editable": true, "gnetId": 10467, "graphTooltip": 1, "id": 1, "iteration": 1605338442536, "links": [ { "asDropdown": true, "icon": "external link", "tags": [], "targetBlank": true, "type": "dashboards" } ], "panels": [ { "collapsed": false, "datasource": "Prometheus", "gridPos": { "h": 1, "w": 24, "x": 0, "y": 0 }, "id": 41, "panels": [], "title": "资源监控", "type": "row" }, { "columns": [], "datasource": "Prometheus", "fieldConfig": { "defaults": { "custom": {} }, "overrides": [] }, "fontSize": "90%", "gridPos": { "h": 6, "w": 24, "x": 0, "y": 1 }, "id": 45, "pageSize": null, "showHeader": true, "sort": { "col": 0, "desc": true }, "styles": [ { "alias": "操作系统", "align": "auto", "colorMode": null, "colors": [ "rgba(245, 54, 54, 0.9)", "rgba(237, 129, 40, 0.89)", "rgba(50, 172, 45, 0.97)" ], "dateFormat": "YYYY-MM-DD HH:mm:ss", "decimals": 2, "mappingType": 1, "pattern": "product", "preserveFormat": false, "sanitize": false, "thresholds": [], "type": "string", "unit": "short", "valueMaps": [] }, { "alias": "主机名称", "align": "auto", "colorMode": null, "colors": [ "rgba(245, 54, 54, 0.9)", "rgba(237, 129, 40, 0.89)", "rgba(50, 172, 45, 0.97)" ], "dateFormat": "YYYY-MM-DD HH:mm:ss", "decimals": 2, "link": false, "linkTooltip": "", "linkUrl": "", "mappingType": 1, "pattern": "hostname", "preserveFormat": false, "thresholds": [], "type": "string", "unit": "short" }, { "alias": "主机信息", "align": "auto", "colorMode": null, "colors": [ "rgba(245, 54, 54, 0.9)", "rgba(237, 129, 40, 0.89)", "rgba(50, 172, 45, 0.97)" ], "dateFormat": "YYYY-MM-DD HH:mm:ss", "decimals": 2, "link": false, "linkTargetBlank": false, "linkTooltip": "${__cell_4}", "linkUrl": "/d/Kdh0OoSGz/?var-job=${__cell_5}&var-hostname=All&var-instance=${__cell_4}", "mappingType": 1, "pattern": "instance", "thresholds": [], "type": "string", "unit": "short" }, { "alias": "CPU核数", "align": "auto", "colorMode": null, "colors": [ "rgba(245, 54, 54, 0.9)", "rgba(237, 129, 40, 0.89)", "rgba(50, 172, 45, 0.97)" ], "dateFormat": "YYYY-MM-DD HH:mm:ss", "decimals": 2, "link": false, "mappingType": 1, "pattern": "Value #B", "thresholds": [], "type": "string", "unit": "short" }, { "alias": "总内存", "align": "auto", "colorMode": null, "colors": [ "rgba(245, 54, 54, 0.9)", "rgba(237, 129, 40, 0.89)", "rgba(50, 172, 45, 0.97)" ], "dateFormat": "YYYY-MM-DD HH:mm:ss", "decimals": null, "mappingType": 1, "pattern": "Value #C", "thresholds": [], "type": "number", "unit": "bytes" }, { "alias": "运行时间", "align": "auto", "colorMode": "cell", "colors": [ "rgba(245, 54, 54, 0.9)", "rgba(237, 129, 40, 0.89)", "rgba(50, 172, 45, 0.97)" ], "dateFormat": "YYYY-MM-DD HH:mm:ss", "decimals": null, "mappingType": 1, "pattern": "Value #D", "thresholds": [ "259200", "432000" ], "type": "number", "unit": "s" }, { "alias": "C盘使用率", "align": "auto", "colorMode": "cell", "colors": [ "rgba(50, 172, 45, 0.97)", "rgba(237, 129, 40, 0.89)", "rgba(245, 54, 54, 0.9)" ], "dateFormat": "YYYY-MM-DD HH:mm:ss", "decimals": 2, "mappingType": 1, "pattern": "Value #E", "thresholds": [ "60", "80" ], "type": "number", "unit": "percentunit" }, { "alias": "进程数", "align": "auto", "colorMode": null, "colors": [ "rgba(245, 54, 54, 0.9)", "rgba(237, 129, 40, 0.89)", "rgba(50, 172, 45, 0.97)" ], "dateFormat": "YYYY-MM-DD HH:mm:ss", "decimals": 2, "link": false, "mappingType": 1, "pattern": "Value #G", "thresholds": [], "type": "string", "unit": "short" }, { "alias": "运行服务", "align": "auto", "colorMode": null, "colors": [ "rgba(245, 54, 54, 0.9)", "rgba(237, 129, 40, 0.89)", "rgba(50, 172, 45, 0.97)" ], "dateFormat": "YYYY-MM-DD HH:mm:ss", "decimals": 2, "mappingType": 1, "pattern": "Value #H", "thresholds": [], "type": "string", "unit": "short" }, { "alias": "CPU使用率", "align": "auto", "colorMode": "cell", "colors": [ "rgba(50, 172, 45, 0.97)", "rgba(237, 129, 40, 0.89)", "rgba(245, 54, 54, 0.9)" ], "dateFormat": "YYYY-MM-DD HH:mm:ss", "decimals": 2, "mappingType": 1, "pattern": "Value #I", "thresholds": [ "50", "70" ], "type": "number", "unit": "percent" }, { "alias": "内存使用率", "align": "auto", "colorMode": "cell", "colors": [ "rgba(50, 172, 45, 0.97)", "rgba(237, 129, 40, 0.89)", "rgba(245, 54, 54, 0.9)" ], "dateFormat": "YYYY-MM-DD HH:mm:ss", "decimals": 2, "mappingType": 1, "pattern": "Value #J", "thresholds": [ "60", "80" ], "type": "number", "unit": "percent" }, { "alias": "CPU频率", "align": "auto", "colorMode": null, "colors": [ "rgba(245, 54, 54, 0.9)", "rgba(237, 129, 40, 0.89)", "rgba(50, 172, 45, 0.97)" ], "dateFormat": "YYYY-MM-DD HH:mm:ss", "decimals": 2, "mappingType": 1, "pattern": "Value #K", "thresholds": [], "type": "number", "unit": "rothz" }, { "alias": "", "align": "right", "colorMode": null, "colors": [ "rgba(245, 54, 54, 0.9)", "rgba(237, 129, 40, 0.89)", "rgba(50, 172, 45, 0.97)" ], "decimals": 2, "pattern": "/.*/", "thresholds": [], "type": "hidden", "unit": "short" } ], "targets": [ { "expr": "windows_os_info * on(instance) group_right(product) windows_cs_hostname", "format": "table", "instant": true, "interval": "", "legendFormat": "主机名", "refId": "A" }, { "expr": "time() - windows_system_system_up_time", "format": "table", "instant": true, "interval": "", "legendFormat": "运行时间", "refId": "D" }, { "expr": "windows_cs_logical_processors - 0", "format": "table", "instant": true, "interval": "", "legendFormat": "", "refId": "B" }, { "expr": "avg by (instance) (windows_cpu_core_frequency_mhz)", "format": "table", "instant": true, "interval": "", "legendFormat": "", "refId": "K" }, { "expr": "100 - (avg by (instance) (irate(windows_cpu_time_total{mode=\"idle\"}[2m])) * 100)", "format": "table", "instant": true, "interval": "", "legendFormat": "CPU使用率", "refId": "I" }, { "expr": "windows_cs_physical_memory_bytes - 0", "format": "table", "instant": true, "interval": "", "legendFormat": "总内存", "refId": "C" }, { "expr": "100 - 100 * windows_os_physical_memory_free_bytes / windows_cs_physical_memory_bytes", "format": "table", "instant": true, "interval": "", "legendFormat": "内存使用率", "refId": "J" }, { "expr": "1 - (windows_logical_disk_free_bytes{volume=~\"C:\"}/windows_logical_disk_size_bytes{volume=~\"C:\"})", "format": "table", "instant": true, "interval": "", "legendFormat": "c盘使用率", "refId": "E" }, { "expr": "windows_os_processes", "format": "table", "instant": true, "interval": "", "legendFormat": "进程数", "refId": "G" }, { "expr": "sum by (instance) (windows_service_state{state=~\"running\"})", "format": "table", "instant": true, "interval": "", "legendFormat": "运行服务", "refId": "H" } ], "timeFrom": null, "timeShift": null, "title": "服务器资源总览", "transform": "table", "type": "table-old" }, { "aliasColors": {}, "bars": false, "dashLength": 10, "dashes": false, "datasource": "Prometheus", "decimals": 1, "fieldConfig": { "defaults": { "custom": {} }, "overrides": [] }, "fill": 1, "fillGradient": 0, "gridPos": { "h": 6, "w": 8, "x": 0, "y": 7 }, "hiddenSeries": false, "id": 47, "legend": { "alignAsTable": true, "avg": true, "current": true, "max": true, "min": false, "rightSide": true, "show": false, "sort": "current", "sortDesc": false, "total": false, "values": true }, "lines": true, "linewidth": 1, "links": [], "nullPointMode": "null", "paceLength": 10, "percentage": false, "pluginVersion": "7.1.5", "pointradius": 5, "points": false, "renderer": "flot", "seriesOverrides": [], "spaceLength": 10, "stack": false, "steppedLine": false, "targets": [ { "expr": "100 - (avg by (instance) (irate(windows_cpu_time_total{mode=\"idle\"}[2m])) * 100)", "hide": false, "interval": "", "intervalFactor": 1, "legendFormat": "{{instance}}", "refId": "B" } ], "thresholds": [], "timeFrom": null, "timeRegions": [], "timeShift": null, "title": "各主机CPU使用率", "tooltip": { "shared": true, "sort": 2, "value_type": "cumulative" }, "type": "graph", "xaxis": { "buckets": null, "mode": "time", "name": null, "show": true, "values": [] }, "yaxes": [ { "format": "percent", "label": null, "logBase": 1, "max": null, "min": "0", "show": true }, { "format": "short", "label": null, "logBase": 1, "max": null, "min": null, "show": false } ], "yaxis": { "align": false, "alignLevel": null } }, { "aliasColors": {}, "bars": false, "dashLength": 10, "dashes": false, "datasource": "Prometheus", "decimals": 1, "fieldConfig": { "defaults": { "custom": {} }, "overrides": [] }, "fill": 1, "fillGradient": 0, "gridPos": { "h": 6, "w": 8, "x": 8, "y": 7 }, "hiddenSeries": false, "id": 56, "legend": { "alignAsTable": true, "avg": true, "current": true, "max": true, "min": false, "rightSide": true, "show": false, "sort": "current", "sortDesc": false, "total": false, "values": true }, "lines": true, "linewidth": 1, "links": [], "nullPointMode": "null", "paceLength": 10, "percentage": false, "pluginVersion": "7.1.5", "pointradius": 5, "points": false, "renderer": "flot", "seriesOverrides": [], "spaceLength": 10, "stack": false, "steppedLine": false, "targets": [ { "expr": "utilization_gpu", "hide": false, "interval": "", "intervalFactor": 1, "legendFormat": "{{instance}}_GPU", "refId": "B" } ], "thresholds": [], "timeFrom": null, "timeRegions": [], "timeShift": null, "title": "各主机GPU使用率", "tooltip": { "shared": true, "sort": 2, "value_type": "cumulative" }, "type": "graph", "xaxis": { "buckets": null, "mode": "time", "name": null, "show": true, "values": [] }, "yaxes": [ { "format": "percent", "label": null, "logBase": 1, "max": null, "min": "0", "show": true }, { "format": "short", "label": null, "logBase": 1, "max": null, "min": null, "show": false } ], "yaxis": { "align": false, "alignLevel": null } }, { "aliasColors": { "Free Physical memory": "semi-dark-green", "Free physical memory": "semi-dark-green", "Free virtual memory": "super-light-blue", "Physical memory": "dark-red", "Virtual memory": "dark-blue" }, "bars": false, "dashLength": 10, "dashes": false, "datasource": "Prometheus", "fieldConfig": { "defaults": { "custom": {} }, "overrides": [] }, "fill": 1, "fillGradient": 1, "gridPos": { "h": 6, "w": 8, "x": 16, "y": 7 }, "hiddenSeries": false, "hideTimeOverride": false, "id": 49, "legend": { "alignAsTable": true, "avg": true, "current": true, "max": true, "min": false, "rightSide": true, "show": false, "sort": "current", "sortDesc": true, "total": false, "values": true }, "lines": true, "linewidth": 2, "links": [], "nullPointMode": "null", "percentage": false, "pluginVersion": "7.1.5", "pointradius": 5, "points": false, "renderer": "flot", "seriesOverrides": [ { "alias": "/.*Physical.*/", "linewidth": 3 } ], "spaceLength": 10, "stack": false, "steppedLine": false, "targets": [ { "expr": "100.0 - 100 * windows_os_physical_memory_free_bytes / windows_cs_physical_memory_bytes", "instant": false, "interval": "", "legendFormat": "{{instance}}", "refId": "A" } ], "thresholds": [], "timeFrom": null, "timeRegions": [], "timeShift": null, "title": "各主机内存使用率", "tooltip": { "shared": true, "sort": 0, "value_type": "individual" }, "type": "graph", "xaxis": { "buckets": null, "mode": "time", "name": null, "show": true, "values": [] }, "yaxes": [ { "format": "percent", "label": null, "logBase": 1, "max": null, "min": null, "show": true }, { "format": "short", "label": null, "logBase": 1, "max": null, "min": null, "show": false } ], "yaxis": { "align": false, "alignLevel": null } }, { "aliasColors": {}, "bars": false, "dashLength": 10, "dashes": false, "datasource": "Prometheus", "fieldConfig": { "defaults": { "custom": {} }, "overrides": [] }, "fill": 1, "fillGradient": 0, "gridPos": { "h": 6, "w": 8, "x": 0, "y": 13 }, "hiddenSeries": false, "hideTimeOverride": false, "id": 53, "legend": { "alignAsTable": true, "avg": true, "current": true, "max": true, "min": false, "rightSide": true, "show": false, "sort": "max", "sortDesc": true, "total": false, "values": true }, "lines": true, "linewidth": 1, "links": [], "nullPointMode": "null as zero", "percentage": false, "pluginVersion": "7.1.5", "pointradius": 5, "points": false, "renderer": "flot", "seriesOverrides": [], "spaceLength": 10, "stack": false, "steppedLine": false, "targets": [ { "application": { "filter": "" }, "expr": "max by (instance) (irate(windows_net_bytes_sent_total{nic!~'isatap.*|VPN.*'}[2m]))*8", "format": "time_series", "functions": [], "group": { "filter": "" }, "hide": false, "host": { "filter": "" }, "interval": "", "intervalFactor": 1, "item": { "filter": "" }, "legendFormat": "{{instance}}_上传", "metric": "mysql_global_status_questions", "mode": 0, "options": { "showDisabledItems": false }, "refId": "B", "step": 10 }, { "application": { "filter": "" }, "expr": "-max by (instance) (irate(windows_net_bytes_received_total{nic!~'isatap.*|VPN.*'}[2m]))*8", "format": "time_series", "functions": [], "group": { "filter": "" }, "hide": false, "host": { "filter": "" }, "interval": "", "intervalFactor": 1, "item": { "filter": "" }, "legendFormat": "{{instance}}_下载", "metric": "mysql_global_status_questions", "mode": 0, "options": { "showDisabledItems": false }, "refId": "A", "step": 10 } ], "thresholds": [], "timeFrom": null, "timeRegions": [], "timeShift": null, "title": "各主机网络详情", "tooltip": { "shared": true, "sort": 2, "value_type": "individual" }, "type": "graph", "xaxis": { "buckets": null, "mode": "time", "name": null, "show": true, "values": [] }, "yaxes": [ { "format": "bps", "label": "下载 上传", "logBase": 1, "max": null, "min": null, "show": true }, { "format": "short", "label": null, "logBase": 1, "max": null, "min": null, "show": false } ], "yaxis": { "align": false, "alignLevel": null } }, { "aliasColors": {}, "bars": false, "dashLength": 10, "dashes": false, "datasource": "Prometheus", "fieldConfig": { "defaults": { "custom": {} }, "overrides": [] }, "fill": 2, "fillGradient": 0, "gridPos": { "h": 6, "w": 8, "x": 8, "y": 13 }, "hiddenSeries": false, "hideTimeOverride": false, "id": 51, "legend": { "alignAsTable": true, "avg": true, "current": true, "max": true, "min": false, "rightSide": true, "show": false, "sort": "max", "sortDesc": true, "total": false, "values": true }, "lines": true, "linewidth": 1, "links": [], "nullPointMode": "null", "percentage": false, "pluginVersion": "7.1.5", "pointradius": 5, "points": false, "renderer": "flot", "seriesOverrides": [], "spaceLength": 10, "stack": false, "steppedLine": false, "targets": [ { "application": { "filter": "" }, "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}}_读取", "metric": "mysql_global_status_questions", "mode": 0, "options": { "showDisabledItems": false }, "refId": "A", "step": 20 }, { "application": { "filter": "" }, "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}}_写入", "metric": "mysql_global_status_questions", "mode": 0, "options": { "showDisabledItems": false }, "refId": "B", "step": 20 } ], "thresholds": [], "timeFrom": null, "timeRegions": [], "timeShift": null, "title": "各主机磁盘读写详情", "tooltip": { "shared": true, "sort": 2, "value_type": "individual" }, "type": "graph", "xaxis": { "buckets": null, "mode": "time", "name": null, "show": true, "values": [] }, "yaxes": [ { "format": "Bps", "label": "读取 写入", "logBase": 1, "max": null, "min": null, "show": true }, { "decimals": null, "format": "iops", "label": "", "logBase": 1, "max": null, "min": null, "show": false } ], "yaxis": { "align": false, "alignLevel": null } }, { "aliasColors": {}, "bars": false, "dashLength": 10, "dashes": false, "datasource": "Prometheus", "fieldConfig": { "defaults": { "custom": {} }, "overrides": [] }, "fill": 1, "fillGradient": 0, "gridPos": { "h": 6, "w": 8, "x": 16, "y": 13 }, "hiddenSeries": false, "hideTimeOverride": false, "id": 55, "legend": { "alignAsTable": true, "avg": true, "current": true, "max": true, "min": false, "rightSide": true, "show": false, "sort": "current", "sortDesc": true, "total": false, "values": true }, "lines": true, "linewidth": 1, "links": [], "nullPointMode": "null as zero", "percentage": false, "pluginVersion": "7.1.5", "pointradius": 5, "points": false, "renderer": "flot", "seriesOverrides": [], "spaceLength": 10, "stack": false, "steppedLine": false, "targets": [ { "application": { "filter": "" }, "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}}_读取", "metric": "mysql_global_status_questions", "mode": 0, "options": { "showDisabledItems": false }, "refId": "B", "step": 20 }, { "application": { "filter": "" }, "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}}_写入", "metric": "mysql_global_status_questions", "mode": 0, "options": { "showDisabledItems": false }, "refId": "C", "step": 20 } ], "thresholds": [], "timeFrom": null, "timeRegions": [], "timeShift": null, "title": "各主机磁盘IO详情", "tooltip": { "shared": true, "sort": 2, "value_type": "individual" }, "type": "graph", "xaxis": { "buckets": null, "mode": "time", "name": null, "show": true, "values": [] }, "yaxes": [ { "format": "iops", "label": "读取 写入", "logBase": 1, "max": null, "min": null, "show": true }, { "format": "short", "label": null, "logBase": 1, "max": null, "min": null, "show": false } ], "yaxis": { "align": false, "alignLevel": null } } ], "refresh": false, "schemaVersion": 26, "style": "dark", "tags": [ "Prometheus", "windows_exporter" ], "templating": { "list": [ { "allValue": null, "current": { "selected": false, "text": "Win-76", "value": "Win-76" }, "datasource": "Prometheus", "definition": "label_values(windows_cs_hostname, job)", "hide": 0, "includeAll": false, "label": "JOB", "multi": false, "name": "job", "options": [], "query": "label_values(windows_cs_hostname, job)", "refresh": 1, "regex": "", "skipUrlSync": false, "sort": 1, "tagValuesQuery": "", "tags": [], "tagsQuery": "", "type": "query", "useTags": false }, { "allValue": null, "current": { "selected": false, "text": "All", "value": "$__all" }, "datasource": "Prometheus", "definition": "label_values(windows_cs_hostname{job=~\"$job\"}, hostname)", "hide": 0, "includeAll": true, "label": "主机名", "multi": false, "name": "hostname", "options": [], "query": "label_values(windows_cs_hostname{job=~\"$job\"}, hostname)", "refresh": 1, "regex": "", "skipUrlSync": false, "sort": 5, "tagValuesQuery": "", "tags": [], "tagsQuery": "", "type": "query", "useTags": false }, { "allValue": null, "current": { "selected": false, "text": "10.0.50.76:9182", "value": "10.0.50.76:9182" }, "datasource": "Prometheus", "definition": "label_values(windows_cs_hostname{job=~\"$job\",hostname=~\"$hostname\"}, instance)", "hide": 0, "includeAll": false, "label": "instance", "multi": false, "name": "instance", "options": [], "query": "label_values(windows_cs_hostname{job=~\"$job\",hostname=~\"$hostname\"}, instance)", "refresh": 1, "regex": "", "skipUrlSync": false, "sort": 5, "tagValuesQuery": "", "tags": [], "tagsQuery": "", "type": "query", "useTags": false }, { "allValue": null, "current": { "selected": false, "text": "wangyanfei", "value": "wangyanfei" }, "datasource": "Prometheus", "definition": "label_values(windows_cs_hostname{job=~\"$job\",instance=~\"$instance\"}, hostname)", "hide": 2, "includeAll": false, "label": "展示使用的主机名", "multi": false, "name": "show_hostname", "options": [], "query": "label_values(windows_cs_hostname{job=~\"$job\",instance=~\"$instance\"}, hostname)", "refresh": 1, "regex": "", "skipUrlSync": false, "sort": 0, "tagValuesQuery": "", "tags": [], "tagsQuery": "", "type": "query", "useTags": false } ] }, "time": { "from": "now-5m", "to": "now" }, "timepicker": { "refresh_intervals": [ "10s", "30s", "1m", "5m", "15m", "30m", "1h", "2h", "1d" ], "time_options": [ "5m", "15m", "1h", "6h", "12h", "24h", "2d", "7d", "30d" ] }, "timezone": "", "title": "Webvr", "uid": "Kdh0OoSGz", "version": 17 }
