<- Back to Templates
MSSQL
By KloudMate
The Microsoft SQL Server (MSSQL) dashboard provides full-stack observability into database performance, availability, and resource utilization through OpenTelemetry (Otel) integration.
Template JSON
{
"name": "MSSQL",
"description": "",
"data": {
"tz": "local",
"panels": [
{
"id": "ciodwed2rd6",
"tz": "local",
"axis": {
"x": {
"date_style": "auto"
},
"y": {
"format": "number",
"suffix": "{requests}/s",
"decimals": 3
}
},
"title": "SQL Batch Requests Received",
"panelType": "TimeSeries",
"timeRange": "1h",
"statConfig": {
"statView": "grid",
"baseColor": "#4CBB17",
"calculation": "last"
},
"timeseries": {
"legend": {
"view": "list",
"values": []
}
},
"description": "Number of batch requests received by SQL Server.\nIt will track the total number of batch requests over a defined period",
"node_configs": [
{
"stat": "",
"type": "query",
"limit": "",
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"dataset": "metrics",
"filters": [
{
"type": "root",
"field": "serviceName",
"value": "$ServerName",
"operator": "="
}
],
"groupBy": [
{
"type": "root",
"field": "serviceName"
}
],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"metricType": "",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "SUM",
"type": "",
"unit": "{requests}/s",
"field": "",
"metric": "sqlserver_batch_request_rate",
"metricType": "Gauge",
"temporality": "Cumulative"
},
"datasourceId": "kloudmate",
"legendFormat": "{{serviceName}}",
"responseType": "series"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "2r9mq7bgwln",
"tz": "local",
"axis": {
"x": {
"date_style": "auto"
},
"y": {
"format": "number",
"suffix": "{compilations}/s",
"decimals": 3
}
},
"title": "SQL compilations",
"panelType": "TimeSeries",
"timeRange": "1h",
"statConfig": {
"statView": "grid",
"baseColor": "#4CBB17",
"calculation": "last"
},
"timeseries": {
"legend": {
"view": "list",
"values": []
}
},
"description": "The number of SQL compilations per second which accumulate the total number of compilations over a specific time period",
"node_configs": [
{
"stat": "",
"type": "query",
"limit": "",
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"dataset": "metrics",
"filters": [
{
"type": "root",
"field": "serviceName",
"value": "$ServerName",
"operator": "="
}
],
"groupBy": [
{
"type": "root",
"field": "serviceName"
}
],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"metricType": "",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "SUM",
"type": "",
"unit": "{compilations}/s",
"field": "",
"metric": "sqlserver_batch_sql_compilation_rate",
"metricType": "Gauge",
"temporality": "Cumulative"
},
"datasourceId": "kloudmate",
"legendFormat": "{{serviceName}}",
"responseType": "series"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "3dlb2t1flxg",
"tz": "local",
"axis": {
"x": {
"date_style": "auto"
},
"y": {
"format": "number",
"suffix": "{compilations}/s",
"decimals": 3
}
},
"title": "SQL recompilations",
"panelType": "TimeSeries",
"timeRange": "1h",
"statConfig": {
"statView": "grid",
"baseColor": "#4CBB17",
"calculation": "last"
},
"timeseries": {
"legend": {
"view": "list",
"values": []
}
},
"description": "The number of SQL recompilations needed per second. This specify trends and spikes in recompilation activity, which can indicate issues with query plans or caching",
"node_configs": [
{
"stat": "",
"type": "query",
"limit": "",
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"dataset": "metrics",
"filters": [
{
"type": "root",
"field": "serviceName",
"value": "$ServerName",
"operator": "="
}
],
"groupBy": [
{
"type": "root",
"field": "serviceName"
}
],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"metricType": "",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "SUM",
"type": "",
"unit": "{compilations}/s",
"field": "",
"metric": "sqlserver_batch_sql_recompilation_rate",
"metricType": "Gauge",
"temporality": "Cumulative"
},
"datasourceId": "kloudmate",
"legendFormat": "{{serviceName}}",
"responseType": "series"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "0hwlgev9hiip",
"tz": "local",
"axis": {
"x": {
"date_style": "auto"
},
"y": {
"format": "number",
"suffix": "{requests}/s",
"decimals": 3
}
},
"title": "SQL lock requests",
"panelType": "TimeSeries",
"timeRange": "1h",
"statConfig": {
"statView": "grid",
"baseColor": "#4CBB17",
"calculation": "last"
},
"timeseries": {
"legend": {
"view": "list",
"values": []
}
},
"description": "Number of lock requests resulting in a wait. This will show the total number of lock requests that have resulted in waits over a specified time period",
"node_configs": [
{
"stat": "",
"type": "query",
"limit": "",
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"dataset": "metrics",
"filters": [
{
"type": "root",
"field": "serviceName",
"value": "$ServerName",
"operator": "="
}
],
"groupBy": [
{
"type": "root",
"field": "serviceName"
}
],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"metricType": "",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "SUM",
"type": "",
"unit": "{requests}/s",
"field": "",
"metric": "sqlserver_lock_wait_rate",
"metricType": "Gauge",
"temporality": "Cumulative"
},
"datasourceId": "kloudmate",
"legendFormat": "{{serviceName}}",
"responseType": "series"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "9xp245vkcar",
"tz": "local",
"axis": {
"x": {
"date_style": "auto"
},
"y": {
"format": "number",
"suffix": "%",
"decimals": 3
}
},
"title": "SQL Buffer Cache Hit Ratio",
"panelType": "TimeSeries",
"timeRange": "1h",
"statConfig": {
"statView": "grid",
"baseColor": "#4CBB17",
"calculation": "last"
},
"timeseries": {
"legend": {
"view": "list",
"values": []
}
},
"description": "The percentage of pages found in the buffer pool without having to read from disk",
"node_configs": [
{
"stat": "",
"type": "query",
"limit": "",
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"dataset": "metrics",
"filters": [
{
"type": "root",
"field": "serviceName",
"value": "$ServerName",
"operator": "="
}
],
"groupBy": [
{
"type": "root",
"field": "serviceName"
}
],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"metricType": "",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "AVG",
"type": "",
"unit": "%",
"field": "",
"metric": "sqlserver_page_buffer_cache_hit_ratio",
"metricType": "Gauge",
"temporality": "Cumulative"
},
"datasourceId": "kloudmate",
"legendFormat": "{{serviceName}}",
"responseType": "series"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "1hcsf3qxxni",
"tz": "local",
"axis": {
"x": {
"date_style": "auto"
},
"y": {
"format": "number",
"suffix": "{connections}",
"decimals": 3
}
},
"title": "Maximum SQL Server Connections",
"panelType": "STATS",
"timeRange": "15m",
"statConfig": {
"format": "number",
"statView": "grid",
"baseColor": "#4CBB17",
"calculation": "last"
},
"timeseries": {
"legend": {
"view": "list",
"values": []
}
},
"description": "Number of users connected to the SQL Server.",
"node_configs": [
{
"stat": "",
"type": "query",
"limit": "",
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"dataset": "metrics",
"filters": [
{
"type": "root",
"field": "serviceName",
"value": "$ServerName",
"operator": "="
}
],
"groupBy": [
{
"type": "root",
"field": "serviceName"
}
],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"metricType": "",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "MAX",
"type": "",
"unit": "{connections}",
"field": "",
"metric": "sqlserver_user_connection_count",
"metricType": "Gauge",
"temporality": "Cumulative"
},
"datasourceId": "kloudmate",
"legendFormat": "{{serviceName}}",
"responseType": "series"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "4u6e4qorrix",
"tz": "local",
"axis": {
"x": {
"date_style": "auto"
},
"y": {
"format": "number",
"suffix": "{databases}",
"decimals": 3
}
},
"title": "Number of Active Databases",
"panelType": "STATS",
"timeRange": "1h",
"statConfig": {
"statView": "grid",
"baseColor": "#4CBB17",
"calculation": "last"
},
"timeseries": {
"legend": {
"view": "list",
"values": []
}
},
"description": "The total number of active databases on the SQL Server instance",
"node_configs": [
{
"stat": "",
"type": "query",
"limit": "",
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"dataset": "metrics",
"filters": [
{
"type": "root",
"field": "serviceName",
"value": "$ServerName",
"operator": "="
},
{
"type": "string",
"field": "database_status",
"value": "online",
"operator": "="
}
],
"groupBy": [
{
"type": "root",
"field": "serviceName"
}
],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"metricType": "",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "SUM",
"type": "",
"unit": "{databases}",
"field": "",
"metric": "sqlserver_database_count",
"metricType": "Gauge",
"temporality": "Cumulative"
},
"datasourceId": "kloudmate",
"responseType": "series"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "2cnjadaj3y3",
"tz": "local",
"axis": {
"x": {
"date_style": "auto"
},
"y": {
"format": "bytes",
"decimals": 3
}
},
"title": "Database I/O (Bytes)",
"panelType": "TimeSeries",
"timeRange": "1h",
"statConfig": {
"statView": "grid",
"baseColor": "#4CBB17",
"calculation": "last"
},
"timeseries": {
"legend": {
"view": "list",
"values": []
}
},
"description": "The total number of bytes of I/O operations on the database files",
"node_configs": [
{
"stat": "",
"type": "query",
"limit": "",
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"dataset": "metrics",
"filters": [
{
"type": "root",
"field": "serviceName",
"value": "$ServerName",
"operator": "="
}
],
"groupBy": [
{
"type": "string",
"field": "direction"
}
],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"metricType": "",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "AVG",
"type": "",
"unit": "By",
"field": "",
"metric": "sqlserver_database_io",
"metricType": "Sum",
"temporality": "Cumulative"
},
"datasourceId": "kloudmate",
"legendFormat": "{{direction}}",
"responseType": "series"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "as7vx7j1ii8",
"tz": "local",
"axis": {
"x": {
"date_style": "auto"
},
"y": {
"format": "duration",
"decimals": 3,
"multiplyBy": 0.001
}
},
"title": "Database Maximum Latency (Seconds)",
"panelType": "TimeSeries",
"timeRange": "1h",
"statConfig": {
"statView": "grid",
"baseColor": "#4CBB17",
"calculation": "last"
},
"timeseries": {
"legend": {
"view": "list",
"values": []
}
},
"description": "The total time that users waited for I/O operations on the database files",
"node_configs": [
{
"stat": "",
"type": "query",
"limit": "",
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"dataset": "metrics",
"filters": [
{
"type": "root",
"field": "serviceName",
"value": "$ServerName",
"operator": "="
}
],
"groupBy": [
{
"type": "string",
"field": "direction"
}
],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"metricType": "",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "MAX",
"type": "",
"unit": "s",
"field": "",
"metric": "sqlserver_database_latency",
"metricType": "Sum",
"temporality": "Cumulative"
},
"datasourceId": "kloudmate",
"legendFormat": "{{direction}}",
"responseType": "series"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "0wykw03ifah",
"tz": "local",
"axis": {
"x": {
"date_style": "auto"
},
"y": {
"format": "number",
"suffix": "{operations}",
"decimals": 3
}
},
"title": "Database Operations Count",
"panelType": "TimeSeries",
"timeRange": "1h",
"statConfig": {
"statView": "grid",
"baseColor": "#4CBB17",
"calculation": "last"
},
"timeseries": {
"legend": {
"view": "list",
"values": []
}
},
"description": "The total number of I/O operations issued on the database files",
"node_configs": [
{
"stat": "",
"type": "query",
"limit": "",
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"dataset": "metrics",
"filters": [
{
"type": "root",
"field": "serviceName",
"value": "$ServerName",
"operator": "="
}
],
"groupBy": [
{
"type": "string",
"field": "direction"
}
],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"metricType": "",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "COUNT",
"type": "",
"unit": "{operations}",
"field": "",
"metric": "sqlserver_database_operations",
"metricType": "Sum",
"temporality": "Cumulative"
},
"datasourceId": "kloudmate",
"legendFormat": "{{direction}}",
"responseType": "series"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "r9s8ru2o8rn",
"tz": "local",
"axis": {
"x": {
"date_style": "auto"
},
"y": {
"format": "number",
"suffix": "{processes}",
"decimals": 3
}
},
"title": "Blocked Processes Count",
"panelType": "TimeSeries",
"timeRange": "1h",
"statConfig": {
"statView": "grid",
"baseColor": "#4CBB17",
"calculation": "last"
},
"timeseries": {
"legend": {
"view": "list",
"values": []
}
},
"description": "The number of processes that are currently blocked in SQL Server",
"node_configs": [
{
"stat": "",
"type": "query",
"limit": "",
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"dataset": "metrics",
"filters": [
{
"type": "root",
"field": "serviceName",
"value": "$ServerName",
"operator": "="
}
],
"groupBy": [
{
"type": "root",
"field": "serviceName"
}
],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"metricType": "",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "SUM",
"type": "",
"unit": "{processes}",
"field": "",
"metric": "sqlserver_processes_blocked",
"metricType": "Gauge",
"temporality": "Cumulative"
},
"datasourceId": "kloudmate",
"legendFormat": "{{serviceName}}",
"responseType": "series"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "7glag5igboq",
"tz": "local",
"axis": {
"x": {
"date_style": "auto"
},
"y": {
"format": "number",
"suffix": "{reads}/s",
"decimals": 3
}
},
"title": "Throttled Read Operations Rate",
"panelType": "TimeSeries",
"timeRange": "1h",
"statConfig": {
"statView": "grid",
"baseColor": "#4CBB17",
"calculation": "last"
},
"timeseries": {
"legend": {
"view": "list",
"values": []
}
},
"description": "The rate of read operations that were throttled in the last second",
"node_configs": [
{
"stat": "",
"type": "query",
"limit": "",
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"dataset": "metrics",
"filters": [
{
"type": "root",
"field": "serviceName",
"value": "$ServerName",
"operator": "="
}
],
"groupBy": [
{
"type": "root",
"field": "serviceName"
}
],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"metricType": "",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "SUM",
"type": "",
"unit": "{reads}/s",
"field": "",
"metric": "sqlserver_resource_pool_disk_throttled_read_rate",
"metricType": "Gauge",
"temporality": "Cumulative"
},
"datasourceId": "kloudmate",
"legendFormat": "{{serviceName}}",
"responseType": "series"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "ben2o88ati",
"tz": "local",
"axis": {
"x": {
"date_style": "auto"
},
"y": {
"format": "number",
"suffix": "{writes}/s",
"decimals": 3
}
},
"title": "Throttled write Operations Rate",
"panelType": "TimeSeries",
"timeRange": "1h",
"statConfig": {
"statView": "grid",
"baseColor": "#4CBB17",
"calculation": "last"
},
"timeseries": {
"legend": {
"view": "list",
"values": []
}
},
"description": "The rate of write operations that were throttled in the last second",
"node_configs": [
{
"stat": "",
"type": "query",
"limit": "",
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"dataset": "metrics",
"filters": [
{
"type": "root",
"field": "serviceName",
"value": "$ServerName",
"operator": "="
}
],
"groupBy": [
{
"type": "root",
"field": "serviceName"
}
],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"metricType": "",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "SUM",
"type": "",
"unit": "{writes}/s",
"field": "",
"metric": "sqlserver_resource_pool_disk_throttled_write_rate",
"metricType": "Gauge",
"temporality": "Cumulative"
},
"datasourceId": "kloudmate",
"legendFormat": "{{serviceName}}",
"responseType": "series"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "3vgp4c3wpra",
"tz": "local",
"axis": {
"x": {
"date_style": "auto"
}
},
"title": "CPU Usage",
"panelType": "STATS",
"timeRange": "1h",
"statConfig": {
"format": "percentage",
"decimals": 1,
"statView": "grid",
"baseColor": "#4CBB17",
"calculation": "last"
},
"timeseries": {
"legend": {
"view": "list",
"values": []
}
},
"node_configs": [
{
"exp": "1 - (avg by(job) (irate(system_cpu_time{job=\"$ServerName\",state=\"idle\"}[5m])))",
"stat": "",
"type": "query",
"limit": "",
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"dataset": "metrics",
"filters": [],
"groupBy": [],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"metricType": "",
"query_type": "promql",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "AVG",
"type": "",
"field": ""
},
"datasourceId": "kloudmate",
"responseType": "series"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "0q3877lnqhsc",
"tz": "local",
"axis": {
"x": {
"date_style": "auto"
}
},
"title": "Memory Usage",
"panelType": "STATS",
"timeRange": "1h",
"statConfig": {
"format": "percentage",
"decimals": 2,
"statView": "grid",
"baseColor": "#4CBB17",
"calculation": "last"
},
"timeseries": {
"legend": {
"view": "list",
"values": []
}
},
"node_configs": [
{
"exp": "sum by(job) (system_memory_usage{job=\"$ServerName\",state=\"used\"}) / sum by(job) (system_memory_usage{job=\"$ServerName\"})",
"stat": "",
"type": "query",
"limit": "",
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"dataset": "metrics",
"filters": [],
"groupBy": [],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"metricType": "",
"query_type": "promql",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "AVG",
"type": "",
"field": ""
},
"datasourceId": "kloudmate",
"responseType": "series"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "4jbitaipo3h",
"tz": "local",
"axis": {
"x": {
"date_style": "auto"
}
},
"title": "File System Usage",
"panelType": "STATS",
"timeRange": "1h",
"statConfig": {
"format": "percentage",
"decimals": 1,
"statView": "grid",
"baseColor": "#4CBB17",
"calculation": "last"
},
"timeseries": {
"legend": {
"view": "list",
"values": []
}
},
"node_configs": [
{
"exp": "sum by(job) (system_filesystem_usage{job=\"$ServerName\",state=\"used\",device!~\"/dev/loop.*\", device!~\"tmpfs|nsfs\"}) / sum by(job) (system_filesystem_usage{job=\"$ServerName\",device!~\"/dev/loop.*\", device!~\"tmpfs|nsfs\"})",
"stat": "",
"type": "query",
"limit": "",
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"dataset": "metrics",
"filters": [],
"groupBy": [],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"metricType": "",
"query_type": "promql",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "AVG",
"type": "",
"field": ""
},
"datasourceId": "kloudmate",
"responseType": "series"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "gkh3answihi",
"tz": "local",
"axis": {
"x": {
"date_style": "auto"
},
"y": {
"format": "unformatted",
"decimals": 3
}
},
"table": {
"columns": [
{
"key": "A:AVG()",
"rename": ""
},
{
"key": "serviceName",
"rename": ""
}
]
},
"title": "MSSQL Server Uptime",
"panelType": "STATS",
"timeRange": "1h",
"statConfig": {
"format": "duration",
"statView": "grid",
"baseColor": "#4CBB17",
"multiplyBy": 60000,
"calculation": "last"
},
"timeseries": {
"legend": {
"view": "list",
"values": []
}
},
"node_configs": [
{
"stat": "",
"type": "query",
"limit": "",
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"dataset": "metrics",
"filters": [
{
"type": "root",
"field": "serviceName",
"value": "$ServerName",
"operator": "="
}
],
"groupBy": [
{
"type": "root",
"field": "serviceName"
}
],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"metricType": "",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "AVG",
"type": "",
"unit": "",
"field": "",
"metric": "sqlserver_uptime_minutes",
"metricType": "Gauge",
"temporality": "Cumulative"
},
"datasourceId": "kloudmate",
"responseType": "series"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "bc6hjntyk97",
"tz": "local",
"axis": {
"x": {
"date_style": "auto"
},
"y": {
"format": "number",
"decimals": 3
}
},
"logs": {},
"spans": {},
"table": {
"columns": [
{
"key": "session_id",
"rename": ""
},
{
"key": "service.name",
"rename": "Host_Name"
},
{
"key": "login_name",
"rename": "Login_Name"
},
{
"key": "last_request_start_time",
"rename": ""
},
{
"key": "last_request_end_time",
"rename": ""
},
{
"key": "@message",
"rename": "Client_IP"
}
]
},
"title": "client connections",
"bar_chart": {
"axis": {
"x": {
"date_style": "auto"
},
"y": {
"format": "unformatted",
"prefix": "",
"suffix": "",
"decimals": 3,
"multiplyBy": 1
}
},
"legend": {
"view": "list",
"values": []
},
"display": {
"stacking": "stacked",
"orientation": "vertical"
}
},
"panelType": "logs",
"pie_chart": {
"legend": {
"mode": "list",
"show": true,
"values": [
"percent"
],
"placement": "right"
},
"display": {
"type": "pie",
"labels": [
"name"
]
},
"formatter": {},
"value_options": {
"type": "reduce",
"limit": 20,
"reduce": "last",
"columns": [
"numeric"
]
}
},
"timeRange": "15m",
"statConfig": {
"statView": "grid",
"baseColor": "#4CBB17",
"calculation": "last"
},
"timeseries": {
"legend": {
"view": "list",
"values": []
}
},
"description": "This shows client connections and IP",
"node_configs": [
{
"page": 1,
"stat": "",
"type": "query",
"limit": 10,
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"columns": [
{
"type": "string",
"field": "session_id"
},
{
"type": "string",
"field": "service.name"
},
{
"type": "string",
"field": "login_name"
},
{
"type": "string",
"field": "last_request_start_time"
},
{
"type": "string",
"field": "last_request_end_time"
},
{
"type": "string",
"field": "@message"
}
],
"dataset": "logs",
"filters": [
{
"type": "root",
"field": "serviceName",
"value": "$ServerName",
"operator": "="
},
{
"type": "string",
"field": "log_source",
"value": "mssql_client_log",
"operator": "="
}
],
"groupBy": [],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"metricType": "",
"query_type": "raw",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "AVG",
"type": "",
"unit": "1",
"field": "",
"value": "system_cpu_utilization",
"metric": "system_cpu_utilization",
"metricType": "Gauge",
"temporality": "Cumulative"
},
"datasourceId": "kloudmate",
"responseType": "series"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "ld4oygmp30s",
"tz": "local",
"axis": {
"x": {
"date_style": "auto"
}
},
"logs": {},
"table": {
"columns": [
{
"key": "timestamp",
"rename": ""
},
{
"key": "serviceName",
"rename": ""
},
{
"key": "@message",
"rename": "Login Name"
}
]
},
"title": "User sessions",
"panelType": "logs",
"timeRange": "1h",
"statConfig": {
"statView": "grid",
"baseColor": "#4CBB17",
"calculation": "last"
},
"timeseries": {
"legend": {
"view": "list",
"values": []
}
},
"node_configs": [
{
"page": 1,
"stat": "",
"type": "query",
"limit": 10,
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"columns": [
{
"type": "root",
"field": "timestamp"
},
{
"type": "root",
"field": "serviceName"
},
{
"type": "string",
"field": "@message"
}
],
"dataset": "logs",
"filters": [
{
"type": "root",
"field": "serviceName",
"value": "$ServerName",
"operator": "="
},
{
"type": "string",
"field": "log_source",
"value": "mssql_user_sessions",
"operator": "="
}
],
"groupBy": [],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"metricType": "",
"query_type": "raw",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "AVG",
"type": "",
"field": ""
},
"datasourceId": "kloudmate",
"responseType": "series"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "2jto14kdpj",
"tz": "local",
"axis": {
"x": {
"date_style": "auto"
}
},
"logs": {},
"table": {
"columns": [
{
"key": "sql_handle",
"rename": ""
},
{
"key": "execution_count",
"rename": ""
},
{
"key": "last_execution_time",
"rename": ""
},
{
"key": "total_elapsed_time",
"rename": "Duration in ms"
},
{
"key": "@message",
"rename": "Query"
}
]
},
"title": "slow query",
"panelType": "logs",
"timeRange": "15m",
"statConfig": {
"statView": "grid",
"baseColor": "#4CBB17",
"calculation": "last"
},
"timeseries": {
"legend": {
"view": "list",
"values": []
}
},
"node_configs": [
{
"page": 1,
"stat": "",
"type": "query",
"limit": 10,
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"columns": [
{
"type": "string",
"field": "sql_handle"
},
{
"type": "string",
"field": "execution_count"
},
{
"type": "string",
"field": "last_execution_time"
},
{
"type": "string",
"field": "total_elapsed_time"
},
{
"type": "string",
"field": "@message"
}
],
"dataset": "logs",
"filters": [
{
"type": "root",
"field": "serviceName",
"value": "$ServerName",
"operator": "="
},
{
"type": "string",
"field": "log_source",
"value": "mssql_slow_query_log",
"operator": "="
}
],
"groupBy": [],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"metricType": "",
"query_type": "raw",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "AVG",
"type": "",
"field": ""
},
"datasourceId": "kloudmate",
"responseType": "series"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
}
],
"timeRange": "1h",
"variables": [
{
"id": "5a8b8611-080c-41e8-a984-67d6738539d5",
"name": "ServerName",
"type": "query",
"config": {
"otel": {
"key": {
"type": "root",
"field": "serviceName"
},
"dataset": "metrics"
},
"source": "cloudwatch",
"queryType": "otel.values"
},
"is_multi": false,
"description": "The server where database is hosted",
"show_all_option": false
}
],
"panel_layouts": [
{
"h": 2,
"i": "ciodwed2rd6",
"w": 4,
"x": 4,
"y": 4,
"minH": 1,
"minW": 2,
"moved": false,
"static": false
},
{
"h": 2,
"i": "2r9mq7bgwln",
"w": 4,
"x": 4,
"y": 2,
"minH": 1,
"minW": 2,
"moved": false,
"static": false
},
{
"h": 2,
"i": "3dlb2t1flxg",
"w": 4,
"x": 8,
"y": 2,
"minH": 1,
"minW": 2,
"moved": false,
"static": false
},
{
"h": 2,
"i": "0hwlgev9hiip",
"w": 6,
"x": 6,
"y": 6,
"minH": 1,
"minW": 2,
"moved": false,
"static": false
},
{
"h": 2,
"i": "9xp245vkcar",
"w": 4,
"x": 8,
"y": 4,
"minH": 1,
"minW": 2,
"moved": false,
"static": false
},
{
"h": 1,
"i": "1hcsf3qxxni",
"w": 2,
"x": 0,
"y": 1,
"minH": 1,
"minW": 2,
"moved": false,
"static": false
},
{
"h": 1,
"i": "4u6e4qorrix",
"w": 2,
"x": 2,
"y": 1,
"minH": 1,
"minW": 2,
"moved": false,
"static": false
},
{
"h": 2,
"i": "2cnjadaj3y3",
"w": 4,
"x": 0,
"y": 2,
"minH": 1,
"minW": 2,
"moved": false,
"static": false
},
{
"h": 2,
"i": "as7vx7j1ii8",
"w": 4,
"x": 0,
"y": 4,
"minH": 1,
"minW": 2,
"moved": false,
"static": false
},
{
"h": 2,
"i": "0wykw03ifah",
"w": 6,
"x": 6,
"y": 0,
"minH": 1,
"minW": 2,
"moved": false,
"static": false
},
{
"h": 2,
"i": "r9s8ru2o8rn",
"w": 6,
"x": 0,
"y": 6,
"minH": 1,
"minW": 2,
"moved": false,
"static": false
},
{
"h": 2,
"i": "7glag5igboq",
"w": 6,
"x": 0,
"y": 8,
"minH": 1,
"minW": 2,
"moved": false,
"static": false
},
{
"h": 2,
"i": "ben2o88ati",
"w": 6,
"x": 6,
"y": 8,
"minH": 1,
"minW": 2,
"moved": false,
"static": false
},
{
"h": 1,
"i": "3vgp4c3wpra",
"w": 2,
"x": 2,
"y": 0,
"minH": 1,
"minW": 2,
"moved": false,
"static": false
},
{
"h": 1,
"i": "0q3877lnqhsc",
"w": 2,
"x": 4,
"y": 0,
"minH": 1,
"minW": 2,
"moved": false,
"static": false
},
{
"h": 1,
"i": "4jbitaipo3h",
"w": 2,
"x": 4,
"y": 1,
"minH": 1,
"minW": 2,
"moved": false,
"static": false
},
{
"h": 1,
"i": "gkh3answihi",
"w": 2,
"x": 0,
"y": 0,
"minH": 1,
"minW": 2,
"moved": false,
"static": false
},
{
"h": 3,
"i": "bc6hjntyk97",
"w": 6,
"x": 0,
"y": 10,
"minH": 1,
"minW": 2,
"moved": false,
"static": false
},
{
"h": 3,
"i": "ld4oygmp30s",
"w": 6,
"x": 6,
"y": 10,
"minH": 1,
"minW": 2,
"moved": false,
"static": false
},
{
"h": 5,
"i": "2jto14kdpj",
"w": 12,
"x": 0,
"y": 13,
"minH": 1,
"minW": 2,
"moved": false,
"static": false
}
],
"default_region": "undefined"
},
"tags": []
}