Azure SQL Managed Instance monitoring and integration with Zabbix

admin

Get data

Gathers data of the Azure SQL managed instance.

Script azure.sql_inst.data.get Get errors

A list of errors from API requests.

Dependent item azure.sql_inst.data.errors

Preprocessing

Availability state

The availability status of the resource.

0 – Available – no events detected that affect the health of the resource.

1 – Degraded – your resource detected a loss in performance, although it’s still available for use.

2 – Unavailable – the service detected an ongoing platform or non-platform event that affects the health of the resource.

3 – Unknown – Resource Health hasn’t received information about the resource for more than 10 minutes.

Dependent item azure.sql_inst.availability.state

Preprocessing

  • JSON Path: $.health.availabilityState

    ⛔️Custom on fail: Set value to: 3

  • Replace: Available -> 0

  • Replace: Degraded -> 1

  • Replace: Unavailable -> 2

  • Replace: Unknown -> 3

  • In range: 0 -> 3

    ⛔️Custom on fail: Set value to: 3

  • Discard unchanged with heartbeat: 1h

Availability status detailed

The summary description of the availability status.

Dependent item azure.sql_inst.availability.details

Preprocessing

  • JSON Path: $.health.summary

    ⛔️Custom on fail: Discard value

  • Discard unchanged with heartbeat: 1h

Average CPU utilization

Average CPU utilization of the instance.

Dependent item azure.sql_inst.cpu

Preprocessing

IO bytes read

Bytes read by the managed instance.

Dependent item azure.sql_inst.bytes.read

Preprocessing

IO bytes write

Bytes written by the managed instance.

Dependent item azure.sql_inst.bytes.write

Preprocessing

IO request count

IO request count by the managed instance.

Dependent item azure.sql_inst.requests

Preprocessing

Storage space reserved

Storage space reserved by the managed instance.

Dependent item azure.sql_inst.storage.reserved

Preprocessing

  • JSON Path: $.metrics.reserved_storage_mb.average

    ⛔️Custom on fail: Discard value

  • Custom multiplier: 1048576

  • Discard unchanged with heartbeat: 1h

Storage space used

Storage space used by the managed instance.

Dependent item azure.sql_inst.storage.used

Preprocessing

  • JSON Path: $.metrics.storage_space_used_mb.average

    ⛔️Custom on fail: Discard value

  • Custom multiplier: 1048576

Storage space utilization

Managed instance storage space utilization, in percent.

Calculated azure.sql_inst.storage.utilization Virtual core count

Virtual core count available to the managed instance.

Dependent item azure.sql_inst.core.count

Preprocessing

  • JSON Path: $.metrics.virtual_core_count.average

    ⛔️Custom on fail: Discard value

  • Discard unchanged with heartbeat: 1h

Instance state

State of the managed instance.

Dependent item azure.sql_inst.state

Preprocessing

  • JSON Path: $.instance.properties.state

    ⛔️Custom on fail: Discard value

  • Discard unchanged with heartbeat: 1h

Instance collation

Collation of the managed instance.

Dependent item azure.sql_inst.collation

Preprocessing

  • JSON Path: $.instance.properties.collation

    ⛔️Custom on fail: Discard value

  • Discard unchanged with heartbeat: 1d

Instance provisioning state

Provisioning state of the managed instance.

Dependent item azure.sql_inst.provision

Preprocessing

  • JSON Path: $.instance.properties.provisioningState

    ⛔️Custom on fail: Discard value

  • JavaScript: The text is too long. Please see the template.

  • Discard unchanged with heartbeat: 1h

Read more here: Source link