1245 lines
47 KiB
YAML
1245 lines
47 KiB
YAML
zabbix_export:
|
|
version: '7.0'
|
|
template_groups:
|
|
- uuid: c2c162144c2d4c5491c8801193af4945
|
|
name: Templates/Cloud
|
|
templates:
|
|
- uuid: c3a9fa0e07be4c1bbe19ae65c3375d17
|
|
template: 'Azure Microsoft SQL DTU Database by HTTP'
|
|
name: 'Azure Microsoft SQL DTU Database by HTTP'
|
|
description: |
|
|
This template is designed to monitor Microsoft SQL DTU-based databases via HTTP.
|
|
It works without any external scripts and uses the script item.
|
|
|
|
Setup:
|
|
1. Create an Azure service principal via the Azure command-line interface (Azure CLI) for your subscription.
|
|
`az ad sp create-for-rbac --name zabbix --role reader --scope /subscriptions/<subscription_id>`
|
|
See https://docs.microsoft.com/en-us/cli/azure/create-an-azure-service-principal-azure-cli for more details.
|
|
2. Link the template to a host.
|
|
3. Configure the macros: {$AZURE.APP.ID}, {$AZURE.PASSWORD}, {$AZURE.TENANT.ID}, {$AZURE.SUBSCRIPTION.ID}, and {$AZURE.RESOURCE.ID}.
|
|
|
|
You can discuss this template or leave feedback on our forum https://www.zabbix.com/forum/zabbix-suggestions-and-feedback/.
|
|
|
|
Generated by official Zabbix template tool "Templator"
|
|
vendor:
|
|
name: Zabbix
|
|
version: 7.0-2
|
|
groups:
|
|
- name: Templates/Cloud
|
|
items:
|
|
- uuid: d13b970f51c64553942d04043dd3f8b5
|
|
name: 'Availability status detailed'
|
|
type: DEPENDENT
|
|
key: azure.db.mssql.availability.details
|
|
delay: '0'
|
|
value_type: CHAR
|
|
trends: '0'
|
|
description: 'A detailed summary of the availability status.'
|
|
preprocessing:
|
|
- type: JSONPATH
|
|
parameters:
|
|
- $.health.summary
|
|
- type: DISCARD_UNCHANGED_HEARTBEAT
|
|
parameters:
|
|
- 1h
|
|
master_item:
|
|
key: azure.db.mssql.data.get
|
|
tags:
|
|
- tag: component
|
|
value: health
|
|
- uuid: 96a795438e244fefa2218fcd73542201
|
|
name: 'Availability state'
|
|
type: DEPENDENT
|
|
key: azure.db.mssql.availability.state
|
|
delay: '0'
|
|
description: 'The availability status of the resource.'
|
|
valuemap:
|
|
name: 'Azure resource health state'
|
|
preprocessing:
|
|
- type: JSONPATH
|
|
parameters:
|
|
- $.health.availabilityState
|
|
error_handler: CUSTOM_VALUE
|
|
error_handler_params: '3'
|
|
- type: STR_REPLACE
|
|
parameters:
|
|
- Available
|
|
- '0'
|
|
- type: STR_REPLACE
|
|
parameters:
|
|
- Degraded
|
|
- '1'
|
|
- type: STR_REPLACE
|
|
parameters:
|
|
- Unavailable
|
|
- '2'
|
|
- type: STR_REPLACE
|
|
parameters:
|
|
- Unknown
|
|
- '3'
|
|
- type: IN_RANGE
|
|
parameters:
|
|
- '0'
|
|
- '3'
|
|
error_handler: CUSTOM_VALUE
|
|
error_handler_params: '3'
|
|
- type: DISCARD_UNCHANGED_HEARTBEAT
|
|
parameters:
|
|
- 1h
|
|
master_item:
|
|
key: azure.db.mssql.data.get
|
|
tags:
|
|
- tag: component
|
|
value: health
|
|
triggers:
|
|
- uuid: 6bf8f84c7b494c4da90ef5e47fa75627
|
|
expression: 'last(/Azure Microsoft SQL DTU Database by HTTP/azure.db.mssql.availability.state)=1'
|
|
name: 'Azure MSSQL DTU: Microsoft SQL database is degraded'
|
|
opdata: 'Current state: {ITEM.LASTVALUE1}'
|
|
priority: AVERAGE
|
|
description: 'The resource is in a degraded state.'
|
|
tags:
|
|
- tag: scope
|
|
value: availability
|
|
- uuid: 4196d310e6e84c61a0a7115116f10854
|
|
expression: 'last(/Azure Microsoft SQL DTU Database by HTTP/azure.db.mssql.availability.state)=3'
|
|
name: 'Azure MSSQL DTU: Microsoft SQL database is in unknown state'
|
|
opdata: 'Current state: {ITEM.LASTVALUE1}'
|
|
priority: WARNING
|
|
description: 'The resource state is unknown.'
|
|
tags:
|
|
- tag: scope
|
|
value: availability
|
|
- uuid: b6f356182f3d4b0c88f52d88fce580b9
|
|
expression: 'last(/Azure Microsoft SQL DTU Database by HTTP/azure.db.mssql.availability.state)=2'
|
|
name: 'Azure MSSQL DTU: Microsoft SQL database is unavailable'
|
|
opdata: 'Current state: {ITEM.LASTVALUE1}'
|
|
priority: HIGH
|
|
description: 'The resource state is unavailable.'
|
|
tags:
|
|
- tag: scope
|
|
value: availability
|
|
- uuid: adc84144c91c4e4091e10e2f07d3e026
|
|
name: 'Connections failed: System errors'
|
|
type: DEPENDENT
|
|
key: azure.db.mssql.connections.failed.system
|
|
delay: '0'
|
|
value_type: FLOAT
|
|
description: 'The number of failed connections with system errors.'
|
|
preprocessing:
|
|
- type: JSONPATH
|
|
parameters:
|
|
- $.metrics.connection_failed.total
|
|
error_handler: DISCARD_VALUE
|
|
master_item:
|
|
key: azure.db.mssql.data.get
|
|
tags:
|
|
- tag: component
|
|
value: network
|
|
- uuid: f55c3fcf1a4b4539a6770496453e3ee8
|
|
name: 'Connections successful'
|
|
type: DEPENDENT
|
|
key: azure.db.mssql.connections.successful
|
|
delay: '0'
|
|
value_type: FLOAT
|
|
description: 'The number of successful connections.'
|
|
preprocessing:
|
|
- type: JSONPATH
|
|
parameters:
|
|
- $.metrics.connection_successful.total
|
|
error_handler: DISCARD_VALUE
|
|
master_item:
|
|
key: azure.db.mssql.data.get
|
|
tags:
|
|
- tag: component
|
|
value: network
|
|
- uuid: fb2f97642cb647afaf5f52bb14b6a91c
|
|
name: 'CPU percentage'
|
|
type: DEPENDENT
|
|
key: azure.db.mssql.cpu.percentage
|
|
delay: '0'
|
|
value_type: FLOAT
|
|
units: '%'
|
|
description: 'The average percentage of CPU usage on a host.'
|
|
preprocessing:
|
|
- type: JSONPATH
|
|
parameters:
|
|
- $.metrics.cpu_percent.average
|
|
error_handler: DISCARD_VALUE
|
|
master_item:
|
|
key: azure.db.mssql.data.get
|
|
tags:
|
|
- tag: component
|
|
value: cpu
|
|
triggers:
|
|
- uuid: 97caae1175be4c21b2fd5a53d5be25d2
|
|
expression: 'min(/Azure Microsoft SQL DTU Database by HTTP/azure.db.mssql.cpu.percentage,5m)>{$AZURE.DB.CPU.UTIL.CRIT}'
|
|
name: 'Azure MSSQL DTU: High CPU utilization'
|
|
opdata: 'Current utilization: {ITEM.LASTVALUE1}'
|
|
priority: HIGH
|
|
description: 'The CPU utilization is too high. The system might be slow to respond.'
|
|
tags:
|
|
- tag: scope
|
|
value: performance
|
|
- uuid: 86c709baa2e54477b483eb9289b7ae78
|
|
name: 'Get errors'
|
|
type: DEPENDENT
|
|
key: azure.db.mssql.data.errors
|
|
delay: '0'
|
|
value_type: TEXT
|
|
trends: '0'
|
|
description: 'A list of errors from API requests.'
|
|
preprocessing:
|
|
- type: JSONPATH
|
|
parameters:
|
|
- $.errors
|
|
error_handler: DISCARD_VALUE
|
|
- type: DISCARD_UNCHANGED_HEARTBEAT
|
|
parameters:
|
|
- 1h
|
|
master_item:
|
|
key: azure.db.mssql.data.get
|
|
tags:
|
|
- tag: component
|
|
value: raw
|
|
triggers:
|
|
- uuid: a21b8c56bd914548949c277c77efbd4b
|
|
expression: 'length(last(/Azure Microsoft SQL DTU Database by HTTP/azure.db.mssql.data.errors))>0'
|
|
name: 'Azure MSSQL DTU: There are errors in requests to API'
|
|
opdata: 'Current error: {ITEM.LASTVALUE1}'
|
|
priority: AVERAGE
|
|
description: 'Zabbix has received errors in response to API requests.'
|
|
tags:
|
|
- tag: scope
|
|
value: availability
|
|
- uuid: 4349f68c08a548d19d9ce58e66557ce5
|
|
name: 'Get data'
|
|
type: SCRIPT
|
|
key: azure.db.mssql.data.get
|
|
history: '0'
|
|
value_type: TEXT
|
|
trends: '0'
|
|
params: |
|
|
const CTlsConfig = function (raw_value) {
|
|
raw_value = String(raw_value).trim().toLowerCase();
|
|
|
|
if (['none', 'peer', 'full'].indexOf(raw_value) === -1) {
|
|
raw_value = 'full';
|
|
}
|
|
|
|
this.options = {
|
|
SSLVerifyPeer: (raw_value === 'peer' || raw_value === 'full'),
|
|
SSLVerifyHost: (raw_value === 'full')
|
|
};
|
|
|
|
this.enabled = (raw_value !== 'none');
|
|
|
|
this.checkURL = function (url) {
|
|
if (this.enabled && !/^https:\/\//i.test(url)) {
|
|
throw 'TLS certificate verification is enabled by {$' + 'HTTP.TLS.VERIFY}, but the URL uses plain HTTP: ' + url +
|
|
'. Use an "https://" URL, or set {$' + 'HTTP.TLS.VERIFY} to `none` to disable verification.';
|
|
}
|
|
|
|
return url;
|
|
};
|
|
}
|
|
|
|
|
|
var Azure = {
|
|
params: {},
|
|
token: null,
|
|
|
|
setParams: function (params) {
|
|
['app_id', 'password', 'tenant_id', 'subscription_id', 'resource_id'].forEach(function (field) {
|
|
if (typeof params !== 'object' || typeof params[field] === 'undefined' || params[field] === '') {
|
|
throw 'Required param is not set: ' + field + '.';
|
|
}
|
|
});
|
|
|
|
Azure.params = params;
|
|
Azure.tls = new CTlsConfig(params.tls_verify);
|
|
},
|
|
|
|
login: function () {
|
|
var response, login = new HttpRequest(Azure.tls.options);
|
|
|
|
if (typeof Azure.params.proxy !== 'undefined' && Azure.params.proxy !== '') {
|
|
login.setProxy(Azure.params.proxy);
|
|
}
|
|
|
|
login.addHeader('Content-Type: application/x-www-form-urlencoded');
|
|
response = login.post(
|
|
'https://login.microsoftonline.com/' + encodeURIComponent(Azure.params.tenant_id) + '/oauth2/token',
|
|
'grant_type=client_credentials&resource=' + encodeURIComponent('https://management.azure.com/') + '&client_id=' + encodeURIComponent(Azure.params.app_id) + '&client_secret=' + encodeURIComponent(Azure.params.password)
|
|
);
|
|
|
|
if (login.getStatus() !== 200) {
|
|
throw 'Login failed with status code ' + login.getStatus() + ': ' + response;
|
|
}
|
|
|
|
try {
|
|
response = JSON.parse(response);
|
|
}
|
|
catch (error) {
|
|
throw 'Failed to parse login session response.';
|
|
}
|
|
|
|
if (!response.hasOwnProperty('access_token')) {
|
|
throw 'Authentication response does not contain access token.';
|
|
}
|
|
|
|
Azure.token = response['access_token'];
|
|
},
|
|
|
|
request: function (url) {
|
|
var response, request = new HttpRequest(Azure.tls.options);
|
|
|
|
if (typeof Azure.params.proxy !== 'undefined' && Azure.params.proxy !== '') {
|
|
request.setProxy(Azure.params.proxy);
|
|
}
|
|
|
|
if (!Azure.token) {
|
|
throw 'Request does not contain access token.';
|
|
}
|
|
|
|
request.addHeader('Content-Type: application/json');
|
|
request.addHeader('Authorization: Bearer ' + Azure.token);
|
|
Zabbix.log(4, '[ Azure DTU DB ] request url: ' + url);
|
|
|
|
response = request.get(url);
|
|
|
|
if (request.getStatus() !== 200) {
|
|
throw 'Request failed with status code ' + request.getStatus() + ': ' + response;
|
|
}
|
|
|
|
try {
|
|
return JSON.parse(response);
|
|
}
|
|
catch (error) {
|
|
throw 'Failed to parse response received from API.';
|
|
}
|
|
},
|
|
|
|
getField: function (data, path) {
|
|
var steps = path.split('.');
|
|
|
|
for (var i = 0; i < steps.length; i++) {
|
|
var step = steps[i];
|
|
if (typeof data !== 'object' || typeof data[step] === 'undefined') {
|
|
throw 'Required field was not found: ' + path;
|
|
}
|
|
data = data[step];
|
|
}
|
|
|
|
return data;
|
|
},
|
|
|
|
getMetricsData: function () {
|
|
var data = {},
|
|
metric_endpoints = {
|
|
'metrics_main': '/providers/Microsoft.Insights/metrics?metricnames=' + encodeURIComponent('allocated_data_storage,availability,blocked_by_firewall,connection_failed,connection_successful,cpu_percent,deadlock,dtu_consumption_percent,dtu_limit,dtu_used,log_write_percent,physical_data_read_percent,sessions_count,sessions_percent,sql_instance_cpu_percent,sql_instance_memory_percent,storage,storage_percent') + '&api-version=2021-05-01×pan=PT5M',
|
|
'metrics_secondary': '/providers/Microsoft.Insights/metrics?metricnames=' + encodeURIComponent('tempdb_data_size,tempdb_log_size,tempdb_log_used_percent,workers_percent,xtp_storage_percent') + '&api-version=2021-05-01×pan=PT5M',
|
|
};
|
|
|
|
data.metrics = {};
|
|
|
|
Object.keys(metric_endpoints).forEach(function (field) {
|
|
metrics = Azure.getField(Azure.request('https://management.azure.com' + Azure.params.resource_id + metric_endpoints[field]), 'value');
|
|
|
|
for (k in metrics) {
|
|
key = Azure.getField(metrics[k], 'name.value').replace(/(\s|\/)+/g, '');
|
|
|
|
if (metrics[k].timeseries.length === 0) {
|
|
metrics[k].timeseries.push({ 'data': ['nodata'] })
|
|
}
|
|
|
|
values = Azure.getField(metrics[k], 'timeseries.0.data');
|
|
|
|
for (var i = values.length - 1; i >= 0; i--) {
|
|
|
|
dataseriesKeys = Object.keys(values[i]);
|
|
aggregation = dataseriesKeys[1];
|
|
|
|
if (typeof (values[i][aggregation]) !== 'undefined') {
|
|
data.metrics[key] = values[i];
|
|
break;
|
|
}
|
|
}
|
|
}
|
|
});
|
|
|
|
data.health = Azure.getField(Azure.request('https://management.azure.com' + Azure.params.resource_id + '/providers/Microsoft.ResourceHealth/availabilityStatuses?api-version=2020-05-01'), 'value.0.properties');
|
|
|
|
return data
|
|
}
|
|
};
|
|
|
|
try {
|
|
Azure.setParams(JSON.parse(value));
|
|
Azure.login();
|
|
return JSON.stringify(Azure.getMetricsData());
|
|
}
|
|
catch (error) {
|
|
error += (String(error).endsWith('.')) ? '' : '.';
|
|
Zabbix.log(3, '[ Azure DTU DB ] ERROR: ' + error);
|
|
return JSON.stringify({ 'error': error });
|
|
}
|
|
description: 'The result of API requests is expressed in JSON format.'
|
|
timeout: '{$AZURE.DATA.TIMEOUT}'
|
|
parameters:
|
|
- name: app_id
|
|
value: '{$AZURE.APP.ID}'
|
|
- name: password
|
|
value: '{$AZURE.PASSWORD}'
|
|
- name: proxy
|
|
value: '{$AZURE.PROXY}'
|
|
- name: resource_id
|
|
value: '{$AZURE.RESOURCE.ID}'
|
|
- name: subscription_id
|
|
value: '{$AZURE.SUBSCRIPTION.ID}'
|
|
- name: tenant_id
|
|
value: '{$AZURE.TENANT.ID}'
|
|
- name: tls_verify
|
|
value: '{$HTTP.TLS.VERIFY:"Azure Microsoft SQL DTU Database"}'
|
|
tags:
|
|
- tag: component
|
|
value: raw
|
|
- uuid: 447d6c462a384e87860eeba0b1e17787
|
|
name: 'Data IO percentage'
|
|
type: DEPENDENT
|
|
key: azure.db.mssql.data.read.percentage
|
|
delay: '0'
|
|
value_type: FLOAT
|
|
units: '%'
|
|
description: 'The average percentage of physical data read.'
|
|
preprocessing:
|
|
- type: JSONPATH
|
|
parameters:
|
|
- $.metrics.physical_data_read_percent.average
|
|
error_handler: DISCARD_VALUE
|
|
master_item:
|
|
key: azure.db.mssql.data.get
|
|
tags:
|
|
- tag: component
|
|
value: operations
|
|
- uuid: 192a5d5a4c6541b1a2e6394dc4e6961d
|
|
name: Deadlocks
|
|
type: DEPENDENT
|
|
key: azure.db.mssql.deadlocks
|
|
delay: '0'
|
|
value_type: FLOAT
|
|
description: 'The number of deadlocks. Not applicable to data warehouses.'
|
|
preprocessing:
|
|
- type: JSONPATH
|
|
parameters:
|
|
- $.metrics.deadlock.total
|
|
error_handler: DISCARD_VALUE
|
|
master_item:
|
|
key: azure.db.mssql.data.get
|
|
tags:
|
|
- tag: component
|
|
value: network
|
|
- uuid: 1b9a19283e9f4f5c9ec386edbfd99d86
|
|
name: 'DTU limit'
|
|
type: DEPENDENT
|
|
key: azure.db.mssql.dtu.limit
|
|
delay: '0'
|
|
value_type: FLOAT
|
|
description: 'The DTU limit. Applicable to DTU-based databases.'
|
|
preprocessing:
|
|
- type: JSONPATH
|
|
parameters:
|
|
- $.metrics.dtu_limit.average
|
|
error_handler: DISCARD_VALUE
|
|
master_item:
|
|
key: azure.db.mssql.data.get
|
|
tags:
|
|
- tag: component
|
|
value: dtu
|
|
- uuid: 35daacf9b481454bbf017841c3b4acf6
|
|
name: 'DTU percentage'
|
|
type: DEPENDENT
|
|
key: azure.db.mssql.dtu.percentage
|
|
delay: '0'
|
|
value_type: FLOAT
|
|
units: '%'
|
|
description: 'The average percentage of DTU consumption for a DTU-based database.'
|
|
preprocessing:
|
|
- type: JSONPATH
|
|
parameters:
|
|
- $.metrics.dtu_consumption_percent.average
|
|
error_handler: DISCARD_VALUE
|
|
master_item:
|
|
key: azure.db.mssql.data.get
|
|
tags:
|
|
- tag: component
|
|
value: dtu
|
|
triggers:
|
|
- uuid: eceb245b910841ceb8078ea8b3dbad1b
|
|
expression: 'min(/Azure Microsoft SQL DTU Database by HTTP/azure.db.mssql.dtu.percentage,5m)>{$AZURE.DB.DTU.UTIL.CRIT}'
|
|
name: 'Azure MSSQL DTU: High DTU utilization'
|
|
opdata: 'Current utilization: {ITEM.LASTVALUE1}'
|
|
priority: HIGH
|
|
description: 'The DTU utilization is too high. The system might be slow to respond.'
|
|
tags:
|
|
- tag: scope
|
|
value: performance
|
|
- uuid: 9bd9b5d0fc1d439ebfdfac51f6eb3487
|
|
name: 'DTU used'
|
|
type: DEPENDENT
|
|
key: azure.db.mssql.dtu.used
|
|
delay: '0'
|
|
value_type: FLOAT
|
|
description: 'The DTU used. Applicable to DTU-based databases.'
|
|
preprocessing:
|
|
- type: JSONPATH
|
|
parameters:
|
|
- $.metrics.dtu_used.average
|
|
error_handler: DISCARD_VALUE
|
|
master_item:
|
|
key: azure.db.mssql.data.get
|
|
tags:
|
|
- tag: component
|
|
value: dtu
|
|
- uuid: 4a0b3146d95742b1a30950da3fb6dcc5
|
|
name: 'Connections blocked by firewall'
|
|
type: DEPENDENT
|
|
key: azure.db.mssql.firewall.blocked
|
|
delay: '0'
|
|
value_type: FLOAT
|
|
description: 'The number of connections blocked by the firewall.'
|
|
preprocessing:
|
|
- type: JSONPATH
|
|
parameters:
|
|
- $.metrics.blocked_by_firewall.total
|
|
error_handler: DISCARD_VALUE
|
|
master_item:
|
|
key: azure.db.mssql.data.get
|
|
tags:
|
|
- tag: component
|
|
value: network
|
|
- uuid: 0f71327c99054e5d8ebf432eccc0a536
|
|
name: 'Log IO percentage'
|
|
type: DEPENDENT
|
|
key: azure.db.mssql.log.write.percentage
|
|
delay: '0'
|
|
value_type: FLOAT
|
|
units: '%'
|
|
description: 'The percentage of I/O used for log writes. Not applicable to data warehouses.'
|
|
preprocessing:
|
|
- type: JSONPATH
|
|
parameters:
|
|
- $.metrics.log_write_percent.average
|
|
error_handler: DISCARD_VALUE
|
|
master_item:
|
|
key: azure.db.mssql.data.get
|
|
tags:
|
|
- tag: component
|
|
value: operations
|
|
- uuid: 218525cc5d474d249d62db21ca08d7c6
|
|
name: 'SQL instance CPU percent'
|
|
type: DEPENDENT
|
|
key: azure.db.mssql.server.cpu.percent
|
|
delay: '0'
|
|
value_type: FLOAT
|
|
units: '%'
|
|
description: 'CPU usage from all user and system workloads. Not applicable to data warehouses.'
|
|
preprocessing:
|
|
- type: JSONPATH
|
|
parameters:
|
|
- $.metrics.sql_instance_cpu_percent.maximum
|
|
error_handler: DISCARD_VALUE
|
|
master_item:
|
|
key: azure.db.mssql.data.get
|
|
tags:
|
|
- tag: component
|
|
value: cpu
|
|
- tag: component
|
|
value: server
|
|
- uuid: d6d0d99c736f4ecea48c3cb5d920ee72
|
|
name: 'SQL instance memory percent'
|
|
type: DEPENDENT
|
|
key: azure.db.mssql.server.memory.percent
|
|
delay: '0'
|
|
value_type: FLOAT
|
|
units: '%'
|
|
description: 'The percentage of memory used by the database engine instance. Not applicable to data warehouses.'
|
|
preprocessing:
|
|
- type: JSONPATH
|
|
parameters:
|
|
- $.metrics.sql_instance_cpu_percent.maximum
|
|
error_handler: DISCARD_VALUE
|
|
master_item:
|
|
key: azure.db.mssql.data.get
|
|
tags:
|
|
- tag: component
|
|
value: memory
|
|
- tag: component
|
|
value: server
|
|
- uuid: b9d6045642de46e08c45cca9b619bf75
|
|
name: 'Sessions count'
|
|
type: DEPENDENT
|
|
key: azure.db.mssql.sessions.count
|
|
delay: '0'
|
|
value_type: FLOAT
|
|
description: 'The number of active sessions. Not applicable to Synapse DW Analytics.'
|
|
preprocessing:
|
|
- type: JSONPATH
|
|
parameters:
|
|
- $.metrics.sessions_count.average
|
|
error_handler: DISCARD_VALUE
|
|
master_item:
|
|
key: azure.db.mssql.data.get
|
|
tags:
|
|
- tag: component
|
|
value: sessions
|
|
- uuid: 62298388449448e18fb0efb5b139b79c
|
|
name: 'Sessions percentage'
|
|
type: DEPENDENT
|
|
key: azure.db.mssql.sessions.percent
|
|
delay: '0'
|
|
value_type: FLOAT
|
|
units: '%'
|
|
description: 'The percentage of sessions. Not applicable to data warehouses.'
|
|
preprocessing:
|
|
- type: JSONPATH
|
|
parameters:
|
|
- $.metrics.sessions_percent.average
|
|
error_handler: DISCARD_VALUE
|
|
master_item:
|
|
key: azure.db.mssql.data.get
|
|
tags:
|
|
- tag: component
|
|
value: sessions
|
|
- uuid: e5cec53daadf40f79f580af1df77c35c
|
|
name: 'Data space allocated'
|
|
type: DEPENDENT
|
|
key: azure.db.mssql.storage.allocated
|
|
delay: '0'
|
|
value_type: FLOAT
|
|
units: B
|
|
description: 'The allocated data storage. Not applicable to data warehouses.'
|
|
preprocessing:
|
|
- type: JSONPATH
|
|
parameters:
|
|
- $.metrics.allocated_data_storage.average
|
|
error_handler: DISCARD_VALUE
|
|
master_item:
|
|
key: azure.db.mssql.data.get
|
|
tags:
|
|
- tag: component
|
|
value: storage
|
|
- uuid: 7c66b3e9b28043098a1d942c48fc0369
|
|
name: 'Log backup storage size'
|
|
type: DEPENDENT
|
|
key: azure.db.mssql.storage.backup.log.size
|
|
delay: '0'
|
|
value_type: FLOAT
|
|
units: B
|
|
description: 'The cumulative log backup storage size. Applies to vCore-based and Hyperscale databases.'
|
|
preprocessing:
|
|
- type: JSONPATH
|
|
parameters:
|
|
- $.metrics.log_backup_size_bytes.maximum
|
|
error_handler: DISCARD_VALUE
|
|
- type: DISCARD_UNCHANGED_HEARTBEAT
|
|
parameters:
|
|
- 1d
|
|
master_item:
|
|
key: azure.db.mssql.data.get
|
|
tags:
|
|
- tag: component
|
|
value: storage
|
|
- uuid: 6a09939f232f4a078aa088f0dbcf370c
|
|
name: 'Data space used percent'
|
|
type: DEPENDENT
|
|
key: azure.db.mssql.storage.percent
|
|
delay: '0'
|
|
value_type: FLOAT
|
|
units: '%'
|
|
description: 'Data space used in percent. Not applicable to data warehouses or Hyperscale databases.'
|
|
preprocessing:
|
|
- type: JSONPATH
|
|
parameters:
|
|
- $.metrics.storage_percent.maximum
|
|
error_handler: DISCARD_VALUE
|
|
master_item:
|
|
key: azure.db.mssql.data.get
|
|
tags:
|
|
- tag: component
|
|
value: storage
|
|
triggers:
|
|
- uuid: b13d1ed5b1144e0095dca50bcbba37ae
|
|
expression: 'last(/Azure Microsoft SQL DTU Database by HTTP/azure.db.mssql.storage.percent)>{$AZURE.DB.STORAGE.PUSED.CRIT}'
|
|
name: 'Azure MSSQL DTU: Storage space is critically low'
|
|
opdata: 'Current space used: {ITEM.LASTVALUE1}%'
|
|
priority: AVERAGE
|
|
description: 'Critical utilization of the storage space.'
|
|
tags:
|
|
- tag: scope
|
|
value: capacity
|
|
- uuid: 74c7b9f109924177a37bc7717c6f39e0
|
|
expression: 'last(/Azure Microsoft SQL DTU Database by HTTP/azure.db.mssql.storage.percent)>{$AZURE.DB.STORAGE.PUSED.WARN}'
|
|
name: 'Azure MSSQL DTU: Storage space is low'
|
|
opdata: 'Current space used: {ITEM.LASTVALUE1}%'
|
|
priority: WARNING
|
|
description: 'High utilization of the storage space.'
|
|
dependencies:
|
|
- name: 'Azure MSSQL DTU: Storage space is critically low'
|
|
expression: 'last(/Azure Microsoft SQL DTU Database by HTTP/azure.db.mssql.storage.percent)>{$AZURE.DB.STORAGE.PUSED.CRIT}'
|
|
tags:
|
|
- tag: scope
|
|
value: capacity
|
|
- uuid: 829a31cfbd58473fb6aca227623dd374
|
|
name: 'Data space used'
|
|
type: DEPENDENT
|
|
key: azure.db.mssql.storage.used
|
|
delay: '0'
|
|
value_type: FLOAT
|
|
units: B
|
|
description: 'Data space used. Not applicable to data warehouses.'
|
|
preprocessing:
|
|
- type: JSONPATH
|
|
parameters:
|
|
- $.metrics.storage.maximum
|
|
error_handler: DISCARD_VALUE
|
|
master_item:
|
|
key: azure.db.mssql.data.get
|
|
tags:
|
|
- tag: component
|
|
value: storage
|
|
- uuid: 154d7dd42d2849be9d3cf92e11a6f923
|
|
name: 'In-Memory OLTP storage percent'
|
|
type: DEPENDENT
|
|
key: azure.db.mssql.storage.xtp.percent
|
|
delay: '0'
|
|
value_type: FLOAT
|
|
units: '%'
|
|
description: 'In-Memory OLTP storage percent. Not applicable to data warehouses.'
|
|
preprocessing:
|
|
- type: JSONPATH
|
|
parameters:
|
|
- $.metrics.xtp_storage_percent.average
|
|
error_handler: DISCARD_VALUE
|
|
master_item:
|
|
key: azure.db.mssql.data.get
|
|
tags:
|
|
- tag: component
|
|
value: storage
|
|
- uuid: d9a7c8558eb7418eb1113342d0c6225a
|
|
name: 'Tempdb data file size'
|
|
type: DEPENDENT
|
|
key: azure.db.mssql.tempdb.data.size
|
|
delay: '0'
|
|
value_type: FLOAT
|
|
units: B
|
|
description: 'The space used in `tempdb` data files, expressed in bytes. Not applicable to data warehouses.'
|
|
preprocessing:
|
|
- type: JSONPATH
|
|
parameters:
|
|
- $.metrics.tempdb_data_size.maximum
|
|
error_handler: DISCARD_VALUE
|
|
- type: MULTIPLIER
|
|
parameters:
|
|
- '1024'
|
|
master_item:
|
|
key: azure.db.mssql.data.get
|
|
tags:
|
|
- tag: component
|
|
value: storage
|
|
- uuid: a3d555807a4247e9ba3c388ae75bb5ce
|
|
name: 'Tempdb log used percent'
|
|
type: DEPENDENT
|
|
key: azure.db.mssql.tempdb.log.percent
|
|
delay: '0'
|
|
value_type: FLOAT
|
|
units: '%'
|
|
description: 'The percentage of space used in the `tempdb` transaction log file. Not applicable to data warehouses.'
|
|
preprocessing:
|
|
- type: JSONPATH
|
|
parameters:
|
|
- $.metrics.tempdb_log_used_percent.maximum
|
|
error_handler: DISCARD_VALUE
|
|
master_item:
|
|
key: azure.db.mssql.data.get
|
|
tags:
|
|
- tag: component
|
|
value: storage
|
|
- uuid: 3e64483271b347ceb300288079451f3e
|
|
name: 'Tempdb log file size'
|
|
type: DEPENDENT
|
|
key: azure.db.mssql.tempdb.log.size
|
|
delay: '0'
|
|
value_type: FLOAT
|
|
units: B
|
|
description: 'The space used in the `tempdb` transaction log file, expressed in bytes. Not applicable to data warehouses.'
|
|
preprocessing:
|
|
- type: JSONPATH
|
|
parameters:
|
|
- $.metrics.tempdb_log_size.maximum
|
|
error_handler: DISCARD_VALUE
|
|
- type: MULTIPLIER
|
|
parameters:
|
|
- '1024'
|
|
master_item:
|
|
key: azure.db.mssql.data.get
|
|
tags:
|
|
- tag: component
|
|
value: storage
|
|
- uuid: 75ad7da5a2c74022ace6f28fed2c8ef2
|
|
name: 'Workers percentage'
|
|
type: DEPENDENT
|
|
key: azure.db.mssql.workers.percent
|
|
delay: '0'
|
|
value_type: FLOAT
|
|
units: '%'
|
|
description: 'The percentage of workers. Not applicable to data warehouses.'
|
|
preprocessing:
|
|
- type: JSONPATH
|
|
parameters:
|
|
- $.metrics.workers_percent.average
|
|
error_handler: DISCARD_VALUE
|
|
master_item:
|
|
key: azure.db.mssql.data.get
|
|
tags:
|
|
- tag: component
|
|
value: workers
|
|
tags:
|
|
- tag: class
|
|
value: software
|
|
- tag: target
|
|
value: azure
|
|
- tag: target
|
|
value: mssql
|
|
macros:
|
|
- macro: '{$AZURE.APP.ID}'
|
|
description: 'The App ID of Microsoft Azure.'
|
|
- macro: '{$AZURE.DATA.TIMEOUT}'
|
|
value: 15s
|
|
description: 'API response timeout.'
|
|
- macro: '{$AZURE.DB.CPU.UTIL.CRIT}'
|
|
value: '90'
|
|
description: 'The critical threshold of CPU utilization, expressed in %.'
|
|
- macro: '{$AZURE.DB.DTU.UTIL.CRIT}'
|
|
value: '90'
|
|
description: 'The critical threshold of DTU utilization, expressed in %.'
|
|
- macro: '{$AZURE.DB.MEMORY.UTIL.CRIT}'
|
|
value: '90'
|
|
description: 'The critical threshold of memory utilization, expressed in %.'
|
|
- macro: '{$AZURE.DB.STORAGE.PUSED.CRIT}'
|
|
value: '90'
|
|
description: 'The critical threshold of storage utilization, expressed in %.'
|
|
- macro: '{$AZURE.DB.STORAGE.PUSED.WARN}'
|
|
value: '80'
|
|
description: 'The warning threshold of storage utilization, expressed in %.'
|
|
- macro: '{$AZURE.PASSWORD}'
|
|
type: SECRET_TEXT
|
|
description: 'Microsoft Azure password.'
|
|
- macro: '{$AZURE.PROXY}'
|
|
description: 'Sets the HTTP proxy value. If this macro is empty, then no proxy is used.'
|
|
- macro: '{$AZURE.RESOURCE.ID}'
|
|
description: 'Microsoft Azure SQL DTU-based database ID.'
|
|
- macro: '{$AZURE.SUBSCRIPTION.ID}'
|
|
description: 'Microsoft Azure subscription ID.'
|
|
- macro: '{$AZURE.TENANT.ID}'
|
|
description: 'Microsoft Azure tenant ID.'
|
|
- macro: '{$HTTP.TLS.VERIFY}'
|
|
value: full
|
|
description: 'TLS certificate verification for script items: "none" - disabled, "peer" - verify the certificate chain and expiration, "full" - full verification. Any other value enables full verification. To override the setting for this template only, define the macro with the context "Azure Microsoft SQL DTU Database", e.g. {$HTTP.TLS.VERIFY:"Azure Microsoft SQL DTU Database"}.'
|
|
dashboards:
|
|
- uuid: 0e19ba53f50c48c3bce738d5420096cb
|
|
name: 'Overview Azure Microsoft SQL Database'
|
|
pages:
|
|
- widgets:
|
|
- type: item
|
|
name: Deadlocks
|
|
width: '12'
|
|
height: '3'
|
|
fields:
|
|
- type: INTEGER
|
|
name: decimal_places
|
|
value: '0'
|
|
- type: ITEM
|
|
name: itemid.0
|
|
value:
|
|
host: 'Azure Microsoft SQL DTU Database by HTTP'
|
|
key: azure.db.mssql.deadlocks
|
|
- type: INTEGER
|
|
name: show.0
|
|
value: '4'
|
|
- type: INTEGER
|
|
name: show.1
|
|
value: '2'
|
|
- type: item
|
|
name: 'SQL Server process memory percent'
|
|
'y': '3'
|
|
width: '12'
|
|
height: '3'
|
|
fields:
|
|
- type: ITEM
|
|
name: itemid.0
|
|
value:
|
|
host: 'Azure Microsoft SQL DTU Database by HTTP'
|
|
key: azure.db.mssql.server.memory.percent
|
|
- type: INTEGER
|
|
name: show.0
|
|
value: '4'
|
|
- type: INTEGER
|
|
name: show.1
|
|
value: '2'
|
|
- type: STRING
|
|
name: units
|
|
value: '%'
|
|
- type: item
|
|
name: 'DTU limit'
|
|
'y': '6'
|
|
width: '12'
|
|
height: '3'
|
|
fields:
|
|
- type: ITEM
|
|
name: itemid.0
|
|
value:
|
|
host: 'Azure Microsoft SQL DTU Database by HTTP'
|
|
key: azure.db.mssql.dtu.limit
|
|
- type: INTEGER
|
|
name: show.0
|
|
value: '4'
|
|
- type: INTEGER
|
|
name: show.1
|
|
value: '2'
|
|
- type: item
|
|
name: 'Data space allocated'
|
|
'y': '9'
|
|
width: '12'
|
|
height: '3'
|
|
fields:
|
|
- type: ITEM
|
|
name: itemid.0
|
|
value:
|
|
host: 'Azure Microsoft SQL DTU Database by HTTP'
|
|
key: azure.db.mssql.storage.allocated
|
|
- type: INTEGER
|
|
name: show.0
|
|
value: '4'
|
|
- type: INTEGER
|
|
name: show.1
|
|
value: '2'
|
|
- type: item
|
|
name: 'Connections successful'
|
|
'y': '12'
|
|
width: '12'
|
|
height: '3'
|
|
fields:
|
|
- type: ITEM
|
|
name: itemid.0
|
|
value:
|
|
host: 'Azure Microsoft SQL DTU Database by HTTP'
|
|
key: azure.db.mssql.connections.successful
|
|
- type: INTEGER
|
|
name: show.0
|
|
value: '4'
|
|
- type: INTEGER
|
|
name: show.1
|
|
value: '2'
|
|
- type: item
|
|
name: 'Availability state'
|
|
x: '12'
|
|
width: '12'
|
|
height: '3'
|
|
fields:
|
|
- type: ITEM
|
|
name: itemid.0
|
|
value:
|
|
host: 'Azure Microsoft SQL DTU Database by HTTP'
|
|
key: azure.db.mssql.availability.state
|
|
- type: INTEGER
|
|
name: show.0
|
|
value: '4'
|
|
- type: INTEGER
|
|
name: show.1
|
|
value: '2'
|
|
- type: STRING
|
|
name: up_color
|
|
value: FF0000
|
|
- type: item
|
|
name: 'SQL Server process core percent'
|
|
x: '12'
|
|
'y': '3'
|
|
width: '12'
|
|
height: '3'
|
|
fields:
|
|
- type: ITEM
|
|
name: itemid.0
|
|
value:
|
|
host: 'Azure Microsoft SQL DTU Database by HTTP'
|
|
key: azure.db.mssql.server.cpu.percent
|
|
- type: INTEGER
|
|
name: show.0
|
|
value: '4'
|
|
- type: INTEGER
|
|
name: show.1
|
|
value: '2'
|
|
- type: STRING
|
|
name: units
|
|
value: '%'
|
|
- type: item
|
|
name: 'DTU used'
|
|
x: '12'
|
|
'y': '6'
|
|
width: '12'
|
|
height: '3'
|
|
fields:
|
|
- type: ITEM
|
|
name: itemid.0
|
|
value:
|
|
host: 'Azure Microsoft SQL DTU Database by HTTP'
|
|
key: azure.db.mssql.dtu.used
|
|
- type: INTEGER
|
|
name: show.0
|
|
value: '4'
|
|
- type: INTEGER
|
|
name: show.1
|
|
value: '2'
|
|
- type: item
|
|
name: 'Data space used'
|
|
x: '12'
|
|
'y': '9'
|
|
width: '12'
|
|
height: '3'
|
|
fields:
|
|
- type: ITEM
|
|
name: itemid.0
|
|
value:
|
|
host: 'Azure Microsoft SQL DTU Database by HTTP'
|
|
key: azure.db.mssql.storage.used
|
|
- type: INTEGER
|
|
name: show.0
|
|
value: '4'
|
|
- type: INTEGER
|
|
name: show.1
|
|
value: '2'
|
|
- type: item
|
|
name: 'Connections failed: System errors'
|
|
x: '12'
|
|
'y': '12'
|
|
width: '12'
|
|
height: '3'
|
|
fields:
|
|
- type: ITEM
|
|
name: itemid.0
|
|
value:
|
|
host: 'Azure Microsoft SQL DTU Database by HTTP'
|
|
key: azure.db.mssql.connections.failed.system
|
|
- type: INTEGER
|
|
name: show.0
|
|
value: '4'
|
|
- type: INTEGER
|
|
name: show.1
|
|
value: '2'
|
|
- type: itemhistory
|
|
name: 'Availability status detailed'
|
|
x: '24'
|
|
width: '48'
|
|
height: '3'
|
|
fields:
|
|
- type: INTEGER
|
|
name: columns.0.display
|
|
value: '4'
|
|
- type: ITEM
|
|
name: columns.0.itemid
|
|
value:
|
|
host: 'Azure Microsoft SQL DTU Database by HTTP'
|
|
key: azure.db.mssql.availability.details
|
|
- type: INTEGER
|
|
name: columns.0.monospace_font
|
|
value: '1'
|
|
- type: STRING
|
|
name: columns.0.name
|
|
value: 'Azure Microsoft SQL: Availability status detailed'
|
|
- type: STRING
|
|
name: reference
|
|
value: BAAAG
|
|
- type: INTEGER
|
|
name: show_timestamp
|
|
value: '1'
|
|
- type: item
|
|
name: 'Sessions count'
|
|
x: '24'
|
|
'y': '3'
|
|
width: '12'
|
|
height: '3'
|
|
fields:
|
|
- type: ITEM
|
|
name: itemid.0
|
|
value:
|
|
host: 'Azure Microsoft SQL DTU Database by HTTP'
|
|
key: azure.db.mssql.sessions.count
|
|
- type: INTEGER
|
|
name: show.0
|
|
value: '4'
|
|
- type: INTEGER
|
|
name: show.1
|
|
value: '2'
|
|
- type: graph
|
|
name: 'DTU percentage'
|
|
x: '24'
|
|
'y': '6'
|
|
width: '48'
|
|
height: '3'
|
|
fields:
|
|
- type: GRAPH
|
|
name: graphid.0
|
|
value:
|
|
host: 'Azure Microsoft SQL DTU Database by HTTP'
|
|
name: 'Azure Microsoft SQL: DTU usage'
|
|
- type: STRING
|
|
name: reference
|
|
value: AAAAA
|
|
- type: graph
|
|
name: 'Storage utilization'
|
|
x: '24'
|
|
'y': '9'
|
|
width: '48'
|
|
height: '3'
|
|
fields:
|
|
- type: GRAPH
|
|
name: graphid.0
|
|
value:
|
|
host: 'Azure Microsoft SQL DTU Database by HTTP'
|
|
name: 'Azure Microsoft SQL: Storage utilization'
|
|
- type: STRING
|
|
name: reference
|
|
value: AAAAB
|
|
- type: graph
|
|
name: Connections
|
|
x: '24'
|
|
'y': '12'
|
|
width: '48'
|
|
height: '3'
|
|
fields:
|
|
- type: GRAPH
|
|
name: graphid.0
|
|
value:
|
|
host: 'Azure Microsoft SQL DTU Database by HTTP'
|
|
name: 'Azure Microsoft SQL: Connections'
|
|
- type: STRING
|
|
name: reference
|
|
value: AAAAC
|
|
- type: item
|
|
name: 'Workers percentage'
|
|
x: '36'
|
|
'y': '3'
|
|
width: '12'
|
|
height: '3'
|
|
fields:
|
|
- type: ITEM
|
|
name: itemid.0
|
|
value:
|
|
host: 'Azure Microsoft SQL DTU Database by HTTP'
|
|
key: azure.db.mssql.workers.percent
|
|
- type: INTEGER
|
|
name: show.0
|
|
value: '4'
|
|
- type: INTEGER
|
|
name: show.1
|
|
value: '2'
|
|
- type: STRING
|
|
name: units
|
|
value: '%'
|
|
- type: item
|
|
name: 'CPU percentage'
|
|
x: '48'
|
|
'y': '3'
|
|
width: '12'
|
|
height: '3'
|
|
fields:
|
|
- type: ITEM
|
|
name: itemid.0
|
|
value:
|
|
host: 'Azure Microsoft SQL DTU Database by HTTP'
|
|
key: azure.db.mssql.cpu.percentage
|
|
- type: INTEGER
|
|
name: show.0
|
|
value: '4'
|
|
- type: INTEGER
|
|
name: show.1
|
|
value: '2'
|
|
- type: STRING
|
|
name: units
|
|
value: '%'
|
|
- type: item
|
|
name: 'Data IO percentage'
|
|
x: '60'
|
|
'y': '3'
|
|
width: '12'
|
|
height: '3'
|
|
fields:
|
|
- type: ITEM
|
|
name: itemid.0
|
|
value:
|
|
host: 'Azure Microsoft SQL DTU Database by HTTP'
|
|
key: azure.db.mssql.data.read.percentage
|
|
- type: INTEGER
|
|
name: show.0
|
|
value: '4'
|
|
- type: INTEGER
|
|
name: show.1
|
|
value: '2'
|
|
- type: STRING
|
|
name: units
|
|
value: '%'
|
|
valuemaps:
|
|
- uuid: 34874b4cf9cb4ce2863a5698ff308126
|
|
name: 'Azure resource health state'
|
|
mappings:
|
|
- value: '0'
|
|
newvalue: Available
|
|
- value: '1'
|
|
newvalue: Degraded
|
|
- value: '2'
|
|
newvalue: Unavailable
|
|
- value: '3'
|
|
newvalue: Unknown
|
|
graphs:
|
|
- uuid: a266fd856e0f49288ee96b98c6fce4b9
|
|
name: 'Azure Microsoft SQL: Connections'
|
|
graph_items:
|
|
- color: 199C0D
|
|
item:
|
|
host: 'Azure Microsoft SQL DTU Database by HTTP'
|
|
key: azure.db.mssql.connections.successful
|
|
- sortorder: '1'
|
|
color: F63100
|
|
item:
|
|
host: 'Azure Microsoft SQL DTU Database by HTTP'
|
|
key: azure.db.mssql.connections.failed.system
|
|
- sortorder: '2'
|
|
color: 00611C
|
|
item:
|
|
host: 'Azure Microsoft SQL DTU Database by HTTP'
|
|
key: azure.db.mssql.firewall.blocked
|
|
- uuid: 0849698704cb40cab4ce62d3eb093717
|
|
name: 'Azure Microsoft SQL: DTU usage'
|
|
graph_items:
|
|
- color: 199C0D
|
|
item:
|
|
host: 'Azure Microsoft SQL DTU Database by HTTP'
|
|
key: azure.db.mssql.dtu.limit
|
|
- sortorder: '1'
|
|
color: F63100
|
|
item:
|
|
host: 'Azure Microsoft SQL DTU Database by HTTP'
|
|
key: azure.db.mssql.dtu.used
|
|
- uuid: 3aebd39180de4314a7129d2c5deb6b6a
|
|
name: 'Azure Microsoft SQL: Storage utilization'
|
|
graph_items:
|
|
- color: 199C0D
|
|
item:
|
|
host: 'Azure Microsoft SQL DTU Database by HTTP'
|
|
key: azure.db.mssql.storage.used
|
|
- sortorder: '1'
|
|
color: F63100
|
|
item:
|
|
host: 'Azure Microsoft SQL DTU Database by HTTP'
|
|
key: azure.db.mssql.storage.allocated
|