1217 lines
46 KiB
YAML
1217 lines
46 KiB
YAML
zabbix_export:
|
|
version: '7.0'
|
|
template_groups:
|
|
- uuid: c2c162144c2d4c5491c8801193af4945
|
|
name: Templates/Cloud
|
|
templates:
|
|
- uuid: 35ef29f24158444097272d2ea7fa6044
|
|
template: 'Azure PostgreSQL Flexible Server by HTTP'
|
|
name: 'Azure PostgreSQL Flexible Server by HTTP'
|
|
description: |
|
|
This template is designed to monitor Microsoft Azure PostgreSQL flexible servers by 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-3
|
|
groups:
|
|
- name: Templates/Cloud
|
|
items:
|
|
- uuid: 7f7deae517e54cf582ae758a6988037b
|
|
name: 'Availability status detailed'
|
|
type: DEPENDENT
|
|
key: azure.db.pgsql.availability.details
|
|
delay: '0'
|
|
value_type: CHAR
|
|
trends: '0'
|
|
description: 'The summary description of the availability status.'
|
|
preprocessing:
|
|
- type: JSONPATH
|
|
parameters:
|
|
- $.health.summary
|
|
- type: DISCARD_UNCHANGED_HEARTBEAT
|
|
parameters:
|
|
- 1h
|
|
master_item:
|
|
key: azure.db.pgsql.data.get
|
|
tags:
|
|
- tag: component
|
|
value: health
|
|
- uuid: cd9072a3895c42dab794707f3bcaf743
|
|
name: 'Availability state'
|
|
type: DEPENDENT
|
|
key: azure.db.pgsql.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.pgsql.data.get
|
|
tags:
|
|
- tag: component
|
|
value: health
|
|
triggers:
|
|
- uuid: 65b5c39b48e248c4866c511bbba91e1b
|
|
expression: 'last(/Azure PostgreSQL Flexible Server by HTTP/azure.db.pgsql.availability.state)=1'
|
|
name: 'Azure PostgreSQL Flexible: PostgreSQL server is degraded'
|
|
opdata: '{ITEM.LASTVALUE1}'
|
|
priority: AVERAGE
|
|
description: 'The resource is in a degraded state.'
|
|
tags:
|
|
- tag: scope
|
|
value: availability
|
|
- uuid: d8ce86c853064cba80c9883052ed1403
|
|
expression: 'last(/Azure PostgreSQL Flexible Server by HTTP/azure.db.pgsql.availability.state)=3'
|
|
name: 'Azure PostgreSQL Flexible: PostgreSQL server is in unknown state'
|
|
opdata: '{ITEM.LASTVALUE1}'
|
|
priority: WARNING
|
|
description: 'The resource state is unknown.'
|
|
tags:
|
|
- tag: scope
|
|
value: availability
|
|
- uuid: 9572c9e56a6b44368bcf2d8a17a220d8
|
|
expression: 'last(/Azure PostgreSQL Flexible Server by HTTP/azure.db.pgsql.availability.state)=2'
|
|
name: 'Azure PostgreSQL Flexible: PostgreSQL server is unavailable'
|
|
opdata: '{ITEM.LASTVALUE1}'
|
|
priority: HIGH
|
|
description: 'The resource state is unavailable.'
|
|
tags:
|
|
- tag: scope
|
|
value: availability
|
|
- uuid: 05ada75c666e45269c3c36159f9902cc
|
|
name: 'Connections active'
|
|
type: DEPENDENT
|
|
key: azure.db.pgsql.connections.active
|
|
delay: '0'
|
|
value_type: FLOAT
|
|
description: 'The count of active connections.'
|
|
preprocessing:
|
|
- type: JSONPATH
|
|
parameters:
|
|
- $.metrics.active_connections.average
|
|
master_item:
|
|
key: azure.db.pgsql.data.get
|
|
tags:
|
|
- tag: component
|
|
value: network
|
|
- uuid: 00d1116141874dbfb204ebfe96c203f1
|
|
name: 'Connections failed'
|
|
type: DEPENDENT
|
|
key: azure.db.pgsql.connections.failed
|
|
delay: '0'
|
|
value_type: FLOAT
|
|
description: 'The count of failed connections.'
|
|
preprocessing:
|
|
- type: JSONPATH
|
|
parameters:
|
|
- $.metrics.connections_failed.total
|
|
error_handler: DISCARD_VALUE
|
|
master_item:
|
|
key: azure.db.pgsql.data.get
|
|
tags:
|
|
- tag: component
|
|
value: network
|
|
- uuid: f422f01bf1c9484e880581f31f70e120
|
|
name: 'Connections succeeded'
|
|
type: DEPENDENT
|
|
key: azure.db.pgsql.connections.succeeded
|
|
delay: '0'
|
|
value_type: FLOAT
|
|
description: 'The count of succeeded connections.'
|
|
preprocessing:
|
|
- type: JSONPATH
|
|
parameters:
|
|
- $.metrics.connections_succeeded.total
|
|
master_item:
|
|
key: azure.db.pgsql.data.get
|
|
tags:
|
|
- tag: component
|
|
value: network
|
|
- uuid: 1f1270c6981b4d08864572410fdeccde
|
|
name: 'CPU credits consumed'
|
|
type: DEPENDENT
|
|
key: azure.db.pgsql.cpu.credits.consumed
|
|
delay: '0'
|
|
value_type: FLOAT
|
|
description: 'The total number of credits consumed by the database server.'
|
|
preprocessing:
|
|
- type: JSONPATH
|
|
parameters:
|
|
- $.metrics.cpu_credits_consumed.average
|
|
error_handler: DISCARD_VALUE
|
|
master_item:
|
|
key: azure.db.pgsql.data.get
|
|
tags:
|
|
- tag: component
|
|
value: cpu
|
|
- uuid: e55082c4a278435286335cebd2ae1cac
|
|
name: 'CPU credits remaining'
|
|
type: DEPENDENT
|
|
key: azure.db.pgsql.cpu.credits.remaining
|
|
delay: '0'
|
|
value_type: FLOAT
|
|
description: 'The total number of credits available to burst.'
|
|
preprocessing:
|
|
- type: JSONPATH
|
|
parameters:
|
|
- $.metrics.cpu_credits_remaining.average
|
|
error_handler: DISCARD_VALUE
|
|
master_item:
|
|
key: azure.db.pgsql.data.get
|
|
tags:
|
|
- tag: component
|
|
value: cpu
|
|
- uuid: 8d85c5c73c894cdda6324832a703fea2
|
|
name: 'Percentage CPU'
|
|
type: DEPENDENT
|
|
key: azure.db.pgsql.cpu.percentage
|
|
delay: '0'
|
|
value_type: FLOAT
|
|
units: '%'
|
|
description: 'The CPU percent of a host.'
|
|
preprocessing:
|
|
- type: JSONPATH
|
|
parameters:
|
|
- $.metrics.cpu_percent.average
|
|
master_item:
|
|
key: azure.db.pgsql.data.get
|
|
tags:
|
|
- tag: component
|
|
value: cpu
|
|
triggers:
|
|
- uuid: f8672e4488b740a9a17395689c3d853c
|
|
expression: 'min(/Azure PostgreSQL Flexible Server by HTTP/azure.db.pgsql.cpu.percentage,5m)>{$AZURE.DB.CPU.UTIL.CRIT}'
|
|
name: 'Azure PostgreSQL Flexible: 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: 06c4226667ec4c4489e6d3ad31c3135f
|
|
name: 'Get errors'
|
|
type: DEPENDENT
|
|
key: azure.db.pgsql.data.errors
|
|
delay: '0'
|
|
value_type: TEXT
|
|
trends: '0'
|
|
description: 'A list of errors from API requests.'
|
|
preprocessing:
|
|
- type: JSONPATH
|
|
parameters:
|
|
- $.errors
|
|
- type: DISCARD_UNCHANGED_HEARTBEAT
|
|
parameters:
|
|
- 1h
|
|
master_item:
|
|
key: azure.db.pgsql.data.get
|
|
tags:
|
|
- tag: component
|
|
value: raw
|
|
triggers:
|
|
- uuid: 55962f0d8a4c44c9a6b09da705e94c59
|
|
expression: 'length(last(/Azure PostgreSQL Flexible Server by HTTP/azure.db.pgsql.data.errors))>0'
|
|
name: 'Azure PostgreSQL Flexible: There are errors in requests to API'
|
|
opdata: '{ITEM.LASTVALUE1}'
|
|
priority: AVERAGE
|
|
description: 'Zabbix has received errors in response to API requests.'
|
|
tags:
|
|
- tag: scope
|
|
value: availability
|
|
- uuid: 1792c0566e8a438dad5e299d8f5b9094
|
|
name: 'Get data'
|
|
type: SCRIPT
|
|
key: azure.db.pgsql.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 AzureDB = {
|
|
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 + '.';
|
|
}
|
|
});
|
|
|
|
AzureDB.params = params;
|
|
AzureDB.tls = new CTlsConfig(params.tls_verify);
|
|
},
|
|
|
|
|
|
request: function (url, data) {
|
|
if (typeof data === 'undefined' || data === null) {
|
|
data = '';
|
|
}
|
|
|
|
var response, request = new HttpRequest(AzureDB.tls.options);
|
|
if (typeof AzureDB.params.proxy !== 'undefined' && AzureDB.params.proxy !== '') {
|
|
request.setProxy(AzureDB.params.proxy);
|
|
}
|
|
if (AzureDB.token) {
|
|
request.addHeader('Accept: application/json');
|
|
request.addHeader('Authorization: Bearer ' + AzureDB.token);
|
|
}
|
|
|
|
Zabbix.log(4, '[ Azure ] Sending request: ' + url);
|
|
|
|
if (data !== '') {
|
|
request.addHeader('Content-Type: application/x-www-form-urlencoded');
|
|
response = request.post(url, data);
|
|
}
|
|
else {
|
|
response = request.get(url);
|
|
}
|
|
|
|
Zabbix.log(4, '[ Azure ] Received response with status code ' + request.getStatus() + ': ' + response);
|
|
|
|
if (request.getStatus() !== 200 || response === null) {
|
|
throw 'Request failed with status code ' + request.getStatus() + ': ' + response;
|
|
}
|
|
|
|
try {
|
|
return JSON.parse(response);
|
|
}
|
|
catch (error) {
|
|
throw 'Failed to parse response received from API.';
|
|
}
|
|
}
|
|
|
|
};
|
|
|
|
var metrics = [
|
|
'cpu_percent',
|
|
'memory_percent',
|
|
'iops',
|
|
'disk_queue_depth',
|
|
'read_throughput',
|
|
'write_throughput',
|
|
'read_iops',
|
|
'write_iops',
|
|
'network_bytes_egress',
|
|
'network_bytes_ingress',
|
|
'active_connections',
|
|
'connections_failed',
|
|
'connections_succeeded',
|
|
'storage_percent',
|
|
'storage_used',
|
|
'storage_free',
|
|
'txlogs_storage_used',
|
|
'backup_storage_used',
|
|
'maximum_used_transactionIDs',
|
|
'cpu_credits_remaining',
|
|
'cpu_credits_consumed'
|
|
],
|
|
prepared_metrics = [],
|
|
data = {};
|
|
data['errors'] = {};
|
|
data['metrics'] = {};
|
|
|
|
try {
|
|
AzureDB.setParams(JSON.parse(value));
|
|
|
|
try {
|
|
result = AzureDB.request(
|
|
'https://login.microsoftonline.com/' + encodeURIComponent(AzureDB.params.tenant_id) + '/oauth2/token',
|
|
'grant_type=client_credentials&resource=' + encodeURIComponent('https://management.azure.com/') + '&client_id=' + encodeURIComponent(AzureDB.params.app_id) + '&client_secret=' + encodeURIComponent(AzureDB.params.password)
|
|
);
|
|
|
|
if ('access_token' in result) {
|
|
AzureDB.token = result['access_token'];
|
|
} else {
|
|
throw 'Auth response does not contain access token.';
|
|
}
|
|
}
|
|
catch (error) {
|
|
data.errors.auth = error.toString();
|
|
}
|
|
|
|
if (!('auth' in data.errors)) {
|
|
try {
|
|
health = AzureDB.request('https://management.azure.com' + AzureDB.params.resource_id + '/providers/Microsoft.ResourceHealth/availabilityStatuses?api-version=2020-05-01');
|
|
if ('value' in health && Array.isArray(health.value) && health.value.length > 0 && 'properties' in health.value[0] && typeof health.value[0].properties === 'object') {
|
|
data.health = health.value[0].properties;
|
|
}
|
|
}
|
|
catch (error) {
|
|
data.errors.health = error.toString();
|
|
}
|
|
|
|
for (var i = 0; i < metrics.length; i += 20) {
|
|
var chunk = metrics.slice(i, i + 20);
|
|
|
|
prepared_metrics.push(
|
|
chunk.map(function (element) {
|
|
return encodeURIComponent(element);
|
|
}).join(',')
|
|
);
|
|
}
|
|
|
|
start_date = new Date((new Date().getTime()) - 600000).toISOString().replace(/\.\d+/, '');
|
|
end_date = new Date().toISOString().replace(/\.\d+/, '');
|
|
|
|
for (var j in prepared_metrics) {
|
|
try {
|
|
metrics_data = AzureDB.request('https://management.azure.com' + AzureDB.params.resource_id + '/providers/Microsoft.Insights/metrics?metricnames=' + prepared_metrics[j] + '×pan=' + encodeURIComponent(start_date) + '/' + encodeURIComponent(end_date) + '&api-version=2021-05-01');
|
|
if ('value' in metrics_data && Array.isArray(metrics_data.value) && metrics_data.value.length > 0) {
|
|
for (k in metrics_data.value) {
|
|
if ('name' in metrics_data.value[k] && typeof metrics_data.value[k].name === 'object' && 'value' in metrics_data.value[k].name && typeof metrics_data.value[k].name.value === 'string' && 'timeseries' in metrics_data.value[k] && Array.isArray(metrics_data.value[k].timeseries) && metrics_data.value[k].timeseries.length > 0 && 'data' in metrics_data.value[k].timeseries[0] && Array.isArray(metrics_data.value[k].timeseries[0].data) && metrics_data.value[k].timeseries[0].data.length > 0) {
|
|
if (metrics_data.value[k].name.value === 'disk_queue_depth' ||
|
|
metrics_data.value[k].name.value === 'read_throughput' ||
|
|
metrics_data.value[k].name.value === 'write_throughput' ||
|
|
metrics_data.value[k].name.value === 'read_iops' ||
|
|
metrics_data.value[k].name.value === 'write_iops') {
|
|
data.metrics[metrics_data.value[k].name.value.replace(/(\s|\/)+/g, '')] = metrics_data.value[k].timeseries[0].data[metrics_data.value[k].timeseries[0].data.length - 6];
|
|
} else {
|
|
data.metrics[metrics_data.value[k].name.value.replace(/(\s|\/)+/g, '')] = metrics_data.value[k].timeseries[0].data[metrics_data.value[k].timeseries[0].data.length - 1];
|
|
}
|
|
}
|
|
}
|
|
}
|
|
}
|
|
catch (error) {
|
|
data.errors[prepared_metrics[j]] = error.toString();
|
|
}
|
|
}
|
|
}
|
|
}
|
|
catch (error) {
|
|
data.errors.params = error.toString();
|
|
}
|
|
|
|
if (Object.keys(data.errors).length !== 0) {
|
|
errors = 'Failed to receive data:';
|
|
for (var error in data.errors) {
|
|
errors += '\n' + error + ' : ' + data.errors[error];
|
|
}
|
|
data.errors = errors;
|
|
}
|
|
else {
|
|
data.errors = '';
|
|
}
|
|
|
|
return JSON.stringify(data);
|
|
description: 'The result of API requests is expressed in the JSON.'
|
|
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 PostgreSQL Flexible Server"}'
|
|
tags:
|
|
- tag: component
|
|
value: raw
|
|
- uuid: 9fc7a458995d4ac8a4c1d8550177471d
|
|
name: 'Data disk read Bps'
|
|
type: DEPENDENT
|
|
key: azure.db.pgsql.disk.bps.read
|
|
delay: '0'
|
|
value_type: FLOAT
|
|
units: Bps
|
|
description: 'Bytes read per second from the data disk during the monitoring period.'
|
|
preprocessing:
|
|
- type: JSONPATH
|
|
parameters:
|
|
- $.metrics.read_throughput.average
|
|
error_handler: DISCARD_VALUE
|
|
master_item:
|
|
key: azure.db.pgsql.data.get
|
|
tags:
|
|
- tag: component
|
|
value: storage
|
|
- uuid: 46c500b44164430c952be3a1b2008fb8
|
|
name: 'Data disk write Bps'
|
|
type: DEPENDENT
|
|
key: azure.db.pgsql.disk.bps.write
|
|
delay: '0'
|
|
value_type: FLOAT
|
|
units: Bps
|
|
description: 'Bytes written per second to the data disk during the monitoring period.'
|
|
preprocessing:
|
|
- type: JSONPATH
|
|
parameters:
|
|
- $.metrics.write_throughput.average
|
|
error_handler: DISCARD_VALUE
|
|
master_item:
|
|
key: azure.db.pgsql.data.get
|
|
tags:
|
|
- tag: component
|
|
value: storage
|
|
- uuid: b8812461d49a4ff5a2177c2990969c38
|
|
name: 'Data disk queue depth'
|
|
type: DEPENDENT
|
|
key: azure.db.pgsql.disk.queue.depth
|
|
delay: '0'
|
|
value_type: FLOAT
|
|
description: 'The number of outstanding I/O operations to the data disk.'
|
|
preprocessing:
|
|
- type: JSONPATH
|
|
parameters:
|
|
- $.metrics.disk_queue_depth.average
|
|
error_handler: DISCARD_VALUE
|
|
master_item:
|
|
key: azure.db.pgsql.data.get
|
|
tags:
|
|
- tag: component
|
|
value: storage
|
|
- uuid: 10dd8ed658d8442ca39ac1decf9bc2f8
|
|
name: 'Data disk IOPS'
|
|
type: DEPENDENT
|
|
key: azure.db.pgsql.iops
|
|
delay: '0'
|
|
value_type: FLOAT
|
|
units: '!ops'
|
|
description: 'I/O operations per second.'
|
|
preprocessing:
|
|
- type: JSONPATH
|
|
parameters:
|
|
- $.metrics.iops.average
|
|
master_item:
|
|
key: azure.db.pgsql.data.get
|
|
tags:
|
|
- tag: component
|
|
value: storage
|
|
- uuid: dee65b110a4842ccba8e74eefc097304
|
|
name: 'Data disk read IOPS'
|
|
type: DEPENDENT
|
|
key: azure.db.pgsql.iops.read
|
|
delay: '0'
|
|
value_type: FLOAT
|
|
units: '!ops'
|
|
description: 'The number of the data disk I/O read operations per second.'
|
|
preprocessing:
|
|
- type: JSONPATH
|
|
parameters:
|
|
- $.metrics.read_iops.average
|
|
error_handler: DISCARD_VALUE
|
|
master_item:
|
|
key: azure.db.pgsql.data.get
|
|
tags:
|
|
- tag: component
|
|
value: storage
|
|
- uuid: 805dfa040c0a4700acac4b5b1f8a4d11
|
|
name: 'Data disk write IOPS'
|
|
type: DEPENDENT
|
|
key: azure.db.pgsql.iops.write
|
|
delay: '0'
|
|
value_type: FLOAT
|
|
units: '!ops'
|
|
description: 'The number of the data disk I/O write operations per second.'
|
|
preprocessing:
|
|
- type: JSONPATH
|
|
parameters:
|
|
- $.metrics.write_iops.average
|
|
error_handler: DISCARD_VALUE
|
|
master_item:
|
|
key: azure.db.pgsql.data.get
|
|
tags:
|
|
- tag: component
|
|
value: storage
|
|
- uuid: d1d909c2dd0d42649094ec8339e08881
|
|
name: 'Memory utilization'
|
|
type: DEPENDENT
|
|
key: azure.db.pgsql.memory.percentage
|
|
delay: '0'
|
|
value_type: FLOAT
|
|
units: '%'
|
|
description: 'The memory percent of a host.'
|
|
preprocessing:
|
|
- type: JSONPATH
|
|
parameters:
|
|
- $.metrics.memory_percent.average
|
|
master_item:
|
|
key: azure.db.pgsql.data.get
|
|
tags:
|
|
- tag: component
|
|
value: memory
|
|
triggers:
|
|
- uuid: aac52a89709044ed987a365a1d5af17b
|
|
expression: 'min(/Azure PostgreSQL Flexible Server by HTTP/azure.db.pgsql.memory.percentage,5m)>{$AZURE.DB.MEMORY.UTIL.CRIT}'
|
|
name: 'Azure PostgreSQL Flexible: High memory utilization'
|
|
opdata: 'Current utilization: {ITEM.LASTVALUE1}'
|
|
priority: AVERAGE
|
|
description: 'The system is running out of free memory.'
|
|
tags:
|
|
- tag: scope
|
|
value: performance
|
|
- uuid: 040898e15a26455a9992c603ca2d45df
|
|
name: 'Network out'
|
|
type: DEPENDENT
|
|
key: azure.db.pgsql.network.egress
|
|
delay: '0'
|
|
value_type: FLOAT
|
|
units: bps
|
|
description: 'The network outbound traffic across the active connections.'
|
|
preprocessing:
|
|
- type: JSONPATH
|
|
parameters:
|
|
- $.metrics.network_bytes_egress.total
|
|
- type: MULTIPLIER
|
|
parameters:
|
|
- '0.1333'
|
|
master_item:
|
|
key: azure.db.pgsql.data.get
|
|
tags:
|
|
- tag: component
|
|
value: network
|
|
- uuid: 8e398d8b33444a148760ec33622755a6
|
|
name: 'Network in'
|
|
type: DEPENDENT
|
|
key: azure.db.pgsql.network.ingress
|
|
delay: '0'
|
|
value_type: FLOAT
|
|
units: bps
|
|
description: 'The network inbound traffic across the active connections.'
|
|
preprocessing:
|
|
- type: JSONPATH
|
|
parameters:
|
|
- $.metrics.network_bytes_ingress.total
|
|
- type: MULTIPLIER
|
|
parameters:
|
|
- '0.1333'
|
|
master_item:
|
|
key: azure.db.pgsql.data.get
|
|
tags:
|
|
- tag: component
|
|
value: network
|
|
- uuid: ebebf8b3a2884576abb250fdc2385c6f
|
|
name: 'Backup storage used'
|
|
type: DEPENDENT
|
|
key: azure.db.pgsql.storage.backup.used
|
|
delay: '0'
|
|
value_type: FLOAT
|
|
units: B
|
|
description: 'Used backup storage, expressed in bytes.'
|
|
preprocessing:
|
|
- type: JSONPATH
|
|
parameters:
|
|
- $.metrics.backup_storage_used.average
|
|
error_handler: DISCARD_VALUE
|
|
master_item:
|
|
key: azure.db.pgsql.data.get
|
|
tags:
|
|
- tag: component
|
|
value: storage
|
|
- uuid: 9bbfba89a1834798b71260536fedab55
|
|
name: 'Storage free'
|
|
type: DEPENDENT
|
|
key: azure.db.pgsql.storage.free
|
|
delay: '0'
|
|
value_type: FLOAT
|
|
units: B
|
|
description: 'Free storage space, expressed in bytes.'
|
|
preprocessing:
|
|
- type: JSONPATH
|
|
parameters:
|
|
- $.metrics.storage_free.average
|
|
master_item:
|
|
key: azure.db.pgsql.data.get
|
|
tags:
|
|
- tag: component
|
|
value: storage
|
|
- uuid: d9d97e728d1741568fce925c0fca33a8
|
|
name: 'Storage percent'
|
|
type: DEPENDENT
|
|
key: azure.db.pgsql.storage.percent
|
|
delay: '0'
|
|
value_type: FLOAT
|
|
units: '%'
|
|
description: 'The storage utilization, expressed in %.'
|
|
preprocessing:
|
|
- type: JSONPATH
|
|
parameters:
|
|
- $.metrics.storage_percent.average
|
|
master_item:
|
|
key: azure.db.pgsql.data.get
|
|
tags:
|
|
- tag: component
|
|
value: storage
|
|
triggers:
|
|
- uuid: de3142bed28340d9abe518cd3967b024
|
|
expression: 'last(/Azure PostgreSQL Flexible Server by HTTP/azure.db.pgsql.storage.percent)>{$AZURE.DB.STORAGE.PUSED.CRIT}'
|
|
name: 'Azure PostgreSQL Flexible: Storage space is critically low'
|
|
opdata: 'Current utilization: {ITEM.LASTVALUE1}'
|
|
priority: AVERAGE
|
|
description: 'Critical utilization of the storage space.'
|
|
tags:
|
|
- tag: scope
|
|
value: capacity
|
|
- uuid: e948600affaa4ff4a0ab4e50f4858c0a
|
|
expression: 'last(/Azure PostgreSQL Flexible Server by HTTP/azure.db.pgsql.storage.percent)>{$AZURE.DB.STORAGE.PUSED.WARN}'
|
|
name: 'Azure PostgreSQL Flexible: Storage space is low'
|
|
opdata: 'Current utilization: {ITEM.LASTVALUE1}'
|
|
priority: WARNING
|
|
description: 'High utilization of the storage space.'
|
|
tags:
|
|
- tag: scope
|
|
value: capacity
|
|
- uuid: 4dae6c2c1dbf4492a73fd1834cae6aad
|
|
name: 'Transaction log storage used'
|
|
type: DEPENDENT
|
|
key: azure.db.pgsql.storage.txlogs.used
|
|
delay: '0'
|
|
value_type: FLOAT
|
|
units: B
|
|
description: 'The storage space used by transaction log, expressed in bytes.'
|
|
preprocessing:
|
|
- type: JSONPATH
|
|
parameters:
|
|
- $.metrics.txlogs_storage_used.average
|
|
master_item:
|
|
key: azure.db.pgsql.data.get
|
|
tags:
|
|
- tag: component
|
|
value: storage
|
|
- uuid: 7a85b5223ec44ff8bc996c9df1673611
|
|
name: 'Storage used'
|
|
type: DEPENDENT
|
|
key: azure.db.pgsql.storage.used
|
|
delay: '0'
|
|
value_type: FLOAT
|
|
units: B
|
|
description: 'Used storage space, expressed in bytes.'
|
|
preprocessing:
|
|
- type: JSONPATH
|
|
parameters:
|
|
- $.metrics.storage_used.average
|
|
master_item:
|
|
key: azure.db.pgsql.data.get
|
|
tags:
|
|
- tag: component
|
|
value: storage
|
|
- uuid: 6df77ed1d4614ca793df56dbc70d821c
|
|
name: 'Maximum used transaction IDs'
|
|
type: DEPENDENT
|
|
key: azure.db.pgsql.txid.used.max
|
|
delay: '0'
|
|
value_type: FLOAT
|
|
description: 'The maximum number of used transaction IDs.'
|
|
preprocessing:
|
|
- type: JSONPATH
|
|
parameters:
|
|
- $.metrics.maximum_used_transactionIDs.average
|
|
master_item:
|
|
key: azure.db.pgsql.data.get
|
|
tags:
|
|
- tag: component
|
|
value: storage
|
|
tags:
|
|
- tag: class
|
|
value: software
|
|
- tag: target
|
|
value: azure
|
|
- tag: target
|
|
value: postgresql
|
|
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.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 PostgreSQL server 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 PostgreSQL Flexible Server", e.g. {$HTTP.TLS.VERIFY:"Azure PostgreSQL Flexible Server"}.'
|
|
dashboards:
|
|
- uuid: 89588d831e7348b6b41b47a2cca79190
|
|
name: 'Overview Azure PostgreSQL Flexible Server'
|
|
pages:
|
|
- widgets:
|
|
- type: item
|
|
name: 'Memory utilization'
|
|
width: '12'
|
|
height: '3'
|
|
fields:
|
|
- type: ITEM
|
|
name: itemid.0
|
|
value:
|
|
host: 'Azure PostgreSQL Flexible Server by HTTP'
|
|
key: azure.db.pgsql.memory.percentage
|
|
- type: INTEGER
|
|
name: show.0
|
|
value: '4'
|
|
- type: INTEGER
|
|
name: show.1
|
|
value: '2'
|
|
- type: STRING
|
|
name: units
|
|
value: '%'
|
|
- type: item
|
|
name: 'Data disk queue depth'
|
|
'y': '3'
|
|
width: '12'
|
|
height: '3'
|
|
fields:
|
|
- type: ITEM
|
|
name: itemid.0
|
|
value:
|
|
host: 'Azure PostgreSQL Flexible Server by HTTP'
|
|
key: azure.db.pgsql.disk.queue.depth
|
|
- type: INTEGER
|
|
name: show.0
|
|
value: '4'
|
|
- type: INTEGER
|
|
name: show.1
|
|
value: '2'
|
|
- type: item
|
|
name: 'Storage free'
|
|
'y': '6'
|
|
width: '12'
|
|
height: '3'
|
|
fields:
|
|
- type: ITEM
|
|
name: itemid.0
|
|
value:
|
|
host: 'Azure PostgreSQL Flexible Server by HTTP'
|
|
key: azure.db.pgsql.storage.free
|
|
- type: INTEGER
|
|
name: show.0
|
|
value: '4'
|
|
- type: INTEGER
|
|
name: show.1
|
|
value: '2'
|
|
- type: item
|
|
name: 'Network in'
|
|
'y': '9'
|
|
width: '12'
|
|
height: '3'
|
|
fields:
|
|
- type: ITEM
|
|
name: itemid.0
|
|
value:
|
|
host: 'Azure PostgreSQL Flexible Server by HTTP'
|
|
key: azure.db.pgsql.network.ingress
|
|
- type: INTEGER
|
|
name: show.0
|
|
value: '4'
|
|
- type: INTEGER
|
|
name: show.1
|
|
value: '2'
|
|
- type: item
|
|
name: 'Connections active'
|
|
'y': '12'
|
|
width: '12'
|
|
height: '3'
|
|
fields:
|
|
- type: ITEM
|
|
name: itemid.0
|
|
value:
|
|
host: 'Azure PostgreSQL Flexible Server by HTTP'
|
|
key: azure.db.pgsql.connections.active
|
|
- type: INTEGER
|
|
name: show.0
|
|
value: '4'
|
|
- type: INTEGER
|
|
name: show.1
|
|
value: '2'
|
|
- type: item
|
|
name: 'Percentage CPU'
|
|
x: '12'
|
|
width: '12'
|
|
height: '3'
|
|
fields:
|
|
- type: ITEM
|
|
name: itemid.0
|
|
value:
|
|
host: 'Azure PostgreSQL Flexible Server by HTTP'
|
|
key: azure.db.pgsql.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 disk IOPS'
|
|
x: '12'
|
|
'y': '3'
|
|
width: '12'
|
|
height: '3'
|
|
fields:
|
|
- type: ITEM
|
|
name: itemid.0
|
|
value:
|
|
host: 'Azure PostgreSQL Flexible Server by HTTP'
|
|
key: azure.db.pgsql.iops
|
|
- type: INTEGER
|
|
name: show.0
|
|
value: '4'
|
|
- type: INTEGER
|
|
name: show.1
|
|
value: '2'
|
|
- type: item
|
|
name: 'Storage used'
|
|
x: '12'
|
|
'y': '6'
|
|
width: '12'
|
|
height: '3'
|
|
fields:
|
|
- type: ITEM
|
|
name: itemid.0
|
|
value:
|
|
host: 'Azure PostgreSQL Flexible Server by HTTP'
|
|
key: azure.db.pgsql.storage.used
|
|
- type: INTEGER
|
|
name: show.0
|
|
value: '4'
|
|
- type: INTEGER
|
|
name: show.1
|
|
value: '2'
|
|
- type: item
|
|
name: 'Network out'
|
|
x: '12'
|
|
'y': '9'
|
|
width: '12'
|
|
height: '3'
|
|
fields:
|
|
- type: ITEM
|
|
name: itemid.0
|
|
value:
|
|
host: 'Azure PostgreSQL Flexible Server by HTTP'
|
|
key: azure.db.pgsql.network.egress
|
|
- type: INTEGER
|
|
name: show.0
|
|
value: '4'
|
|
- type: INTEGER
|
|
name: show.1
|
|
value: '2'
|
|
- type: item
|
|
name: 'Connections failed'
|
|
x: '12'
|
|
'y': '12'
|
|
width: '12'
|
|
height: '3'
|
|
fields:
|
|
- type: ITEM
|
|
name: itemid.0
|
|
value:
|
|
host: 'Azure PostgreSQL Flexible Server by HTTP'
|
|
key: azure.db.pgsql.connections.failed
|
|
- type: INTEGER
|
|
name: show.0
|
|
value: '4'
|
|
- type: INTEGER
|
|
name: show.1
|
|
value: '2'
|
|
- type: item
|
|
name: 'Availability state'
|
|
x: '24'
|
|
width: '12'
|
|
height: '3'
|
|
fields:
|
|
- type: ITEM
|
|
name: itemid.0
|
|
value:
|
|
host: 'Azure PostgreSQL Flexible Server by HTTP'
|
|
key: azure.db.pgsql.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: 'Data disk read IOPS'
|
|
x: '24'
|
|
'y': '3'
|
|
width: '12'
|
|
height: '3'
|
|
fields:
|
|
- type: ITEM
|
|
name: itemid.0
|
|
value:
|
|
host: 'Azure PostgreSQL Flexible Server by HTTP'
|
|
key: azure.db.pgsql.iops.read
|
|
- type: INTEGER
|
|
name: show.0
|
|
value: '4'
|
|
- type: INTEGER
|
|
name: show.1
|
|
value: '2'
|
|
- type: graph
|
|
name: 'Storage utilization'
|
|
x: '24'
|
|
'y': '6'
|
|
width: '48'
|
|
height: '3'
|
|
fields:
|
|
- type: GRAPH
|
|
name: graphid.0
|
|
value:
|
|
host: 'Azure PostgreSQL Flexible Server by HTTP'
|
|
name: 'Azure PostgreSQL: Storage utilization'
|
|
- type: STRING
|
|
name: reference
|
|
value: AAAAA
|
|
- type: graph
|
|
name: 'Network traffic'
|
|
x: '24'
|
|
'y': '9'
|
|
width: '48'
|
|
height: '3'
|
|
fields:
|
|
- type: GRAPH
|
|
name: graphid.0
|
|
value:
|
|
host: 'Azure PostgreSQL Flexible Server by HTTP'
|
|
name: 'Azure PostgreSQL: Network traffic'
|
|
- 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 PostgreSQL Flexible Server by HTTP'
|
|
name: 'Azure PostgreSQL: Connections'
|
|
- type: STRING
|
|
name: reference
|
|
value: AAAAC
|
|
- type: itemhistory
|
|
name: 'Availability status detailed'
|
|
x: '36'
|
|
width: '36'
|
|
height: '3'
|
|
fields:
|
|
- type: INTEGER
|
|
name: columns.0.display
|
|
value: '4'
|
|
- type: ITEM
|
|
name: columns.0.itemid
|
|
value:
|
|
host: 'Azure PostgreSQL Flexible Server by HTTP'
|
|
key: azure.db.pgsql.availability.details
|
|
- type: INTEGER
|
|
name: columns.0.monospace_font
|
|
value: '1'
|
|
- type: STRING
|
|
name: columns.0.name
|
|
value: 'Azure PostgreSQL: Availability status detailed'
|
|
- type: STRING
|
|
name: reference
|
|
value: BAAAD
|
|
- type: INTEGER
|
|
name: show_timestamp
|
|
value: '1'
|
|
- type: item
|
|
name: 'Data disk write IOPS'
|
|
x: '36'
|
|
'y': '3'
|
|
width: '12'
|
|
height: '3'
|
|
fields:
|
|
- type: ITEM
|
|
name: itemid.0
|
|
value:
|
|
host: 'Azure PostgreSQL Flexible Server by HTTP'
|
|
key: azure.db.pgsql.iops.write
|
|
- type: INTEGER
|
|
name: show.0
|
|
value: '4'
|
|
- type: INTEGER
|
|
name: show.1
|
|
value: '2'
|
|
- type: item
|
|
name: 'Data disk read Bps'
|
|
x: '48'
|
|
'y': '3'
|
|
width: '12'
|
|
height: '3'
|
|
fields:
|
|
- type: ITEM
|
|
name: itemid.0
|
|
value:
|
|
host: 'Azure PostgreSQL Flexible Server by HTTP'
|
|
key: azure.db.pgsql.disk.bps.read
|
|
- type: INTEGER
|
|
name: show.0
|
|
value: '4'
|
|
- type: INTEGER
|
|
name: show.1
|
|
value: '2'
|
|
- type: item
|
|
name: 'Data disk write Bps'
|
|
x: '60'
|
|
'y': '3'
|
|
width: '12'
|
|
height: '3'
|
|
fields:
|
|
- type: ITEM
|
|
name: itemid.0
|
|
value:
|
|
host: 'Azure PostgreSQL Flexible Server by HTTP'
|
|
key: azure.db.pgsql.disk.bps.write
|
|
- type: INTEGER
|
|
name: show.0
|
|
value: '4'
|
|
- type: INTEGER
|
|
name: show.1
|
|
value: '2'
|
|
valuemaps:
|
|
- uuid: f208cf6141c44659a2c6904ec4cd7ac3
|
|
name: 'Azure resource health state'
|
|
mappings:
|
|
- value: '0'
|
|
newvalue: Available
|
|
- value: '1'
|
|
newvalue: Degraded
|
|
- value: '2'
|
|
newvalue: Unavailable
|
|
- value: '3'
|
|
newvalue: Unknown
|
|
graphs:
|
|
- uuid: 2b60e8b1fd7c43f4ac61812e43c0e1ca
|
|
name: 'Azure PostgreSQL: Connections'
|
|
graph_items:
|
|
- color: 199C0D
|
|
item:
|
|
host: 'Azure PostgreSQL Flexible Server by HTTP'
|
|
key: azure.db.pgsql.connections.active
|
|
- sortorder: '1'
|
|
color: F63100
|
|
item:
|
|
host: 'Azure PostgreSQL Flexible Server by HTTP'
|
|
key: azure.db.pgsql.connections.succeeded
|
|
- sortorder: '2'
|
|
color: 00611C
|
|
item:
|
|
host: 'Azure PostgreSQL Flexible Server by HTTP'
|
|
key: azure.db.pgsql.connections.failed
|
|
- uuid: a4679d243b574bea84397c980723c68b
|
|
name: 'Azure PostgreSQL: Network traffic'
|
|
graph_items:
|
|
- color: 199C0D
|
|
item:
|
|
host: 'Azure PostgreSQL Flexible Server by HTTP'
|
|
key: azure.db.pgsql.network.egress
|
|
- sortorder: '1'
|
|
color: F63100
|
|
item:
|
|
host: 'Azure PostgreSQL Flexible Server by HTTP'
|
|
key: azure.db.pgsql.network.ingress
|
|
- uuid: 5fa13cfbdd784475818fae06ff94f879
|
|
name: 'Azure PostgreSQL: Storage utilization'
|
|
graph_items:
|
|
- color: 199C0D
|
|
item:
|
|
host: 'Azure PostgreSQL Flexible Server by HTTP'
|
|
key: azure.db.pgsql.storage.used
|
|
- sortorder: '1'
|
|
color: F63100
|
|
item:
|
|
host: 'Azure PostgreSQL Flexible Server by HTTP'
|
|
key: azure.db.pgsql.storage.free
|