App Server & Repository List
A table of app servers and message repository hosts.
JSON
{
"__inputs": [
{
"name": "DS_PROMETHEUS",
"label": "Prometheus",
"description": "",
"type": "datasource",
"pluginId": "prometheus",
"pluginName": "Prometheus"
}
],
"__elements": {},
"__requires": [
{
"type": "grafana",
"id": "grafana",
"name": "Grafana",
"version": "10.1.1"
},
{
"type": "datasource",
"id": "prometheus",
"name": "Prometheus",
"version": "1.0.0"
},
{
"type": "panel",
"id": "table",
"name": "Table",
"version": ""
}
],
"annotations": {
"list": [
{
"builtIn": 1,
"datasource": {
"type": "datasource",
"uid": "grafana"
},
"enable": true,
"hide": true,
"iconColor": "rgba(0, 211, 255, 1)",
"name": "Annotations & Alerts",
"target": {
"limit": 100,
"matchAny": false,
"tags": [],
"type": "dashboard"
},
"type": "dashboard"
}
]
},
"description": "",
"editable": true,
"fiscalYearStartMonth": 0,
"graphTooltip": 0,
"id": null,
"links": [],
"liveNow": false,
"panels": [
{
"datasource": {
"type": "prometheus",
"uid": "${DS_PROMETHEUS}"
},
"description": "",
"fieldConfig": {
"defaults": {
"color": {
"mode": "thresholds"
},
"custom": {
"align": "center",
"cellOptions": {
"type": "auto"
},
"filterable": true,
"inspect": false,
"minWidth": 50
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "#EAB839",
"value": 80
},
{
"color": "red",
"value": 90
}
]
}
},
"overrides": [
{
"matcher": {
"id": "byName",
"options": "CPU Usage"
},
"properties": [
{
"id": "custom.cellOptions",
"value": {
"mode": "gradient",
"type": "gauge"
}
},
{
"id": "unit",
"value": "percent"
},
{
"id": "max",
"value": 100
}
]
},
{
"matcher": {
"id": "byName",
"options": "Memory Usage"
},
"properties": [
{
"id": "custom.cellOptions",
"value": {
"mode": "gradient",
"type": "gauge"
}
},
{
"id": "unit",
"value": "percent"
},
{
"id": "max",
"value": 100
}
]
},
{
"matcher": {
"id": "byName",
"options": "Disk Usage"
},
"properties": [
{
"id": "unit",
"value": "percent"
},
{
"id": "custom.cellOptions",
"value": {
"mode": "gradient",
"type": "gauge"
}
},
{
"id": "max",
"value": 100
}
]
},
{
"matcher": {
"id": "byName",
"options": "Running"
},
"properties": [
{
"id": "custom.cellOptions",
"value": {
"type": "color-text"
}
},
{
"id": "thresholds",
"value": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
}
]
}
}
]
},
{
"matcher": {
"id": "byName",
"options": "Stopped"
},
"properties": [
{
"id": "custom.cellOptions",
"value": {
"type": "color-text"
}
},
{
"id": "thresholds",
"value": {
"mode": "absolute",
"steps": [
{
"color": "semi-dark-red",
"value": null
}
]
}
}
]
},
{
"matcher": {
"id": "byName",
"options": "Invalid"
},
"properties": [
{
"id": "custom.cellOptions",
"value": {
"mode": "basic",
"type": "color-background"
}
},
{
"id": "thresholds",
"value": {
"mode": "absolute",
"steps": [
{
"color": "transparent",
"value": null
},
{
"color": "dark-orange",
"value": 1
}
]
}
}
]
},
{
"matcher": {
"id": "byName",
"options": "Msg Count"
},
"properties": [
{
"id": "unit",
"value": "locale"
}
]
},
{
"matcher": {
"id": "byName",
"options": "Errors (<30m)"
},
"properties": [
{
"id": "thresholds",
"value": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 1
}
]
}
}
]
},
{
"matcher": {
"id": "byName",
"options": "Oldest Q"
},
"properties": [
{
"id": "unit",
"value": "m"
}
]
},
{
"matcher": {
"id": "byName",
"options": "Server"
},
"properties": [
{
"id": "links",
"value": [
{
"targetBlank": true,
"title": "",
"url": "/d/4C7D94Q7k/connexion-general?refresh=${__interval}&var-instance=${__value.raw}"
}
]
},
{
"id": "custom.width",
"value": 164
}
]
}
]
},
"gridPos": {
"h": 7,
"w": 24,
"x": 0,
"y": 0
},
"id": 53,
"options": {
"cellHeight": "sm",
"footer": {
"countRows": false,
"fields": "",
"reducer": [
"sum"
],
"show": false
},
"showHeader": true,
"sortBy": [
{
"desc": true,
"displayName": "Server"
}
]
},
"pluginVersion": "10.1.1",
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "${DS_PROMETHEUS}"
},
"exemplar": false,
"expr": "connexion_system_cpu_memory_percent{Metric=\"cpu_percent_used\"}",
"format": "table",
"instant": true,
"interval": "",
"legendFormat": "",
"refId": "A"
},
{
"datasource": {
"type": "prometheus",
"uid": "${DS_PROMETHEUS}"
},
"exemplar": false,
"expr": "connexion_system_cpu_memory_percent{Metric=\"mem_percent_used\"}",
"format": "table",
"hide": false,
"instant": true,
"interval": "",
"legendFormat": "",
"refId": "B"
},
{
"datasource": {
"type": "prometheus",
"uid": "${DS_PROMETHEUS}"
},
"exemplar": false,
"expr": "connexion_system_drive_metrics{Metric=\"used_percent\"}",
"format": "table",
"hide": false,
"instant": true,
"interval": "",
"legendFormat": "",
"refId": "C"
},
{
"datasource": {
"type": "prometheus",
"uid": "${DS_PROMETHEUS}"
},
"exemplar": false,
"expr": "count by (instance) (connexion_process_performance{Metric=\"cpu\"})",
"format": "table",
"hide": false,
"instant": true,
"interval": "",
"legendFormat": "",
"refId": "D"
},
{
"datasource": {
"type": "prometheus",
"uid": "${DS_PROMETHEUS}"
},
"exemplar": false,
"expr": "connexion_system_channel_state_counts{Status=\"Running\"}",
"format": "table",
"hide": false,
"instant": true,
"interval": "",
"legendFormat": "",
"refId": "E"
},
{
"datasource": {
"type": "prometheus",
"uid": "${DS_PROMETHEUS}"
},
"exemplar": false,
"expr": "connexion_system_channel_state_counts{Status=\"Stopped\"}",
"format": "table",
"hide": false,
"instant": true,
"interval": "",
"legendFormat": "",
"refId": "F"
},
{
"datasource": {
"type": "prometheus",
"uid": "${DS_PROMETHEUS}"
},
"exemplar": false,
"expr": "connexion_system_channel_state_counts{Status=\"Invalid\"}",
"format": "table",
"hide": false,
"instant": true,
"interval": "",
"legendFormat": "",
"refId": "G"
},
{
"datasource": {
"type": "prometheus",
"uid": "${DS_PROMETHEUS}"
},
"exemplar": false,
"expr": "connexion_system_message_counts{QueueType=\"Total\"}",
"format": "table",
"hide": false,
"instant": true,
"interval": "",
"legendFormat": "",
"refId": "H"
},
{
"datasource": {
"type": "prometheus",
"uid": "${DS_PROMETHEUS}"
},
"exemplar": false,
"expr": "connexion_system_error_event_count_last_30_min",
"format": "table",
"hide": false,
"instant": true,
"interval": "",
"legendFormat": "",
"refId": "I"
},
{
"datasource": {
"type": "prometheus",
"uid": "${DS_PROMETHEUS}"
},
"exemplar": false,
"expr": "connexion_system_oldest_queued_message_in_minutes",
"format": "table",
"hide": false,
"instant": true,
"interval": "",
"legendFormat": "",
"refId": "J"
},
{
"datasource": {
"type": "prometheus",
"uid": "${DS_PROMETHEUS}"
},
"exemplar": false,
"expr": "connexion_system_static_metrics",
"format": "table",
"hide": false,
"instant": true,
"interval": "",
"legendFormat": "",
"refId": "K"
}
],
"title": "Connexion Instances",
"transformations": [
{
"id": "seriesToColumns",
"options": {
"byField": "instance"
}
},
{
"id": "organize",
"options": {
"excludeByName": {
"Drive": true,
"Metric": true,
"Metric 3": false,
"QueueType": true,
"Status 1": true,
"Status 2": true,
"Status 3": true,
"Time": true,
"Time 10": true,
"Time 11": true,
"Time 6": true,
"Time 7": true,
"Time 8": true,
"Time 9": true,
"Value #K": true,
"__name__": true,
"__name__ 10": true,
"__name__ 3": false,
"__name__ 4": true,
"__name__ 5": true,
"__name__ 6": true,
"__name__ 7": true,
"__name__ 8": true,
"__name__ 9": true,
"core_count 2": true,
"cxn_version 2": true,
"job": true,
"job 10": true,
"job 4": true,
"job 5": true,
"job 6": true,
"job 7": true,
"job 8": true,
"job 9": true,
"os_version 2": true,
"total_ram 2": true
},
"indexByName": {
"Drive": 22,
"Metric 1": 14,
"Metric 2": 18,
"Metric 3": 23,
"Metric 4": 47,
"Status 1": 28,
"Status 2": 32,
"Status 3": 36,
"Time 1": 13,
"Time 10": 45,
"Time 11": 46,
"Time 2": 17,
"Time 3": 21,
"Time 4": 26,
"Time 5": 27,
"Time 6": 31,
"Time 7": 35,
"Time 8": 39,
"Time 9": 40,
"Value #A": 9,
"Value #B": 10,
"Value #C": 11,
"Value #D": 12,
"Value #E": 4,
"Value #F": 5,
"Value #G": 6,
"Value #H": 7,
"Value #I": 3,
"Value #J": 8,
"Value #K": 52,
"__name__ 1": 15,
"__name__ 2": 19,
"__name__ 3": 24,
"__name__ 4": 29,
"__name__ 5": 33,
"__name__ 6": 37,
"__name__ 7": 41,
"__name__ 8": 43,
"__name__ 9": 48,
"core_count": 49,
"cxn_version": 1,
"instance": 0,
"job 1": 16,
"job 2": 20,
"job 3": 25,
"job 4": 30,
"job 5": 34,
"job 6": 38,
"job 7": 42,
"job 8": 44,
"job 9": 50,
"os_version": 2,
"total_ram": 51
},
"renameByName": {
"Metric 2": "",
"Time 1": "",
"Time 5": "",
"Value #A": "CPU Usage",
"Value #B": "Memory Usage",
"Value #C": "Disk Usage",
"Value #D": "#Process",
"Value #E": "Running",
"Value #F": "Stopped",
"Value #G": "Invalid",
"Value #H": "Msg Count",
"Value #I": "Errors (<30m)",
"Value #J": "Oldest Q",
"Value #K": "",
"core_count": "#Cores",
"core_count 1": "# Cores",
"core_count 2": "",
"cxn_version": "CXN Ver",
"cxn_version 1": "CXN Version",
"cxn_version 2": "",
"instance": "Server",
"job 3": "",
"job 4": "",
"job 8": "",
"job 9": "",
"os_version": "OS Ver",
"os_version 1": "OS",
"total_ram": "RAM (GB)",
"total_ram 1": "Mem (GB)"
}
}
}
],
"type": "table"
},
{
"datasource": {
"type": "prometheus",
"uid": "${DS_PROMETHEUS}"
},
"fieldConfig": {
"defaults": {
"color": {
"mode": "thresholds"
},
"custom": {
"align": "center",
"cellOptions": {
"type": "auto"
},
"filterable": true,
"inspect": false,
"minWidth": 100
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
}
},
"overrides": [
{
"matcher": {
"id": "byName",
"options": "RAM"
},
"properties": [
{
"id": "unit",
"value": "decmbytes"
},
{
"id": "decimals",
"value": 0
}
]
},
{
"matcher": {
"id": "byName",
"options": "Msg Count"
},
"properties": [
{
"id": "unit",
"value": "locale"
}
]
},
{
"matcher": {
"id": "byName",
"options": "SQL Server Mem"
},
"properties": [
{
"id": "unit",
"value": "decmbytes"
}
]
},
{
"matcher": {
"id": "byName",
"options": "Avg. CPU"
},
"properties": [
{
"id": "custom.cellOptions",
"value": {
"mode": "gradient",
"type": "gauge"
}
},
{
"id": "unit",
"value": "percent"
},
{
"id": "max",
"value": 100
}
]
},
{
"matcher": {
"id": "byName",
"options": "Read"
},
"properties": [
{
"id": "unit",
"value": "Bps"
}
]
},
{
"matcher": {
"id": "byName",
"options": "Write"
},
"properties": [
{
"id": "unit",
"value": "Bps"
}
]
},
{
"matcher": {
"id": "byName",
"options": "Msg Size"
},
"properties": [
{
"id": "unit",
"value": "decmbytes"
}
]
},
{
"matcher": {
"id": "byName",
"options": "Mem Used"
},
"properties": [
{
"id": "unit",
"value": "percent"
},
{
"id": "custom.cellOptions",
"value": {
"mode": "gradient",
"type": "gauge"
}
},
{
"id": "max",
"value": 100
}
]
},
{
"matcher": {
"id": "byName",
"options": "C: Remaining"
},
"properties": [
{
"id": "unit",
"value": "decmbytes"
}
]
},
{
"matcher": {
"id": "byName",
"options": "D: Remaining"
},
"properties": [
{
"id": "unit",
"value": "decmbytes"
}
]
},
{
"matcher": {
"id": "byName",
"options": "Host"
},
"properties": [
{
"id": "links",
"value": [
{
"targetBlank": true,
"title": "",
"url": "d/CNjbCOu7z/repositories?refresh=${__interval}&var-host=${__value.raw}"
}
]
}
]
}
]
},
"gridPos": {
"h": 7,
"w": 24,
"x": 0,
"y": 7
},
"id": 55,
"options": {
"cellHeight": "sm",
"footer": {
"countRows": false,
"fields": "",
"reducer": [
"sum"
],
"show": false
},
"showHeader": true,
"sortBy": [
{
"desc": true,
"displayName": "Host"
}
]
},
"pluginVersion": "10.1.1",
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "${DS_PROMETHEUS}"
},
"exemplar": false,
"expr": "sum by (Host) (connexion_repository_message_counts)",
"format": "table",
"instant": true,
"interval": "",
"legendFormat": "",
"refId": "A"
},
{
"datasource": {
"type": "prometheus",
"uid": "${DS_PROMETHEUS}"
},
"exemplar": false,
"expr": "connexion_repository_performance_metrics{Metric=\"connexion_sqlhost_physical_memory_in_mb\"}",
"format": "table",
"hide": false,
"instant": true,
"interval": "",
"legendFormat": "",
"refId": "B"
},
{
"datasource": {
"type": "prometheus",
"uid": "${DS_PROMETHEUS}"
},
"exemplar": false,
"expr": "connexion_repository_performance_metrics{Metric=\"connexion_sqlhost_sql_process_memory_usage_in_mb\"}",
"format": "table",
"hide": false,
"instant": true,
"interval": "",
"legendFormat": "",
"refId": "C"
},
{
"datasource": {
"type": "prometheus",
"uid": "${DS_PROMETHEUS}"
},
"exemplar": false,
"expr": "connexion_repository_performance_metrics{Metric=\"connexion_sqlhost_cpu_usage_last_5_minutes\"}",
"format": "table",
"hide": false,
"instant": true,
"interval": "",
"legendFormat": "",
"refId": "D"
},
{
"datasource": {
"type": "prometheus",
"uid": "${DS_PROMETHEUS}"
},
"exemplar": false,
"expr": "rate(connexion_repository_performance_metrics{Metric=\"num_of_bytes_read\"}[30s])",
"format": "table",
"hide": false,
"instant": true,
"interval": "",
"legendFormat": "",
"refId": "E"
},
{
"datasource": {
"type": "prometheus",
"uid": "${DS_PROMETHEUS}"
},
"exemplar": false,
"expr": "rate(connexion_repository_performance_metrics{Metric=\"num_of_bytes_written\"}[30s])",
"format": "table",
"hide": false,
"instant": true,
"interval": "",
"legendFormat": "",
"refId": "F"
},
{
"datasource": {
"type": "prometheus",
"uid": "${DS_PROMETHEUS}"
},
"exemplar": false,
"expr": "sum by (Host, Catalog) (connexion_repository_performance_metrics{Metric=\"total_size_mb\"})",
"format": "table",
"hide": false,
"instant": true,
"interval": "",
"legendFormat": "",
"refId": "G"
},
{
"datasource": {
"type": "prometheus",
"uid": "${DS_PROMETHEUS}"
},
"exemplar": false,
"expr": "(1 - (connexion_repository_performance_metrics{Metric=\"connexion_sqlhost_available_memory_in_mb\"} / on (Host) connexion_repository_performance_metrics{Metric=\"connexion_sqlhost_physical_memory_in_mb\"})) * 100",
"format": "table",
"hide": false,
"instant": true,
"interval": "",
"legendFormat": "",
"refId": "H"
},
{
"datasource": {
"type": "prometheus",
"uid": "${DS_PROMETHEUS}"
},
"exemplar": false,
"expr": "connexion_repository_performance_metrics{Metric=\"connexion_sqlhost_core_count\"}",
"format": "table",
"hide": false,
"instant": true,
"interval": "",
"legendFormat": "",
"refId": "I"
},
{
"datasource": {
"type": "prometheus",
"uid": "${DS_PROMETHEUS}"
},
"exemplar": false,
"expr": "connexion_repository_static_metrics",
"format": "table",
"hide": false,
"instant": true,
"interval": "",
"legendFormat": "",
"refId": "K"
},
{
"datasource": {
"type": "prometheus",
"uid": "${DS_PROMETHEUS}"
},
"exemplar": false,
"expr": "connexion_repository_disk_space{Disk=\"C:\"}",
"format": "table",
"hide": false,
"instant": true,
"interval": "",
"legendFormat": "",
"refId": "J"
},
{
"datasource": {
"type": "prometheus",
"uid": "${DS_PROMETHEUS}"
},
"exemplar": false,
"expr": "connexion_repository_disk_space{Disk=\"D:\"}",
"format": "table",
"hide": false,
"instant": true,
"interval": "",
"legendFormat": "",
"refId": "L"
}
],
"title": "Database Hosts",
"transformations": [
{
"id": "seriesToColumns",
"options": {
"byField": "Host"
}
},
{
"id": "organize",
"options": {
"excludeByName": {
"Catalog 1": true,
"Catalog 2": true,
"Catalog 3": true,
"Catalog 4": true,
"Catalog 5": true,
"Catalog 6": true,
"Catalog 7": true,
"Catalog 8": true,
"Catalog 9": true,
"Disk": true,
"Disk 1": true,
"Disk 2": true,
"Metric": true,
"Metric 1": true,
"Metric 3": true,
"Metric 4": true,
"Metric 5": true,
"Metric 6": true,
"Time 1": true,
"Time 10": true,
"Time 11": true,
"Time 12": true,
"Time 2": true,
"Time 3": true,
"Time 4": true,
"Time 5": true,
"Time 6": true,
"Time 7": true,
"Time 8": true,
"Time 9": true,
"Value #I": false,
"Value #K": true,
"__name__ 1": true,
"__name__ 2": true,
"__name__ 3": true,
"__name__ 4": true,
"__name__ 5": true,
"__name__ 6": true,
"__name__ 7": true,
"instance 1": true,
"instance 2": true,
"instance 3": true,
"instance 4": true,
"instance 5": true,
"instance 6": true,
"instance 7": true,
"instance 8": true,
"instance 9": true,
"job 1": true,
"job 2": true,
"job 3": true,
"job 4": true,
"job 5": true,
"job 6": true,
"job 7": true,
"job 8": true,
"job 9": true
},
"indexByName": {
"Catalog 1": 14,
"Catalog 2": 16,
"Catalog 3": 22,
"Catalog 4": 28,
"Catalog 5": 34,
"Catalog 6": 39,
"Catalog 7": 44,
"Catalog 8": 47,
"Catalog 9": 58,
"Disk 1": 62,
"Disk 2": 64,
"Host": 0,
"Metric 1": 17,
"Metric 2": 23,
"Metric 3": 29,
"Metric 4": 35,
"Metric 5": 40,
"Metric 6": 48,
"Time 1": 13,
"Time 10": 52,
"Time 11": 57,
"Time 12": 63,
"Time 2": 15,
"Time 3": 21,
"Time 4": 27,
"Time 5": 33,
"Time 6": 38,
"Time 7": 43,
"Time 8": 45,
"Time 9": 46,
"Value #A": 4,
"Value #B": 10,
"Value #C": 8,
"Value #D": 2,
"Value #E": 6,
"Value #F": 7,
"Value #G": 5,
"Value #H": 3,
"Value #I": 9,
"Value #J": 11,
"Value #K": 56,
"Value #L": 12,
"Version": 1,
"__name__ 1": 18,
"__name__ 2": 24,
"__name__ 3": 30,
"__name__ 4": 49,
"__name__ 5": 53,
"__name__ 6": 59,
"__name__ 7": 65,
"instance 1": 19,
"instance 2": 25,
"instance 3": 31,
"instance 4": 36,
"instance 5": 41,
"instance 6": 50,
"instance 7": 54,
"instance 8": 60,
"instance 9": 66,
"job 1": 20,
"job 2": 26,
"job 3": 32,
"job 4": 37,
"job 5": 42,
"job 6": 51,
"job 7": 55,
"job 8": 61,
"job 9": 67
},
"renameByName": {
"Time 2": "",
"Value #A": "Msg Count",
"Value #B": "RAM",
"Value #C": "SQL Server Mem",
"Value #D": "Avg. CPU",
"Value #E": "Read",
"Value #F": "Write",
"Value #G": "Msg Size",
"Value #H": "Mem Used",
"Value #I": "#Cores",
"Value #J": "C: Remaining",
"Value #L": "D: Remaining",
"job 2": ""
}
}
}
],
"type": "table"
}
],
"refresh": "",
"schemaVersion": 38,
"style": "dark",
"tags": [],
"templating": {
"list": []
},
"time": {
"from": "now-6h",
"to": "now"
},
"timepicker": {},
"timezone": "",
"title": "All Servers",
"uid": "lLSeC-u7k",
"version": 1,
"weekStart": ""
}