Dostupná řešení

GCP Cloud SQL MySQL by HTTP
GCP Cloud SQL MySQL Replica by HTTP
GCP Cloud SQL PostgreSQL by HTTP
GCP Cloud SQL PostgreSQL Replica by HTTP
GCP Cloud SQL MSSQL by HTTP
GCP Cloud SQL MSSQL Replica by HTTP

Zabbix version 7.4 7.2 7.0 6.4 6.0

Source: templates/cloud/gcp

GCP Cloud SQL MySQL by HTTP

Overview

This template is designed to monitor Google Cloud Platform Cloud SQL MySQL instances by Zabbix.

Requirements

Zabbix version: 7.4 and higher.

Tested versions

This template has been tested on:

GCP Cloud SQL MySQL versions: 8.0, 5.7

Configuration

Setup

This template will be automatically connected to discovered entities with all their required parameters pre-defined.

Macros used

Name	Description	Default
{$GCP.DATA.TIMEOUT}	A response timeout for an API.	`15s`
{$GCP.TIME.WINDOW}	Time interval for the data requests. Supported usage type: 1. The default update interval for most of the items. 2. The minimal time window for the data requested in the Monitoring Query Language REST API request.	`5m`
{$GCP.PROXY}	Sets HTTP proxy value. If this macro is empty then no proxy is used.
{$HTTP.TLS.VERIFY}	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 "GCP Cloud SQL MySQL", e.g. {$HTTP.TLS.VERIFY:"GCP Cloud SQL MySQL"}.	`full`
{$CLOUD_SQL.MYSQL.DISK.UTIL.WARN}	GCP Cloud SQL MySQL instance warning disk usage threshold.	`80`
{$CLOUD_SQL.MYSQL.DISK.UTIL.CRIT}	GCP Cloud SQL MySQL instance critical disk usage threshold.	`90`
{$CLOUD_SQL.MYSQL.CPU.UTIL.MAX}	GCP Cloud SQL MySQL instance CPU usage threshold.	`95`
{$CLOUD_SQL.MYSQL.RAM.UTIL.MAX}	GCP Cloud SQL MySQL instance RAM usage threshold.	`90`

Items

Name	Description	Type	Key and additional info
Metrics get	MySQL metrics in raw format.	Script	gcp.cloudsql.mysql.metrics.get Preprocessing Check for not supported value: `any error` ⛔️Custom on fail: Discard value
Reserved CPU cores	Number of cores reserved for the database.	Dependent item	gcp.cloudsql.mysql.cpu.reserved_cores Preprocessing JSON Path: `$.base_reserved_cores`
CPU usage time	Cumulative CPU usage time in seconds.	Dependent item	gcp.cloudsql.mysql.cpu.usage_time Preprocessing JSON Path: `$.base_usage_time`
CPU utilization	Current CPU utilization represented as a percentage of the reserved CPU that is currently in use.	Dependent item	gcp.cloudsql.mysql.cpu.utilization Preprocessing JSON Path: `$.base_utilization` Custom multiplier: `100`
Disk size	Maximum data disk size in bytes.	Dependent item	gcp.cloudsql.mysql.disk.quota Preprocessing JSON Path: `$.mysql_quota`
Disk bytes used	Data utilization in bytes.	Dependent item	gcp.cloudsql.mysql.disk.bytes_used Preprocessing JSON Path: `$.mysql_bytes_used`
Disk read I/O	Delta count of data disk read I/O operations.	Dependent item	gcp.cloudsql.mysql.disk.read_ops_count Preprocessing JSON Path: `$.base_read_ops_count`
Disk write I/O	Delta count of data disk write I/O operations.	Dependent item	gcp.cloudsql.mysql.disk.write_ops_count Preprocessing JSON Path: `$.base_write_ops_count`
Disk utilization	The fraction of the disk quota that is currently in use. Shown as percentage.	Dependent item	gcp.cloudsql.mysql.disk.utilization Preprocessing JSON Path: `$.mysql_utilization` Custom multiplier: `100`
Memory size	Maximum RAM size in bytes.	Dependent item	gcp.cloudsql.mysql.memory.quota Preprocessing JSON Path: `$.base_quota`
Memory used by DB engine	Total RAM usage in bytes. This metric reports the RAM usage of the database process, including the buffer/cache.	Dependent item	gcp.cloudsql.mysql.memory.total_usage Preprocessing JSON Path: `$.base_total_usage`
Memory usage	The RAM usage in bytes. This metric reports the RAM usage of the server, excluding the buffer/cache.	Dependent item	gcp.cloudsql.mysql.memory.usage Preprocessing JSON Path: `$.base_usage`
Memory utilization	The fraction of the memory quota that is currently in use. Shown as percentage.	Dependent item	gcp.cloudsql.mysql.memory.utilization Preprocessing JSON Path: `$.base_ram_pused`
Network: Received bytes	Delta count of bytes received through the network.	Dependent item	gcp.cloudsql.mysql.network.received_bytes_count Preprocessing JSON Path: `$.base_received_bytes_count`
Network: Sent bytes	Delta count of bytes sent through the network.	Dependent item	gcp.cloudsql.mysql.network.sent_bytes_count Preprocessing JSON Path: `$.base_sent_bytes_count`
Connections	Number of connections to the databases on the Cloud SQL instance.	Dependent item	gcp.cloudsql.mysql.network.connections Preprocessing JSON Path: `$.base_connections`
Instance state	GCP Cloud SQL MySQL Current instance state.	HTTP agent	gcp.cloudsql.mysql.inst.state Preprocessing JSON Path: `$.timeSeriesData[0].pointData[0].values[0].stringValue` ⛔️Custom on fail: Set value to: `10` JavaScript: `The text is too long. Please see the template.` Discard unchanged with heartbeat: `10m`
DB engine state	GCP Cloud SQL MySQL DB Engine State.	HTTP agent	gcp.cloudsql.mysql.db.state Preprocessing Check for not supported value: `any error` ⛔️Custom on fail: Discard value JSON Path: `$.timeSeriesData[0].pointData[0].values[0].int64Value` ⛔️Custom on fail: Discard value Discard unchanged with heartbeat: `10m`
InnoDB dirty pages	Number of unflushed pages in the InnoDB buffer pool.	Dependent item	gcp.cloudsql.mysql.innodb_buffer_pool_pages_dirty Preprocessing JSON Path: `$.mysql_innodb_buffer_pool_pages_dirty`
InnoDB free pages	Number of unused pages in the InnoDB buffer pool.	Dependent item	gcp.cloudsql.mysql.innodb_buffer_pool_pages_free Preprocessing JSON Path: `$.mysql_innodb_buffer_pool_pages_free`
InnoDB total pages	Total number of pages in the InnoDB buffer pool.	Dependent item	gcp.cloudsql.mysql.innodb_buffer_pool_pages_total Preprocessing JSON Path: `$.mysql_innodb_buffer_pool_pages_total`
InnoDB fsync calls	Delta count of InnoDB fsync() calls.	Dependent item	gcp.cloudsql.mysql.innodb_data_fsyncs Preprocessing JSON Path: `$.mysql_innodb_data_fsyncs`
InnoDB log fsync calls	Delta count of InnoDB fsync() calls to the log file.	Dependent item	gcp.cloudsql.mysql.innodb_os_log_fsyncs Preprocessing JSON Path: `$.mysql_innodb_os_log_fsyncs`
InnoDB pages read	Delta count of InnoDB pages read.	Dependent item	gcp.cloudsql.mysql.innodb_pages_read Preprocessing JSON Path: `$.mysql_innodb_pages_read`
InnoDB pages written	Delta count of InnoDB pages written.	Dependent item	gcp.cloudsql.mysql.innodb_pages_written Preprocessing JSON Path: `$.mysql_innodb_pages_written`
Open tables	The number of tables that are currently open.	Dependent item	gcp.cloudsql.mysql.open_tables Preprocessing JSON Path: `$.mysql_open_tables`
Open table definitions	The number of table definitions that are currently cached.	Dependent item	gcp.cloudsql.mysql.open_table_definitions Preprocessing JSON Path: `$.mysql_open_table_definitions`
Queries	Delta of statements executed by the server.	Dependent item	gcp.cloudsql.queries Preprocessing JSON Path: `$.mysql_queries`
Questions	Delta of statements executed by the server sent by the client.	Dependent item	gcp.cloudsql.questions Preprocessing JSON Path: `$.mysql_questions`
Network: Bytes received by MySQL	Delta count of bytes received by MySQL process.	Dependent item	gcp.cloudsql.mysql_received_bytes_count Preprocessing JSON Path: `$.mysql_received_bytes_count`
Network: Bytes sent by MySQL	Delta count of bytes sent by MySQL process.	Dependent item	gcp.cloudsql.mysql_sent_bytes_count Preprocessing JSON Path: `$.mysql_sent_bytes_count`

Triggers

Name	Description	Expression	Severity	Dependencies and additional info
GCP MySQL: High CPU utilization	The CPU utilization is too high. The system might be slow to respond.	`min(/GCP Cloud SQL MySQL by HTTP/gcp.cloudsql.mysql.cpu.utilization,5m) >= {$CLOUD_SQL.MYSQL.CPU.UTIL.MAX}`	Average
GCP MySQL: Disk space is low	High utilization of the storage space.	`last(/GCP Cloud SQL MySQL by HTTP/gcp.cloudsql.mysql.disk.utilization) >= {$CLOUD_SQL.MYSQL.DISK.UTIL.WARN}`	Warning	Depends on: GCP MySQL: Disk space is critically low
GCP MySQL: Disk space is critically low	Critical utilization of the disk space.	`last(/GCP Cloud SQL MySQL by HTTP/gcp.cloudsql.mysql.disk.utilization) >= {$CLOUD_SQL.MYSQL.DISK.UTIL.CRIT}`	Average
GCP MySQL: High memory utilization	RAM utilization is too high. The system might be slow to respond.	`min(/GCP Cloud SQL MySQL by HTTP/gcp.cloudsql.mysql.memory.utilization,5m) >= {$CLOUD_SQL.MYSQL.RAM.UTIL.MAX}`	High
GCP MySQL: Instance is in suspended state	The instance is in suspended state. It is not available, for example, due to problems with billing.	`last(/GCP Cloud SQL MySQL by HTTP/gcp.cloudsql.mysql.inst.state) = 1`	Warning
GCP MySQL: Instance is stopped by the owner	The instance has been stopped by the owner. It is not currently running, but it's ready to be restarted.	`last(/GCP Cloud SQL MySQL by HTTP/gcp.cloudsql.mysql.inst.state) = 2`	Info
GCP MySQL: Instance is in maintenance	The instance is down for maintenance.	`last(/GCP Cloud SQL MySQL by HTTP/gcp.cloudsql.mysql.inst.state) = 4`	Info
GCP MySQL: Instance is in failed state	The instance creation failed, or an operation left the instance in an own bad state.	`last(/GCP Cloud SQL MySQL by HTTP/gcp.cloudsql.mysql.inst.state) = 5`	Average
GCP MySQL: Instance is in unknown state	The state of the instance is unknown.	`last(/GCP Cloud SQL MySQL by HTTP/gcp.cloudsql.mysql.inst.state) = 6`	Average
GCP MySQL: Failed to get the instance state	Failed to get the instance state. Check access permissions to GCP API or service account.	`last(/GCP Cloud SQL MySQL by HTTP/gcp.cloudsql.mysql.inst.state) = 10`	Average
GCP MySQL: Database engine is down	Database engine is down. If an instance experiences unplanned (non-maintenance) downtime, the instance state will still be RUNNING, but the database engine state metric will report 0.	`last(/GCP Cloud SQL MySQL by HTTP/gcp.cloudsql.mysql.db.state)=0`	Average	Depends on: GCP MySQL: Instance is stopped by the owner GCP MySQL: Instance is in suspended state GCP MySQL: Instance is in maintenance GCP MySQL: Instance is in failed state GCP MySQL: Instance is in unknown state GCP MySQL: Failed to get the instance state

Zabbix version 7.4 7.2 7.0 6.4 6.0

Source: templates/cloud/gcp

GCP Cloud SQL MySQL by HTTP

Overview

This template is designed to monitor Google Cloud Platform Cloud SQL MySQL instances by Zabbix.

Requirements

Zabbix version: 7.2 and higher.

Tested versions

This template has been tested on:

GCP Cloud SQL MySQL versions: 8.0, 5.7

Configuration

Setup

This template will be automatically connected to discovered entities with all their required parameters pre-defined.

Macros used

Name	Description	Default
{$GCP.DATA.TIMEOUT}	A response timeout for an API.	`15s`
{$GCP.TIME.WINDOW}	Time interval for the data requests. Supported usage type: 1. The default update interval for most of the items. 2. The minimal time window for the data requested in the Monitoring Query Language REST API request.	`5m`
{$GCP.PROXY}	Sets HTTP proxy value. If this macro is empty then no proxy is used.
{$CLOUD_SQL.MYSQL.DISK.UTIL.WARN}	GCP Cloud SQL MySQL instance warning disk usage threshold.	`80`
{$CLOUD_SQL.MYSQL.DISK.UTIL.CRIT}	GCP Cloud SQL MySQL instance critical disk usage threshold.	`90`
{$CLOUD_SQL.MYSQL.CPU.UTIL.MAX}	GCP Cloud SQL MySQL instance CPU usage threshold.	`95`
{$CLOUD_SQL.MYSQL.RAM.UTIL.MAX}	GCP Cloud SQL MySQL instance RAM usage threshold.	`90`

Items

Name	Description	Type	Key and additional info
Metrics get	MySQL metrics in raw format.	Script	gcp.cloudsql.mysql.metrics.get Preprocessing Check for not supported value: `any error` ⛔️Custom on fail: Discard value
Reserved CPU cores	Number of cores reserved for the database.	Dependent item	gcp.cloudsql.mysql.cpu.reserved_cores Preprocessing JSON Path: `$.base_reserved_cores`
CPU usage time	Cumulative CPU usage time in seconds.	Dependent item	gcp.cloudsql.mysql.cpu.usage_time Preprocessing JSON Path: `$.base_usage_time`
CPU utilization	Current CPU utilization represented as a percentage of the reserved CPU that is currently in use.	Dependent item	gcp.cloudsql.mysql.cpu.utilization Preprocessing JSON Path: `$.base_utilization` Custom multiplier: `100`
Disk size	Maximum data disk size in bytes.	Dependent item	gcp.cloudsql.mysql.disk.quota Preprocessing JSON Path: `$.mysql_quota`
Disk bytes used	Data utilization in bytes.	Dependent item	gcp.cloudsql.mysql.disk.bytes_used Preprocessing JSON Path: `$.mysql_bytes_used`
Disk read I/O	Delta count of data disk read I/O operations.	Dependent item	gcp.cloudsql.mysql.disk.read_ops_count Preprocessing JSON Path: `$.base_read_ops_count`
Disk write I/O	Delta count of data disk write I/O operations.	Dependent item	gcp.cloudsql.mysql.disk.write_ops_count Preprocessing JSON Path: `$.base_write_ops_count`
Disk utilization	The fraction of the disk quota that is currently in use. Shown as percentage.	Dependent item	gcp.cloudsql.mysql.disk.utilization Preprocessing JSON Path: `$.mysql_utilization` Custom multiplier: `100`
Memory size	Maximum RAM size in bytes.	Dependent item	gcp.cloudsql.mysql.memory.quota Preprocessing JSON Path: `$.base_quota`
Memory used by DB engine	Total RAM usage in bytes. This metric reports the RAM usage of the database process, including the buffer/cache.	Dependent item	gcp.cloudsql.mysql.memory.total_usage Preprocessing JSON Path: `$.base_total_usage`
Memory usage	The RAM usage in bytes. This metric reports the RAM usage of the server, excluding the buffer/cache.	Dependent item	gcp.cloudsql.mysql.memory.usage Preprocessing JSON Path: `$.base_usage`
Memory utilization	The fraction of the memory quota that is currently in use. Shown as percentage.	Dependent item	gcp.cloudsql.mysql.memory.utilization Preprocessing JSON Path: `$.base_ram_pused`
Network: Received bytes	Delta count of bytes received through the network.	Dependent item	gcp.cloudsql.mysql.network.received_bytes_count Preprocessing JSON Path: `$.base_received_bytes_count`
Network: Sent bytes	Delta count of bytes sent through the network.	Dependent item	gcp.cloudsql.mysql.network.sent_bytes_count Preprocessing JSON Path: `$.base_sent_bytes_count`
Connections	Number of connections to the databases on the Cloud SQL instance.	Dependent item	gcp.cloudsql.mysql.network.connections Preprocessing JSON Path: `$.base_connections`
Instance state	GCP Cloud SQL MySQL Current instance state.	HTTP agent	gcp.cloudsql.mysql.inst.state Preprocessing JSON Path: `$.timeSeriesData[0].pointData[0].values[0].stringValue` ⛔️Custom on fail: Set value to: `10` JavaScript: `The text is too long. Please see the template.` Discard unchanged with heartbeat: `10m`
DB engine state	GCP Cloud SQL MySQL DB Engine State.	HTTP agent	gcp.cloudsql.mysql.db.state Preprocessing Check for not supported value: `any error` ⛔️Custom on fail: Discard value JSON Path: `$.timeSeriesData[0].pointData[0].values[0].int64Value` ⛔️Custom on fail: Discard value Discard unchanged with heartbeat: `10m`
InnoDB dirty pages	Number of unflushed pages in the InnoDB buffer pool.	Dependent item	gcp.cloudsql.mysql.innodb_buffer_pool_pages_dirty Preprocessing JSON Path: `$.mysql_innodb_buffer_pool_pages_dirty`
InnoDB free pages	Number of unused pages in the InnoDB buffer pool.	Dependent item	gcp.cloudsql.mysql.innodb_buffer_pool_pages_free Preprocessing JSON Path: `$.mysql_innodb_buffer_pool_pages_free`
InnoDB total pages	Total number of pages in the InnoDB buffer pool.	Dependent item	gcp.cloudsql.mysql.innodb_buffer_pool_pages_total Preprocessing JSON Path: `$.mysql_innodb_buffer_pool_pages_total`
InnoDB fsync calls	Delta count of InnoDB fsync() calls.	Dependent item	gcp.cloudsql.mysql.innodb_data_fsyncs Preprocessing JSON Path: `$.mysql_innodb_data_fsyncs`
InnoDB log fsync calls	Delta count of InnoDB fsync() calls to the log file.	Dependent item	gcp.cloudsql.mysql.innodb_os_log_fsyncs Preprocessing JSON Path: `$.mysql_innodb_os_log_fsyncs`
InnoDB pages read	Delta count of InnoDB pages read.	Dependent item	gcp.cloudsql.mysql.innodb_pages_read Preprocessing JSON Path: `$.mysql_innodb_pages_read`
InnoDB pages written	Delta count of InnoDB pages written.	Dependent item	gcp.cloudsql.mysql.innodb_pages_written Preprocessing JSON Path: `$.mysql_innodb_pages_written`
Open tables	The number of tables that are currently open.	Dependent item	gcp.cloudsql.mysql.open_tables Preprocessing JSON Path: `$.mysql_open_tables`
Open table definitions	The number of table definitions that are currently cached.	Dependent item	gcp.cloudsql.mysql.open_table_definitions Preprocessing JSON Path: `$.mysql_open_table_definitions`
Queries	Delta of statements executed by the server.	Dependent item	gcp.cloudsql.queries Preprocessing JSON Path: `$.mysql_queries`
Questions	Delta of statements executed by the server sent by the client.	Dependent item	gcp.cloudsql.questions Preprocessing JSON Path: `$.mysql_questions`
Network: Bytes received by MySQL	Delta count of bytes received by MySQL process.	Dependent item	gcp.cloudsql.mysql_received_bytes_count Preprocessing JSON Path: `$.mysql_received_bytes_count`
Network: Bytes sent by MySQL	Delta count of bytes sent by MySQL process.	Dependent item	gcp.cloudsql.mysql_sent_bytes_count Preprocessing JSON Path: `$.mysql_sent_bytes_count`

Triggers

Name	Description	Expression	Severity	Dependencies and additional info
GCP MySQL: High CPU utilization	The CPU utilization is too high. The system might be slow to respond.	`min(/GCP Cloud SQL MySQL by HTTP/gcp.cloudsql.mysql.cpu.utilization,5m) >= {$CLOUD_SQL.MYSQL.CPU.UTIL.MAX}`	Average
GCP MySQL: Disk space is low	High utilization of the storage space.	`last(/GCP Cloud SQL MySQL by HTTP/gcp.cloudsql.mysql.disk.utilization) >= {$CLOUD_SQL.MYSQL.DISK.UTIL.WARN}`	Warning	Depends on: GCP MySQL: Disk space is critically low
GCP MySQL: Disk space is critically low	Critical utilization of the disk space.	`last(/GCP Cloud SQL MySQL by HTTP/gcp.cloudsql.mysql.disk.utilization) >= {$CLOUD_SQL.MYSQL.DISK.UTIL.CRIT}`	Average
GCP MySQL: High memory utilization	RAM utilization is too high. The system might be slow to respond.	`min(/GCP Cloud SQL MySQL by HTTP/gcp.cloudsql.mysql.memory.utilization,5m) >= {$CLOUD_SQL.MYSQL.RAM.UTIL.MAX}`	High
GCP MySQL: Instance is in suspended state	The instance is in suspended state. It is not available, for example, due to problems with billing.	`last(/GCP Cloud SQL MySQL by HTTP/gcp.cloudsql.mysql.inst.state) = 1`	Warning
GCP MySQL: Instance is stopped by the owner	The instance has been stopped by the owner. It is not currently running, but it's ready to be restarted.	`last(/GCP Cloud SQL MySQL by HTTP/gcp.cloudsql.mysql.inst.state) = 2`	Info
GCP MySQL: Instance is in maintenance	The instance is down for maintenance.	`last(/GCP Cloud SQL MySQL by HTTP/gcp.cloudsql.mysql.inst.state) = 4`	Info
GCP MySQL: Instance is in failed state	The instance creation failed, or an operation left the instance in an own bad state.	`last(/GCP Cloud SQL MySQL by HTTP/gcp.cloudsql.mysql.inst.state) = 5`	Average
GCP MySQL: Instance is in unknown state	The state of the instance is unknown.	`last(/GCP Cloud SQL MySQL by HTTP/gcp.cloudsql.mysql.inst.state) = 6`	Average
GCP MySQL: Failed to get the instance state	Failed to get the instance state. Check access permissions to GCP API or service account.	`last(/GCP Cloud SQL MySQL by HTTP/gcp.cloudsql.mysql.inst.state) = 10`	Average
GCP MySQL: Database engine is down	Database engine is down. If an instance experiences unplanned (non-maintenance) downtime, the instance state will still be RUNNING, but the database engine state metric will report 0.	`last(/GCP Cloud SQL MySQL by HTTP/gcp.cloudsql.mysql.db.state)=0`	Average	Depends on: GCP MySQL: Instance is stopped by the owner GCP MySQL: Instance is in suspended state GCP MySQL: Instance is in maintenance GCP MySQL: Instance is in failed state GCP MySQL: Instance is in unknown state GCP MySQL: Failed to get the instance state

Zabbix version 7.4 7.2 7.0 6.4 6.0

Source: templates/cloud/gcp

GCP Cloud SQL MySQL by HTTP

Overview

This template is designed to monitor Google Cloud Platform Cloud SQL MySQL instances by Zabbix.

Requirements

Zabbix version: 7.0 and higher.

Tested versions

This template has been tested on:

GCP Cloud SQL MySQL versions: 8.0, 5.7

Configuration

Setup

This template will be automatically connected to discovered entities with all their required parameters pre-defined.

Macros used

Name	Description	Default
{$GCP.DATA.TIMEOUT}	A response timeout for an API.	`15s`
{$GCP.TIME.WINDOW}	Time interval for the data requests. Supported usage type: 1. The default update interval for most of the items. 2. The minimal time window for the data requested in the Monitoring Query Language REST API request.	`5m`
{$GCP.PROXY}	Sets HTTP proxy value. If this macro is empty then no proxy is used.
{$HTTP.TLS.VERIFY}	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 "GCP Cloud SQL MySQL", e.g. {$HTTP.TLS.VERIFY:"GCP Cloud SQL MySQL"}.	`full`
{$CLOUD_SQL.MYSQL.DISK.UTIL.WARN}	GCP Cloud SQL MySQL instance warning disk usage threshold.	`80`
{$CLOUD_SQL.MYSQL.DISK.UTIL.CRIT}	GCP Cloud SQL MySQL instance critical disk usage threshold.	`90`
{$CLOUD_SQL.MYSQL.CPU.UTIL.MAX}	GCP Cloud SQL MySQL instance CPU usage threshold.	`95`
{$CLOUD_SQL.MYSQL.RAM.UTIL.MAX}	GCP Cloud SQL MySQL instance RAM usage threshold.	`90`

Items

Name	Description	Type	Key and additional info
Metrics get	MySQL metrics in raw format.	Script	gcp.cloudsql.mysql.metrics.get Preprocessing Check for not supported value: `any error` ⛔️Custom on fail: Discard value
Reserved CPU cores	Number of cores reserved for the database.	Dependent item	gcp.cloudsql.mysql.cpu.reserved_cores Preprocessing JSON Path: `$.base_reserved_cores`
CPU usage time	Cumulative CPU usage time in seconds.	Dependent item	gcp.cloudsql.mysql.cpu.usage_time Preprocessing JSON Path: `$.base_usage_time`
CPU utilization	Current CPU utilization represented as a percentage of the reserved CPU that is currently in use.	Dependent item	gcp.cloudsql.mysql.cpu.utilization Preprocessing JSON Path: `$.base_utilization` Custom multiplier: `100`
Disk size	Maximum data disk size in bytes.	Dependent item	gcp.cloudsql.mysql.disk.quota Preprocessing JSON Path: `$.mysql_quota`
Disk bytes used	Data utilization in bytes.	Dependent item	gcp.cloudsql.mysql.disk.bytes_used Preprocessing JSON Path: `$.mysql_bytes_used`
Disk read I/O	Delta count of data disk read I/O operations.	Dependent item	gcp.cloudsql.mysql.disk.read_ops_count Preprocessing JSON Path: `$.base_read_ops_count`
Disk write I/O	Delta count of data disk write I/O operations.	Dependent item	gcp.cloudsql.mysql.disk.write_ops_count Preprocessing JSON Path: `$.base_write_ops_count`
Disk utilization	The fraction of the disk quota that is currently in use. Shown as percentage.	Dependent item	gcp.cloudsql.mysql.disk.utilization Preprocessing JSON Path: `$.mysql_utilization` Custom multiplier: `100`
Memory size	Maximum RAM size in bytes.	Dependent item	gcp.cloudsql.mysql.memory.quota Preprocessing JSON Path: `$.base_quota`
Memory used by DB engine	Total RAM usage in bytes. This metric reports the RAM usage of the database process, including the buffer/cache.	Dependent item	gcp.cloudsql.mysql.memory.total_usage Preprocessing JSON Path: `$.base_total_usage`
Memory usage	The RAM usage in bytes. This metric reports the RAM usage of the server, excluding the buffer/cache.	Dependent item	gcp.cloudsql.mysql.memory.usage Preprocessing JSON Path: `$.base_usage`
Memory utilization	The fraction of the memory quota that is currently in use. Shown as percentage.	Dependent item	gcp.cloudsql.mysql.memory.utilization Preprocessing JSON Path: `$.base_ram_pused`
Network: Received bytes	Delta count of bytes received through the network.	Dependent item	gcp.cloudsql.mysql.network.received_bytes_count Preprocessing JSON Path: `$.base_received_bytes_count`
Network: Sent bytes	Delta count of bytes sent through the network.	Dependent item	gcp.cloudsql.mysql.network.sent_bytes_count Preprocessing JSON Path: `$.base_sent_bytes_count`
Connections	Number of connections to the databases on the Cloud SQL instance.	Dependent item	gcp.cloudsql.mysql.network.connections Preprocessing JSON Path: `$.base_connections`
Instance state	GCP Cloud SQL MySQL Current instance state.	HTTP agent	gcp.cloudsql.mysql.inst.state Preprocessing JSON Path: `$.timeSeriesData[0].pointData[0].values[0].stringValue` ⛔️Custom on fail: Set value to: `10` JavaScript: `The text is too long. Please see the template.` Discard unchanged with heartbeat: `10m`
DB engine state	GCP Cloud SQL MySQL DB Engine State.	HTTP agent	gcp.cloudsql.mysql.db.state Preprocessing Check for not supported value: `any error` ⛔️Custom on fail: Discard value JSON Path: `$.timeSeriesData[0].pointData[0].values[0].int64Value` ⛔️Custom on fail: Discard value Discard unchanged with heartbeat: `10m`
InnoDB dirty pages	Number of unflushed pages in the InnoDB buffer pool.	Dependent item	gcp.cloudsql.mysql.innodb_buffer_pool_pages_dirty Preprocessing JSON Path: `$.mysql_innodb_buffer_pool_pages_dirty`
InnoDB free pages	Number of unused pages in the InnoDB buffer pool.	Dependent item	gcp.cloudsql.mysql.innodb_buffer_pool_pages_free Preprocessing JSON Path: `$.mysql_innodb_buffer_pool_pages_free`
InnoDB total pages	Total number of pages in the InnoDB buffer pool.	Dependent item	gcp.cloudsql.mysql.innodb_buffer_pool_pages_total Preprocessing JSON Path: `$.mysql_innodb_buffer_pool_pages_total`
InnoDB fsync calls	Delta count of InnoDB fsync() calls.	Dependent item	gcp.cloudsql.mysql.innodb_data_fsyncs Preprocessing JSON Path: `$.mysql_innodb_data_fsyncs`
InnoDB log fsync calls	Delta count of InnoDB fsync() calls to the log file.	Dependent item	gcp.cloudsql.mysql.innodb_os_log_fsyncs Preprocessing JSON Path: `$.mysql_innodb_os_log_fsyncs`
InnoDB pages read	Delta count of InnoDB pages read.	Dependent item	gcp.cloudsql.mysql.innodb_pages_read Preprocessing JSON Path: `$.mysql_innodb_pages_read`
InnoDB pages written	Delta count of InnoDB pages written.	Dependent item	gcp.cloudsql.mysql.innodb_pages_written Preprocessing JSON Path: `$.mysql_innodb_pages_written`
Open tables	The number of tables that are currently open.	Dependent item	gcp.cloudsql.mysql.open_tables Preprocessing JSON Path: `$.mysql_open_tables`
Open table definitions	The number of table definitions that are currently cached.	Dependent item	gcp.cloudsql.mysql.open_table_definitions Preprocessing JSON Path: `$.mysql_open_table_definitions`
Queries	Delta of statements executed by the server.	Dependent item	gcp.cloudsql.queries Preprocessing JSON Path: `$.mysql_queries`
Questions	Delta of statements executed by the server sent by the client.	Dependent item	gcp.cloudsql.questions Preprocessing JSON Path: `$.mysql_questions`
Network: Bytes received by MySQL	Delta count of bytes received by MySQL process.	Dependent item	gcp.cloudsql.mysql_received_bytes_count Preprocessing JSON Path: `$.mysql_received_bytes_count`
Network: Bytes sent by MySQL	Delta count of bytes sent by MySQL process.	Dependent item	gcp.cloudsql.mysql_sent_bytes_count Preprocessing JSON Path: `$.mysql_sent_bytes_count`

Triggers

Name	Description	Expression	Severity	Dependencies and additional info
GCP MySQL: High CPU utilization	The CPU utilization is too high. The system might be slow to respond.	`min(/GCP Cloud SQL MySQL by HTTP/gcp.cloudsql.mysql.cpu.utilization,5m) >= {$CLOUD_SQL.MYSQL.CPU.UTIL.MAX}`	Average
GCP MySQL: Disk space is low	High utilization of the storage space.	`last(/GCP Cloud SQL MySQL by HTTP/gcp.cloudsql.mysql.disk.utilization) >= {$CLOUD_SQL.MYSQL.DISK.UTIL.WARN}`	Warning	Depends on: GCP MySQL: Disk space is critically low
GCP MySQL: Disk space is critically low	Critical utilization of the disk space.	`last(/GCP Cloud SQL MySQL by HTTP/gcp.cloudsql.mysql.disk.utilization) >= {$CLOUD_SQL.MYSQL.DISK.UTIL.CRIT}`	Average
GCP MySQL: High memory utilization	RAM utilization is too high. The system might be slow to respond.	`min(/GCP Cloud SQL MySQL by HTTP/gcp.cloudsql.mysql.memory.utilization,5m) >= {$CLOUD_SQL.MYSQL.RAM.UTIL.MAX}`	High
GCP MySQL: Instance is in suspended state	The instance is in suspended state. It is not available, for example, due to problems with billing.	`last(/GCP Cloud SQL MySQL by HTTP/gcp.cloudsql.mysql.inst.state) = 1`	Warning
GCP MySQL: Instance is stopped by the owner	The instance has been stopped by the owner. It is not currently running, but it's ready to be restarted.	`last(/GCP Cloud SQL MySQL by HTTP/gcp.cloudsql.mysql.inst.state) = 2`	Info
GCP MySQL: Instance is in maintenance	The instance is down for maintenance.	`last(/GCP Cloud SQL MySQL by HTTP/gcp.cloudsql.mysql.inst.state) = 4`	Info
GCP MySQL: Instance is in failed state	The instance creation failed, or an operation left the instance in an own bad state.	`last(/GCP Cloud SQL MySQL by HTTP/gcp.cloudsql.mysql.inst.state) = 5`	Average
GCP MySQL: Instance is in unknown state	The state of the instance is unknown.	`last(/GCP Cloud SQL MySQL by HTTP/gcp.cloudsql.mysql.inst.state) = 6`	Average
GCP MySQL: Failed to get the instance state	Failed to get the instance state. Check access permissions to GCP API or service account.	`last(/GCP Cloud SQL MySQL by HTTP/gcp.cloudsql.mysql.inst.state) = 10`	Average
GCP MySQL: Database engine is down	Database engine is down. If an instance experiences unplanned (non-maintenance) downtime, the instance state will still be RUNNING, but the database engine state metric will report 0.	`last(/GCP Cloud SQL MySQL by HTTP/gcp.cloudsql.mysql.db.state)=0`	Average	Depends on: GCP MySQL: Instance is stopped by the owner GCP MySQL: Instance is in suspended state GCP MySQL: Instance is in maintenance GCP MySQL: Instance is in failed state GCP MySQL: Instance is in unknown state GCP MySQL: Failed to get the instance state

Zabbix version 7.4 7.2 7.0 6.4 6.0

Source: templates/cloud/gcp

GCP Cloud SQL MySQL by HTTP

Overview

This template is designed to monitor Google Cloud Platform Cloud SQL MySQL instances by Zabbix.

Requirements

Zabbix version: 6.4 and higher.

Tested versions

This template has been tested on:

GCP Cloud SQL MySQL versions: 8.0, 5.7

Configuration

Setup

This template will be automatically connected to discovered entities with all their required parameters pre-defined.

Macros used

Name	Description	Default
{$GCP.DATA.TIMEOUT}	A response timeout for an API.	`15s`
{$GCP.TIME.WINDOW}	Time interval for the data requests. Supported usage type: 1. The default update interval for most of the items. 2. The minimal time window for the data requested in the Monitoring Query Language REST API request.	`5m`
{$GCP.PROXY}	Sets HTTP proxy value. If this macro is empty then no proxy is used.
{$CLOUD_SQL.MYSQL.DISK.UTIL.WARN}	GCP Cloud SQL MySQL instance warning disk usage threshold.	`80`
{$CLOUD_SQL.MYSQL.DISK.UTIL.CRIT}	GCP Cloud SQL MySQL instance critical disk usage threshold.	`90`
{$CLOUD_SQL.MYSQL.CPU.UTIL.MAX}	GCP Cloud SQL MySQL instance CPU usage threshold.	`95`
{$CLOUD_SQL.MYSQL.RAM.UTIL.MAX}	GCP Cloud SQL MySQL instance RAM usage threshold.	`90`

Items

Name	Description	Type	Key and additional info
GCP Cloud SQL MySQL: Metrics get	MySQL metrics in raw format.	Script	gcp.cloudsql.mysql.metrics.get Preprocessing Check for not supported value ⛔️Custom on fail: Discard value
GCP Cloud SQL MySQL: Reserved CPU cores	Number of cores reserved for the database.	Dependent item	gcp.cloudsql.mysql.cpu.reserved_cores Preprocessing JSON Path: `$.base_reserved_cores`
GCP Cloud SQL MySQL: CPU usage time	Cumulative CPU usage time in seconds.	Dependent item	gcp.cloudsql.mysql.cpu.usage_time Preprocessing JSON Path: `$.base_usage_time`
GCP Cloud SQL MySQL: CPU utilization	Current CPU utilization represented as a percentage of the reserved CPU that is currently in use.	Dependent item	gcp.cloudsql.mysql.cpu.utilization Preprocessing JSON Path: `$.base_utilization` Custom multiplier: `100`
GCP Cloud SQL MySQL: Disk size	Maximum data disk size in bytes.	Dependent item	gcp.cloudsql.mysql.disk.quota Preprocessing JSON Path: `$.mysql_quota`
GCP Cloud SQL MySQL: Disk bytes used	Data utilization in bytes.	Dependent item	gcp.cloudsql.mysql.disk.bytes_used Preprocessing JSON Path: `$.mysql_bytes_used`
GCP Cloud SQL MySQL: Disk read I/O	Delta count of data disk read I/O operations.	Dependent item	gcp.cloudsql.mysql.disk.read_ops_count Preprocessing JSON Path: `$.base_read_ops_count`
GCP Cloud SQL MySQL: Disk write I/O	Delta count of data disk write I/O operations.	Dependent item	gcp.cloudsql.mysql.disk.write_ops_count Preprocessing JSON Path: `$.base_write_ops_count`
GCP Cloud SQL MySQL: Disk utilization	The fraction of the disk quota that is currently in use. Shown as percentage.	Dependent item	gcp.cloudsql.mysql.disk.utilization Preprocessing JSON Path: `$.mysql_utilization` Custom multiplier: `100`
GCP Cloud SQL MySQL: Memory size	Maximum RAM size in bytes.	Dependent item	gcp.cloudsql.mysql.memory.quota Preprocessing JSON Path: `$.base_quota`
GCP Cloud SQL MySQL: Memory used by DB engine	Total RAM usage in bytes. This metric reports the RAM usage of the database process, including the buffer/cache.	Dependent item	gcp.cloudsql.mysql.memory.total_usage Preprocessing JSON Path: `$.base_total_usage`
GCP Cloud SQL MySQL: Memory usage	The RAM usage in bytes. This metric reports the RAM usage of the server, excluding the buffer/cache.	Dependent item	gcp.cloudsql.mysql.memory.usage Preprocessing JSON Path: `$.base_usage`
GCP Cloud SQL MySQL: Memory utilization	The fraction of the memory quota that is currently in use. Shown as percentage.	Dependent item	gcp.cloudsql.mysql.memory.utilization Preprocessing JSON Path: `$.base_ram_pused`
GCP Cloud SQL MySQL: Network: Received bytes	Delta count of bytes received through the network.	Dependent item	gcp.cloudsql.mysql.network.received_bytes_count Preprocessing JSON Path: `$.base_received_bytes_count`
GCP Cloud SQL MySQL: Network: Sent bytes	Delta count of bytes sent through the network.	Dependent item	gcp.cloudsql.mysql.network.sent_bytes_count Preprocessing JSON Path: `$.base_sent_bytes_count`
GCP Cloud SQL MySQL: Connections	Number of connections to the databases on the Cloud SQL instance.	Dependent item	gcp.cloudsql.mysql.network.connections Preprocessing JSON Path: `$.base_connections`
GCP Cloud SQL MySQL: Instance state	GCP Cloud SQL MySQL Current instance state.	HTTP agent	gcp.cloudsql.mysql.inst.state Preprocessing JSON Path: `$.timeSeriesData[0].pointData[0].values[0].stringValue` ⛔️Custom on fail: Set value to: `10` JavaScript: `The text is too long. Please see the template.` Discard unchanged with heartbeat: `10m`
GCP Cloud SQL MySQL: DB engine state	GCP Cloud SQL MySQL DB Engine State.	HTTP agent	gcp.cloudsql.mysql.db.state Preprocessing Check for not supported value ⛔️Custom on fail: Discard value JSON Path: `$.timeSeriesData[0].pointData[0].values[0].int64Value` ⛔️Custom on fail: Discard value Discard unchanged with heartbeat: `10m`
GCP Cloud SQL MySQL: InnoDB dirty pages	Number of unflushed pages in the InnoDB buffer pool.	Dependent item	gcp.cloudsql.mysql.innodb_buffer_pool_pages_dirty Preprocessing JSON Path: `$.mysql_innodb_buffer_pool_pages_dirty`
GCP Cloud SQL MySQL: InnoDB free pages	Number of unused pages in the InnoDB buffer pool.	Dependent item	gcp.cloudsql.mysql.innodb_buffer_pool_pages_free Preprocessing JSON Path: `$.mysql_innodb_buffer_pool_pages_free`
GCP Cloud SQL MySQL: InnoDB total pages	Total number of pages in the InnoDB buffer pool.	Dependent item	gcp.cloudsql.mysql.innodb_buffer_pool_pages_total Preprocessing JSON Path: `$.mysql_innodb_buffer_pool_pages_total`
GCP Cloud SQL MySQL: InnoDB fsync calls	Delta count of InnoDB fsync() calls.	Dependent item	gcp.cloudsql.mysql.innodb_data_fsyncs Preprocessing JSON Path: `$.mysql_innodb_data_fsyncs`
GCP Cloud SQL MySQL: InnoDB log fsync calls	Delta count of InnoDB fsync() calls to the log file.	Dependent item	gcp.cloudsql.mysql.innodb_os_log_fsyncs Preprocessing JSON Path: `$.mysql_innodb_os_log_fsyncs`
GCP Cloud SQL MySQL: InnoDB pages read	Delta count of InnoDB pages read.	Dependent item	gcp.cloudsql.mysql.innodb_pages_read Preprocessing JSON Path: `$.mysql_innodb_pages_read`
GCP Cloud SQL MySQL: InnoDB pages written	Delta count of InnoDB pages written.	Dependent item	gcp.cloudsql.mysql.innodb_pages_written Preprocessing JSON Path: `$.mysql_innodb_pages_written`
GCP Cloud SQL MySQL: Open tables	The number of tables that are currently open.	Dependent item	gcp.cloudsql.mysql.open_tables Preprocessing JSON Path: `$.mysql_open_tables`
GCP Cloud SQL MySQL: Open table definitions	The number of table definitions that are currently cached.	Dependent item	gcp.cloudsql.mysql.open_table_definitions Preprocessing JSON Path: `$.mysql_open_table_definitions`
GCP Cloud SQL MySQL: Queries	Delta of statements executed by the server.	Dependent item	gcp.cloudsql.queries Preprocessing JSON Path: `$.mysql_queries`
GCP Cloud SQL MySQL: Questions	Delta of statements executed by the server sent by the client.	Dependent item	gcp.cloudsql.questions Preprocessing JSON Path: `$.mysql_questions`
GCP Cloud SQL MySQL: Network: Bytes received by MySQL	Delta count of bytes received by MySQL process.	Dependent item	gcp.cloudsql.mysql_received_bytes_count Preprocessing JSON Path: `$.mysql_received_bytes_count`
GCP Cloud SQL MySQL: Network: Bytes sent by MySQL	Delta count of bytes sent by MySQL process.	Dependent item	gcp.cloudsql.mysql_sent_bytes_count Preprocessing JSON Path: `$.mysql_sent_bytes_count`

Triggers

Name	Description	Expression	Severity	Dependencies and additional info
GCP Cloud SQL MySQL: High CPU utilization	The CPU utilization is too high. The system might be slow to respond.	`min(/GCP Cloud SQL MySQL by HTTP/gcp.cloudsql.mysql.cpu.utilization,5m) >= {$CLOUD_SQL.MYSQL.CPU.UTIL.MAX}`	Average
GCP Cloud SQL MySQL: Disk space is low	High utilization of the storage space.	`last(/GCP Cloud SQL MySQL by HTTP/gcp.cloudsql.mysql.disk.utilization) >= {$CLOUD_SQL.MYSQL.DISK.UTIL.WARN}`	Warning	Depends on: GCP Cloud SQL MySQL: Disk space is critically low
GCP Cloud SQL MySQL: Disk space is critically low	Critical utilization of the disk space.	`last(/GCP Cloud SQL MySQL by HTTP/gcp.cloudsql.mysql.disk.utilization) >= {$CLOUD_SQL.MYSQL.DISK.UTIL.CRIT}`	Average
GCP Cloud SQL MySQL: High memory utilization	RAM utilization is too high. The system might be slow to respond.	`min(/GCP Cloud SQL MySQL by HTTP/gcp.cloudsql.mysql.memory.utilization,5m) >= {$CLOUD_SQL.MYSQL.RAM.UTIL.MAX}`	High
GCP Cloud SQL MySQL: Instance is in suspended state	The instance is in suspended state. It is not available, for example, due to problems with billing.	`last(/GCP Cloud SQL MySQL by HTTP/gcp.cloudsql.mysql.inst.state) = 1`	Warning
GCP Cloud SQL MySQL: Instance is stopped by the owner	The instance has been stopped by the owner. It is not currently running, but it's ready to be restarted.	`last(/GCP Cloud SQL MySQL by HTTP/gcp.cloudsql.mysql.inst.state) = 2`	Info
GCP Cloud SQL MySQL: Instance is in maintenance	The instance is down for maintenance.	`last(/GCP Cloud SQL MySQL by HTTP/gcp.cloudsql.mysql.inst.state) = 4`	Info
GCP Cloud SQL MySQL: Instance is in failed state	The instance creation failed, or an operation left the instance in an own bad state.	`last(/GCP Cloud SQL MySQL by HTTP/gcp.cloudsql.mysql.inst.state) = 5`	Average
GCP Cloud SQL MySQL: Instance is in unknown state	The state of the instance is unknown.	`last(/GCP Cloud SQL MySQL by HTTP/gcp.cloudsql.mysql.inst.state) = 6`	Average
GCP Cloud SQL MySQL: Failed to get the instance state	Failed to get the instance state. Check access permissions to GCP API or service account.	`last(/GCP Cloud SQL MySQL by HTTP/gcp.cloudsql.mysql.inst.state) = 10`	Average
GCP Cloud SQL MySQL: Database engine is down	Database engine is down. If an instance experiences unplanned (non-maintenance) downtime, the instance state will still be RUNNING, but the database engine state metric will report 0.	`last(/GCP Cloud SQL MySQL by HTTP/gcp.cloudsql.mysql.db.state)=0`	Average	Depends on: GCP Cloud SQL MySQL: Instance is stopped by the owner GCP Cloud SQL MySQL: Instance is in suspended state GCP Cloud SQL MySQL: Instance is in maintenance GCP Cloud SQL MySQL: Instance is in failed state GCP Cloud SQL MySQL: Instance is in unknown state GCP Cloud SQL MySQL: Failed to get the instance state

Zabbix version 7.4 7.2 7.0 6.4 6.0

Source: templates/cloud/gcp

GCP Cloud SQL MySQL by HTTP

Overview

This template is designed to monitor Google Cloud Platform Cloud SQL MySQL instances by Zabbix.

Requirements

Zabbix version: 6.0 and higher.

Tested versions

This template has been tested on:

GCP Cloud SQL MySQL versions: 8.0, 5.7

Configuration

Setup

This template will be automatically connected to discovered entities with all their required parameters pre-defined.

Macros used

Name	Description	Default
{$GCP.DATA.TIMEOUT}	A response timeout for an API.	`15s`
{$GCP.TIME.WINDOW}	Time interval for the data requests. Supported usage type: 1. The default update interval for most of the items. 2. The minimal time window for the data requested in the Monitoring Query Language REST API request.	`5m`
{$GCP.PROXY}	Sets HTTP proxy value. If this macro is empty then no proxy is used.
{$CLOUD_SQL.MYSQL.DISK.UTIL.WARN}	GCP Cloud SQL MySQL instance warning disk usage threshold.	`80`
{$CLOUD_SQL.MYSQL.DISK.UTIL.CRIT}	GCP Cloud SQL MySQL instance critical disk usage threshold.	`90`
{$CLOUD_SQL.MYSQL.CPU.UTIL.MAX}	GCP Cloud SQL MySQL instance CPU usage threshold.	`95`
{$CLOUD_SQL.MYSQL.RAM.UTIL.MAX}	GCP Cloud SQL MySQL instance RAM usage threshold.	`90`

Items

Name	Description	Type	Key and additional info
GCP Cloud SQL MySQL: Metrics get	MySQL metrics in raw format.	Script	gcp.cloudsql.mysql.metrics.get Preprocessing Check for not supported value ⛔️Custom on fail: Discard value
GCP Cloud SQL MySQL: Reserved CPU cores	Number of cores reserved for the database.	Dependent item	gcp.cloudsql.mysql.cpu.reserved_cores Preprocessing JSON Path: `$.base_reserved_cores`
GCP Cloud SQL MySQL: CPU usage time	Cumulative CPU usage time in seconds.	Dependent item	gcp.cloudsql.mysql.cpu.usage_time Preprocessing JSON Path: `$.base_usage_time`
GCP Cloud SQL MySQL: CPU utilization	Current CPU utilization represented as a percentage of the reserved CPU that is currently in use.	Dependent item	gcp.cloudsql.mysql.cpu.utilization Preprocessing JSON Path: `$.base_utilization` Custom multiplier: `100`
GCP Cloud SQL MySQL: Disk size	Maximum data disk size in bytes.	Dependent item	gcp.cloudsql.mysql.disk.quota Preprocessing JSON Path: `$.mysql_quota`
GCP Cloud SQL MySQL: Disk bytes used	Data utilization in bytes.	Dependent item	gcp.cloudsql.mysql.disk.bytes_used Preprocessing JSON Path: `$.mysql_bytes_used`
GCP Cloud SQL MySQL: Disk read I/O	Delta count of data disk read I/O operations.	Dependent item	gcp.cloudsql.mysql.disk.read_ops_count Preprocessing JSON Path: `$.base_read_ops_count`
GCP Cloud SQL MySQL: Disk write I/O	Delta count of data disk write I/O operations.	Dependent item	gcp.cloudsql.mysql.disk.write_ops_count Preprocessing JSON Path: `$.base_write_ops_count`
GCP Cloud SQL MySQL: Disk utilization	The fraction of the disk quota that is currently in use. Shown as percentage.	Dependent item	gcp.cloudsql.mysql.disk.utilization Preprocessing JSON Path: `$.mysql_utilization` Custom multiplier: `100`
GCP Cloud SQL MySQL: Memory size	Maximum RAM size in bytes.	Dependent item	gcp.cloudsql.mysql.memory.quota Preprocessing JSON Path: `$.base_quota`
GCP Cloud SQL MySQL: Memory used by DB engine	Total RAM usage in bytes. This metric reports the RAM usage of the database process, including the buffer/cache.	Dependent item	gcp.cloudsql.mysql.memory.total_usage Preprocessing JSON Path: `$.base_total_usage`
GCP Cloud SQL MySQL: Memory usage	The RAM usage in bytes. This metric reports the RAM usage of the server, excluding the buffer/cache.	Dependent item	gcp.cloudsql.mysql.memory.usage Preprocessing JSON Path: `$.base_usage`
GCP Cloud SQL MySQL: Memory utilization	The fraction of the memory quota that is currently in use. Shown as percentage.	Dependent item	gcp.cloudsql.mysql.memory.utilization Preprocessing JSON Path: `$.base_ram_pused`
GCP Cloud SQL MySQL: Network: Received bytes	Delta count of bytes received through the network.	Dependent item	gcp.cloudsql.mysql.network.received_bytes_count Preprocessing JSON Path: `$.base_received_bytes_count`
GCP Cloud SQL MySQL: Network: Sent bytes	Delta count of bytes sent through the network.	Dependent item	gcp.cloudsql.mysql.network.sent_bytes_count Preprocessing JSON Path: `$.base_sent_bytes_count`
GCP Cloud SQL MySQL: Connections	Number of connections to the databases on the Cloud SQL instance.	Dependent item	gcp.cloudsql.mysql.network.connections Preprocessing JSON Path: `$.base_connections`
GCP Cloud SQL MySQL: Instance state	GCP Cloud SQL MySQL Current instance state.	HTTP agent	gcp.cloudsql.mysql.inst.state Preprocessing JSON Path: `$.timeSeriesData[0].pointData[0].values[0].stringValue` ⛔️Custom on fail: Set value to: `10` JavaScript: `The text is too long. Please see the template.` Discard unchanged with heartbeat: `10m`
GCP Cloud SQL MySQL: DB engine state	GCP Cloud SQL MySQL DB Engine State.	HTTP agent	gcp.cloudsql.mysql.db.state Preprocessing Check for not supported value ⛔️Custom on fail: Discard value JSON Path: `$.timeSeriesData[0].pointData[0].values[0].int64Value` ⛔️Custom on fail: Discard value Discard unchanged with heartbeat: `10m`
GCP Cloud SQL MySQL: InnoDB dirty pages	Number of unflushed pages in the InnoDB buffer pool.	Dependent item	gcp.cloudsql.mysql.innodb_buffer_pool_pages_dirty Preprocessing JSON Path: `$.mysql_innodb_buffer_pool_pages_dirty`
GCP Cloud SQL MySQL: InnoDB free pages	Number of unused pages in the InnoDB buffer pool.	Dependent item	gcp.cloudsql.mysql.innodb_buffer_pool_pages_free Preprocessing JSON Path: `$.mysql_innodb_buffer_pool_pages_free`
GCP Cloud SQL MySQL: InnoDB total pages	Total number of pages in the InnoDB buffer pool.	Dependent item	gcp.cloudsql.mysql.innodb_buffer_pool_pages_total Preprocessing JSON Path: `$.mysql_innodb_buffer_pool_pages_total`
GCP Cloud SQL MySQL: InnoDB fsync calls	Delta count of InnoDB fsync() calls.	Dependent item	gcp.cloudsql.mysql.innodb_data_fsyncs Preprocessing JSON Path: `$.mysql_innodb_data_fsyncs`
GCP Cloud SQL MySQL: InnoDB log fsync calls	Delta count of InnoDB fsync() calls to the log file.	Dependent item	gcp.cloudsql.mysql.innodb_os_log_fsyncs Preprocessing JSON Path: `$.mysql_innodb_os_log_fsyncs`
GCP Cloud SQL MySQL: InnoDB pages read	Delta count of InnoDB pages read.	Dependent item	gcp.cloudsql.mysql.innodb_pages_read Preprocessing JSON Path: `$.mysql_innodb_pages_read`
GCP Cloud SQL MySQL: InnoDB pages written	Delta count of InnoDB pages written.	Dependent item	gcp.cloudsql.mysql.innodb_pages_written Preprocessing JSON Path: `$.mysql_innodb_pages_written`
GCP Cloud SQL MySQL: Open tables	The number of tables that are currently open.	Dependent item	gcp.cloudsql.mysql.open_tables Preprocessing JSON Path: `$.mysql_open_tables`
GCP Cloud SQL MySQL: Open table definitions	The number of table definitions that are currently cached.	Dependent item	gcp.cloudsql.mysql.open_table_definitions Preprocessing JSON Path: `$.mysql_open_table_definitions`
GCP Cloud SQL MySQL: Queries	Delta of statements executed by the server.	Dependent item	gcp.cloudsql.queries Preprocessing JSON Path: `$.mysql_queries`
GCP Cloud SQL MySQL: Questions	Delta of statements executed by the server sent by the client.	Dependent item	gcp.cloudsql.questions Preprocessing JSON Path: `$.mysql_questions`
GCP Cloud SQL MySQL: Network: Bytes received by MySQL	Delta count of bytes received by MySQL process.	Dependent item	gcp.cloudsql.mysql_received_bytes_count Preprocessing JSON Path: `$.mysql_received_bytes_count`
GCP Cloud SQL MySQL: Network: Bytes sent by MySQL	Delta count of bytes sent by MySQL process.	Dependent item	gcp.cloudsql.mysql_sent_bytes_count Preprocessing JSON Path: `$.mysql_sent_bytes_count`

Triggers

Name	Description	Expression	Severity	Dependencies and additional info
GCP Cloud SQL MySQL: High CPU utilization	The CPU utilization is too high. The system might be slow to respond.	`min(/GCP Cloud SQL MySQL by HTTP/gcp.cloudsql.mysql.cpu.utilization,5m) >= {$CLOUD_SQL.MYSQL.CPU.UTIL.MAX}`	Average
GCP Cloud SQL MySQL: Disk space is low	High utilization of the storage space.	`last(/GCP Cloud SQL MySQL by HTTP/gcp.cloudsql.mysql.disk.utilization) >= {$CLOUD_SQL.MYSQL.DISK.UTIL.WARN}`	Warning	Depends on: GCP Cloud SQL MySQL: Disk space is critically low
GCP Cloud SQL MySQL: Disk space is critically low	Critical utilization of the disk space.	`last(/GCP Cloud SQL MySQL by HTTP/gcp.cloudsql.mysql.disk.utilization) >= {$CLOUD_SQL.MYSQL.DISK.UTIL.CRIT}`	Average
GCP Cloud SQL MySQL: High memory utilization	RAM utilization is too high. The system might be slow to respond.	`min(/GCP Cloud SQL MySQL by HTTP/gcp.cloudsql.mysql.memory.utilization,5m) >= {$CLOUD_SQL.MYSQL.RAM.UTIL.MAX}`	High
GCP Cloud SQL MySQL: Instance is in suspended state	The instance is in suspended state. It is not available, for example, due to problems with billing.	`last(/GCP Cloud SQL MySQL by HTTP/gcp.cloudsql.mysql.inst.state) = 1`	Warning
GCP Cloud SQL MySQL: Instance is stopped by the owner	The instance has been stopped by the owner. It is not currently running, but it's ready to be restarted.	`last(/GCP Cloud SQL MySQL by HTTP/gcp.cloudsql.mysql.inst.state) = 2`	Info
GCP Cloud SQL MySQL: Instance is in maintenance	The instance is down for maintenance.	`last(/GCP Cloud SQL MySQL by HTTP/gcp.cloudsql.mysql.inst.state) = 4`	Info
GCP Cloud SQL MySQL: Instance is in failed state	The instance creation failed, or an operation left the instance in an own bad state.	`last(/GCP Cloud SQL MySQL by HTTP/gcp.cloudsql.mysql.inst.state) = 5`	Average
GCP Cloud SQL MySQL: Instance is in unknown state	The state of the instance is unknown.	`last(/GCP Cloud SQL MySQL by HTTP/gcp.cloudsql.mysql.inst.state) = 6`	Average
GCP Cloud SQL MySQL: Failed to get the instance state	Failed to get the instance state. Check access permissions to GCP API or service account.	`last(/GCP Cloud SQL MySQL by HTTP/gcp.cloudsql.mysql.inst.state) = 10`	Average
GCP Cloud SQL MySQL: Database engine is down	Database engine is down. If an instance experiences unplanned (non-maintenance) downtime, the instance state will still be RUNNING, but the database engine state metric will report 0.	`last(/GCP Cloud SQL MySQL by HTTP/gcp.cloudsql.mysql.db.state)=0`	Average	Depends on: GCP Cloud SQL MySQL: Instance is stopped by the owner GCP Cloud SQL MySQL: Instance is in suspended state GCP Cloud SQL MySQL: Instance is in maintenance GCP Cloud SQL MySQL: Instance is in failed state GCP Cloud SQL MySQL: Instance is in unknown state GCP Cloud SQL MySQL: Failed to get the instance state

Zabbix version 7.4 7.2 7.0 6.4 6.0

Source: templates/cloud/gcp

GCP Cloud SQL MySQL Replica by HTTP

Overview

This template is designed to monitor Google Cloud Platform Cloud SQL metrics for the MySQL read-only replica instances by Zabbix.

Requirements

Zabbix version: 7.4 and higher.

Tested versions

This template has been tested on:

GCP Cloud SQL MySQL read replica versions: 8.0, 5.7

Configuration

Setup

This template will be automatically connected to discovered entities with all their required parameters pre-defined.

Macros used

Name	Description	Default
{$GCP.DATA.TIMEOUT}	A response timeout for an API.	`15s`
{$GCP.TIME.WINDOW}	Time interval for the data requests. Supported usage type: 1. The default update interval for most of the items. 2. The minimal time window for the data requested in the Monitoring Query Language REST API request.	`5m`
{$GCP.PROXY}	Sets HTTP proxy value. If this macro is empty then no proxy is used.
{$HTTP.TLS.VERIFY}	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 "GCP Cloud SQL MySQL Replica", e.g. {$HTTP.TLS.VERIFY:"GCP Cloud SQL MySQL Replica"}.	`full`

Items

Name	Description	Type	Key and additional info
Replica metrics get	MySQL replication metrics data in raw format.	Script	gcp.cloudsql.mysql.repl.metrics.get Preprocessing Check for not supported value: `any error` ⛔️Custom on fail: Discard value
Last I/O thread error number	The error number of the most recent error that caused the I/O thread to stop.	Dependent item	gcp.cloudsql.mysql.repl.last_io_errno Preprocessing JSON Path: `$.last_io_errno`
Last SQL thread error number	The error number of the most recent error that caused the SQL thread to stop.	Dependent item	gcp.cloudsql.mysql.repl.last_sql_errno Preprocessing JSON Path: `$.last_sql_errno`
Replication lag	Number of seconds the read replica is behind its primary (approximation).	Dependent item	gcp.cloudsql.mysql.repl.replica_lag Preprocessing JSON Path: `$.replica_lag`
Network lag	Indicates time taken from primary binary log to IO thread on replica.	Dependent item	gcp.cloudsql.mysql.repl.network_lag Preprocessing JSON Path: `$.network_lag`
Replication state	The current serving state of replication. This metric is only available for the MySQL/PostgreSQL instances.	Dependent item	gcp.cloudsql.mysql.repl.state Preprocessing JSON Path: `$.state` JavaScript: `The text is too long. Please see the template.`
Slave I/O thread running	Indicates whether the I/O thread for reading the primary's binary log is running. Possible values are Yes, No and Connecting.	Dependent item	gcp.cloudsql.mysql.repl.slave_io_running Preprocessing JSON Path: `$.slave_io_running` JavaScript: `The text is too long. Please see the template.`
Slave SQL thread running	Indicates whether the SQL thread for executing events in the relay log is running.	Dependent item	gcp.cloudsql.mysql.repl.slave_sql_running Preprocessing JSON Path: `$.slave_sql_running` Boolean to decimal

Zabbix version 7.4 7.2 7.0 6.4 6.0

Source: templates/cloud/gcp

GCP Cloud SQL MySQL Replica by HTTP

Overview

This template is designed to monitor Google Cloud Platform Cloud SQL metrics for the MySQL read-only replica instances by Zabbix.

Requirements

Zabbix version: 7.2 and higher.

Tested versions

This template has been tested on:

GCP Cloud SQL MySQL read replica versions: 8.0, 5.7

Configuration

Setup

This template will be automatically connected to discovered entities with all their required parameters pre-defined.

Macros used

Name Description Default

{$GCP.DATA.TIMEOUT}

A response timeout for an API.

15s

{$GCP.TIME.WINDOW}

Time interval for the data requests.

Supported usage type:

1. The default update interval for most of the items.

2. The minimal time window for the data requested in the Monitoring Query Language REST API request.

5m

{$GCP.PROXY}

Sets HTTP proxy value. If this macro is empty then no proxy is used.

Items

Name	Description	Type	Key and additional info
Replica metrics get	MySQL replication metrics data in raw format.	Script	gcp.cloudsql.mysql.repl.metrics.get Preprocessing Check for not supported value: `any error` ⛔️Custom on fail: Discard value
Last I/O thread error number	The error number of the most recent error that caused the I/O thread to stop.	Dependent item	gcp.cloudsql.mysql.repl.last_io_errno Preprocessing JSON Path: `$.last_io_errno`
Last SQL thread error number	The error number of the most recent error that caused the SQL thread to stop.	Dependent item	gcp.cloudsql.mysql.repl.last_sql_errno Preprocessing JSON Path: `$.last_sql_errno`
Replication lag	Number of seconds the read replica is behind its primary (approximation).	Dependent item	gcp.cloudsql.mysql.repl.replica_lag Preprocessing JSON Path: `$.replica_lag`
Network lag	Indicates time taken from primary binary log to IO thread on replica.	Dependent item	gcp.cloudsql.mysql.repl.network_lag Preprocessing JSON Path: `$.network_lag`
Replication state	The current serving state of replication. This metric is only available for the MySQL/PostgreSQL instances.	Dependent item	gcp.cloudsql.mysql.repl.state Preprocessing JSON Path: `$.state` JavaScript: `The text is too long. Please see the template.`
Slave I/O thread running	Indicates whether the I/O thread for reading the primary's binary log is running. Possible values are Yes, No and Connecting.	Dependent item	gcp.cloudsql.mysql.repl.slave_io_running Preprocessing JSON Path: `$.slave_io_running` JavaScript: `The text is too long. Please see the template.`
Slave SQL thread running	Indicates whether the SQL thread for executing events in the relay log is running.	Dependent item	gcp.cloudsql.mysql.repl.slave_sql_running Preprocessing JSON Path: `$.slave_sql_running` Boolean to decimal

Zabbix version 7.4 7.2 7.0 6.4 6.0

Source: templates/cloud/gcp

GCP Cloud SQL MySQL Replica by HTTP

Overview

This template is designed to monitor Google Cloud Platform Cloud SQL metrics for the MySQL read-only replica instances by Zabbix.

Requirements

Zabbix version: 7.0 and higher.

Tested versions

This template has been tested on:

GCP Cloud SQL MySQL read replica versions: 8.0, 5.7

Configuration

Setup

This template will be automatically connected to discovered entities with all their required parameters pre-defined.

Macros used

Name	Description	Default
{$GCP.DATA.TIMEOUT}	A response timeout for an API.	`15s`
{$GCP.TIME.WINDOW}	Time interval for the data requests. Supported usage type: 1. The default update interval for most of the items. 2. The minimal time window for the data requested in the Monitoring Query Language REST API request.	`5m`
{$GCP.PROXY}	Sets HTTP proxy value. If this macro is empty then no proxy is used.
{$HTTP.TLS.VERIFY}	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 "GCP Cloud SQL MySQL Replica", e.g. {$HTTP.TLS.VERIFY:"GCP Cloud SQL MySQL Replica"}.	`full`

Items

Name	Description	Type	Key and additional info
Replica metrics get	MySQL replication metrics data in raw format.	Script	gcp.cloudsql.mysql.repl.metrics.get Preprocessing Check for not supported value: `any error` ⛔️Custom on fail: Discard value
Last I/O thread error number	The error number of the most recent error that caused the I/O thread to stop.	Dependent item	gcp.cloudsql.mysql.repl.last_io_errno Preprocessing JSON Path: `$.last_io_errno`
Last SQL thread error number	The error number of the most recent error that caused the SQL thread to stop.	Dependent item	gcp.cloudsql.mysql.repl.last_sql_errno Preprocessing JSON Path: `$.last_sql_errno`
Replication lag	Number of seconds the read replica is behind its primary (approximation).	Dependent item	gcp.cloudsql.mysql.repl.replica_lag Preprocessing JSON Path: `$.replica_lag`
Network lag	Indicates time taken from primary binary log to IO thread on replica.	Dependent item	gcp.cloudsql.mysql.repl.network_lag Preprocessing JSON Path: `$.network_lag`
Replication state	The current serving state of replication. This metric is only available for the MySQL/PostgreSQL instances.	Dependent item	gcp.cloudsql.mysql.repl.state Preprocessing JSON Path: `$.state` JavaScript: `The text is too long. Please see the template.`
Slave I/O thread running	Indicates whether the I/O thread for reading the primary's binary log is running. Possible values are Yes, No and Connecting.	Dependent item	gcp.cloudsql.mysql.repl.slave_io_running Preprocessing JSON Path: `$.slave_io_running` JavaScript: `The text is too long. Please see the template.`
Slave SQL thread running	Indicates whether the SQL thread for executing events in the relay log is running.	Dependent item	gcp.cloudsql.mysql.repl.slave_sql_running Preprocessing JSON Path: `$.slave_sql_running` Boolean to decimal

Zabbix version 7.4 7.2 7.0 6.4 6.0

Source: templates/cloud/gcp

GCP Cloud SQL MySQL Replica by HTTP

Overview

This template is designed to monitor Google Cloud Platform Cloud SQL metrics for the MySQL read-only replica instances by Zabbix.

Requirements

Zabbix version: 6.4 and higher.

Tested versions

This template has been tested on:

GCP Cloud SQL MySQL read replica versions: 8.0, 5.7

Configuration

Setup

This template will be automatically connected to discovered entities with all their required parameters pre-defined.

Macros used

Name Description Default

{$GCP.DATA.TIMEOUT}

A response timeout for an API.

15s

{$GCP.TIME.WINDOW}

Time interval for the data requests.

Supported usage type:

1. The default update interval for most of the items.

2. The minimal time window for the data requested in the Monitoring Query Language REST API request.

5m

{$GCP.PROXY}

Sets HTTP proxy value. If this macro is empty then no proxy is used.

Items

Name	Description	Type	Key and additional info
GCP Cloud SQL MySQL: Replica metrics get	MySQL replication metrics data in raw format.	Script	gcp.cloudsql.mysql.repl.metrics.get Preprocessing Check for not supported value ⛔️Custom on fail: Discard value
GCP Cloud SQL MySQL: Last I/O thread error number	The error number of the most recent error that caused the I/O thread to stop.	Dependent item	gcp.cloudsql.mysql.repl.last_io_errno Preprocessing JSON Path: `$.last_io_errno`
GCP Cloud SQL MySQL: Last SQL thread error number	The error number of the most recent error that caused the SQL thread to stop.	Dependent item	gcp.cloudsql.mysql.repl.last_sql_errno Preprocessing JSON Path: `$.last_sql_errno`
GCP Cloud SQL MySQL: Replication lag	Number of seconds the read replica is behind its primary (approximation).	Dependent item	gcp.cloudsql.mysql.repl.replica_lag Preprocessing JSON Path: `$.replica_lag`
GCP Cloud SQL MySQL: Network lag	Indicates time taken from primary binary log to IO thread on replica.	Dependent item	gcp.cloudsql.mysql.repl.network_lag Preprocessing JSON Path: `$.network_lag`
GCP Cloud SQL MySQL: Replication state	The current serving state of replication. This metric is only available for the MySQL/PostgreSQL instances.	Dependent item	gcp.cloudsql.mysql.repl.state Preprocessing JSON Path: `$.state` JavaScript: `The text is too long. Please see the template.`
GCP Cloud SQL MySQL: Slave I/O thread running	Indicates whether the I/O thread for reading the primary's binary log is running. Possible values are Yes, No and Connecting.	Dependent item	gcp.cloudsql.mysql.repl.slave_io_running Preprocessing JSON Path: `$.slave_io_running` JavaScript: `The text is too long. Please see the template.`
GCP Cloud SQL MySQL: Slave SQL thread running	Indicates whether the SQL thread for executing events in the relay log is running.	Dependent item	gcp.cloudsql.mysql.repl.slave_sql_running Preprocessing JSON Path: `$.slave_sql_running` Boolean to decimal

Zabbix version 7.4 7.2 7.0 6.4 6.0

Source: templates/cloud/gcp

GCP Cloud SQL MySQL Replica by HTTP

Overview

This template is designed to monitor Google Cloud Platform Cloud SQL metrics for the MySQL read-only replica instances by Zabbix.

Requirements

Zabbix version: 6.0 and higher.

Tested versions

This template has been tested on:

GCP Cloud SQL MySQL read replica versions: 8.0, 5.7

Configuration

Setup

This template will be automatically connected to discovered entities with all their required parameters pre-defined.

Macros used

Name Description Default

{$GCP.DATA.TIMEOUT}

A response timeout for an API.

15s

{$GCP.TIME.WINDOW}

Time interval for the data requests.

Supported usage type:

1. The default update interval for most of the items.

2. The minimal time window for the data requested in the Monitoring Query Language REST API request.

5m

{$GCP.PROXY}

Sets HTTP proxy value. If this macro is empty then no proxy is used.

Items

Name	Description	Type	Key and additional info
GCP Cloud SQL MySQL: Replica metrics get	MySQL replication metrics data in raw format.	Script	gcp.cloudsql.mysql.repl.metrics.get Preprocessing Check for not supported value ⛔️Custom on fail: Discard value
GCP Cloud SQL MySQL: Last I/O thread error number	The error number of the most recent error that caused the I/O thread to stop.	Dependent item	gcp.cloudsql.mysql.repl.last_io_errno Preprocessing JSON Path: `$.last_io_errno`
GCP Cloud SQL MySQL: Last SQL thread error number	The error number of the most recent error that caused the SQL thread to stop.	Dependent item	gcp.cloudsql.mysql.repl.last_sql_errno Preprocessing JSON Path: `$.last_sql_errno`
GCP Cloud SQL MySQL: Replication lag	Number of seconds the read replica is behind its primary (approximation).	Dependent item	gcp.cloudsql.mysql.repl.replica_lag Preprocessing JSON Path: `$.replica_lag`
GCP Cloud SQL MySQL: Network lag	Indicates time taken from primary binary log to IO thread on replica.	Dependent item	gcp.cloudsql.mysql.repl.network_lag Preprocessing JSON Path: `$.network_lag`
GCP Cloud SQL MySQL: Replication state	The current serving state of replication. This metric is only available for the MySQL/PostgreSQL instances.	Dependent item	gcp.cloudsql.mysql.repl.state Preprocessing JSON Path: `$.state` JavaScript: `The text is too long. Please see the template.`
GCP Cloud SQL MySQL: Slave I/O thread running	Indicates whether the I/O thread for reading the primary's binary log is running. Possible values are Yes, No and Connecting.	Dependent item	gcp.cloudsql.mysql.repl.slave_io_running Preprocessing JSON Path: `$.slave_io_running` JavaScript: `The text is too long. Please see the template.`
GCP Cloud SQL MySQL: Slave SQL thread running	Indicates whether the SQL thread for executing events in the relay log is running.	Dependent item	gcp.cloudsql.mysql.repl.slave_sql_running Preprocessing JSON Path: `$.slave_sql_running` Boolean to decimal

Zabbix version 7.4 7.2 7.0 6.4 6.0

Source: templates/cloud/gcp

GCP Cloud SQL PostgreSQL by HTTP

Overview

This template is designed to monitor Google Cloud Platform Cloud SQL PostgreSQL database metrics by Zabbix.

Requirements

Zabbix version: 7.4 and higher.

Tested versions

This template has been tested on:

GCP Cloud SQL PostgreSQL versions: 14, 13, 12

Configuration

Setup

This template will be automatically connected to discovered entities with all their required parameters pre-defined.

Macros used

Name	Description	Default
{$GCP.DATA.TIMEOUT}	A response timeout for an API.	`15s`
{$GCP.TIME.WINDOW}	Time interval for the data requests. Supported usage type: 1. The default update interval for most of the items. 2. The minimal time window for the data requested in the Monitoring Query Language REST API request.	`5m`
{$GCP.PROXY}	Sets HTTP proxy value. If this macro is empty then no proxy is used.
{$HTTP.TLS.VERIFY}	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 "GCP Cloud SQL PostgreSQL", e.g. {$HTTP.TLS.VERIFY:"GCP Cloud SQL PostgreSQL"}.	`full`
{$GCP.CLOUD_SQL.DB.NAME.MATCHES}	The filter to include GCP Cloud SQL PostgreSQL databases by namespace.	`.*`
{$GCP.CLOUD_SQL.DB.NAME.NOT_MATCHES}	The filter to exclude GCP Cloud SQL PostgreSQL databases by namespace.	`CHANGE_IF_NEEDED`
{$CLOUD_SQL.PGSQL.DISK.UTIL.WARN}	GCP Cloud SQL PostgreSQL instance warning disk usage threshold.	`80`
{$CLOUD_SQL.PGSQL.DISK.UTIL.CRIT}	GCP Cloud SQL PostgreSQL instance critical disk usage threshold.	`90`
{$CLOUD_SQL.PGSQL.CPU.UTIL.MAX}	GCP Cloud SQL PostgreSQL instance CPU usage threshold.	`95`
{$CLOUD_SQL.PGSQL.RAM.UTIL.MAX}	GCP Cloud SQL PostgreSQL instance RAM usage threshold.	`90`

Items

Name	Description	Type	Key and additional info
Metrics get	PostgreSQL metrics data in raw format.	Script	gcp.cloudsql.pgsql.metrics.get Preprocessing Check for not supported value: `any error` ⛔️Custom on fail: Discard value
Reserved CPU cores	Number of cores reserved for the database.	Dependent item	gcp.cloudsql.pgsql.cpu.reserved_cores Preprocessing JSON Path: `$.base_reserved_cores`
CPU usage time	Cumulative CPU usage time in seconds.	Dependent item	gcp.cloudsql.pgsql.cpu.usage_time Preprocessing JSON Path: `$.base_usage_time`
CPU utilization	Current CPU utilization represented as a percentage of the reserved CPU that is currently in use.	Dependent item	gcp.cloudsql.pgsql.cpu.utilization Preprocessing JSON Path: `$.base_utilization` Custom multiplier: `100`
Disk size	Maximum data disk size in bytes.	Dependent item	gcp.cloudsql.pgsql.disk.quota Preprocessing JSON Path: `$.pgsql_quota`
Disk bytes used	Data utilization in bytes.	Dependent item	gcp.cloudsql.pgsql.disk.bytes_used Preprocessing JSON Path: `$.pgsql_bytes_used`
Disk read I/O	Delta count of data disk read I/O operations.	Dependent item	gcp.cloudsql.pgsql.disk.read_ops_count Preprocessing JSON Path: `$.base_read_ops_count`
Disk write I/O	Delta count of data disk write I/O operations.	Dependent item	gcp.cloudsql.pgsql.disk.write_ops_count Preprocessing JSON Path: `$.base_write_ops_count`
Disk utilization	The fraction of the disk quota that is currently in use. Shown as percentage.	Dependent item	gcp.cloudsql.pgsql.disk.utilization Preprocessing JSON Path: `$.pgsql_utilization` Custom multiplier: `100`
Memory size	Maximum RAM size in bytes.	Dependent item	gcp.cloudsql.pgsql.memory.quota Preprocessing JSON Path: `$.base_quota`
Memory used by DB engine	Total RAM usage in bytes. This metric reports the RAM usage of the database process, including the buffer/cache.	Dependent item	gcp.cloudsql.pgsql.memory.total_usage Preprocessing JSON Path: `$.base_total_usage`
Memory usage	The RAM usage in bytes. This metric reports the RAM usage of the server, excluding the buffer/cache.	Dependent item	gcp.cloudsql.pgsql.memory.usage Preprocessing JSON Path: `$.base_usage`
Memory utilization	The fraction of the memory quota that is currently in use. Shown as percentage.	Dependent item	gcp.cloudsql.pgsql.memory.utilization Preprocessing JSON Path: `$.base_ram_pused`
Network: Received bytes	Delta count of bytes received through the network.	Dependent item	gcp.cloudsql.pgsql.network.received_bytes_count Preprocessing JSON Path: `$.base_received_bytes_count`
Network: Sent bytes	Delta count of bytes sent through the network.	Dependent item	gcp.cloudsql.pgsql.network.sent_bytes_count Preprocessing JSON Path: `$.base_sent_bytes_count`
Instance state	GCP Cloud SQL PostgreSQL Current instance state.	HTTP agent	gcp.cloudsql.pgsql.inst.state Preprocessing JSON Path: `$.timeSeriesData[0].pointData[0].values[0].stringValue` ⛔️Custom on fail: Set value to: `10` JavaScript: `The text is too long. Please see the template.` Discard unchanged with heartbeat: `10m`
DB engine state	GCP Cloud SQL PostgreSQL DB Engine State.	HTTP agent	gcp.cloudsql.pgsql.db.state Preprocessing Check for not supported value: `any error` ⛔️Custom on fail: Discard value JSON Path: `$.timeSeriesData[0].pointData[0].values[0].int64Value` ⛔️Custom on fail: Discard value Discard unchanged with heartbeat: `10m`
Transaction ID utilization	Current utilization represented as a percentage of transaction IDs consumed by the Cloud SQL PostgreSQL instance.	Dependent item	gcp.cloudsql.pgsql.transaction_id_utilization Preprocessing JSON Path: `$.pgsql_transaction_id_utilization` Custom multiplier: `100`
Assigned transactions	Delta count of assigned transaction IDs.	Dependent item	gcp.cloudsql.pgsql.transaction_id_count_assigned Preprocessing JSON Path: `$.pgsql_assigned`
Frozen transactions	Delta count of frozen transaction IDs.	Dependent item	gcp.cloudsql.pgsql.transaction_id_count_frozen Preprocessing JSON Path: `$.pgsql_frozen`
Data written to temporary	Total data size (in bytes) written to temporary files by the queries.	Dependent item	gcp.cloudsql.pgsql.temp_bytes_written_count Preprocessing JSON Path: `$.pgsql_temp_bytes_written_count`
Temporary files used for writing data	Total number of temporary files used for writing data while performing algorithms such as join and sort.	Dependent item	gcp.cloudsql.pgsql.temp_files_written_count Preprocessing JSON Path: `$.pgsql_temp_files_written_count`
Oldest running transaction age	Age of the oldest running transaction yet to be vacuumed in the Cloud SQL PostgreSQL instance, measured in number of transactions that have happened since the oldest transaction. Empty value when there is no such transaction type.	Dependent item	gcp.cloudsql.pgsql.oldest_transaction.running Preprocessing JSON Path: `$.pgsql_running` ⛔️Custom on fail: Discard value
Oldest prepared transaction age	Age of the oldest prepared transaction yet to be vacuumed in the Cloud SQL PostgreSQL instance, measured in number of transactions that have happened since the oldest transaction. Empty value when there is no such transaction type.	Dependent item	gcp.cloudsql.pgsql.oldest_transaction.prepared Preprocessing JSON Path: `$.pgsql_prepared` ⛔️Custom on fail: Discard value
Oldest replication slot transaction age	Age of the oldest replication slot transaction yet to be vacuumed in the Cloud SQL PostgreSQL instance, measured in number of transactions that have happened since the oldest transaction. Empty value when there is no such transaction type.	Dependent item	gcp.cloudsql.pgsql.oldest_transaction.replication_slot Preprocessing JSON Path: `$.pgsql_replication_slot` ⛔️Custom on fail: Discard value
Oldest replica transaction age	Age of the oldest replica transaction yet to be vacuumed in the Cloud SQL PostgreSQL instance, measured in number of transactions that have happened since the oldest transaction. Empty value when there is no such transaction type.	Dependent item	gcp.cloudsql.pgsql.oldest_transaction.replica Preprocessing JSON Path: `$.pgsql_replica` ⛔️Custom on fail: Discard value
Connections	The number of the connections to the Cloud SQL PostgreSQL instance. Includes connections to the system databases, which aren't visible by default.	Dependent item	gcp.cloudsql.pgsql.num_backends Preprocessing JSON Path: `$.pgsql_num_backends`

Triggers

Name	Description	Expression	Severity	Dependencies and additional info
GCP PostgreSQL: High CPU utilization	The CPU utilization is too high. The system might be slow to respond.	`min(/GCP Cloud SQL PostgreSQL by HTTP/gcp.cloudsql.pgsql.cpu.utilization,5m) >= {$CLOUD_SQL.PGSQL.CPU.UTIL.MAX}`	Average
GCP PostgreSQL: Disk space is low	High utilization of the storage space.	`last(/GCP Cloud SQL PostgreSQL by HTTP/gcp.cloudsql.pgsql.disk.utilization) >= {$CLOUD_SQL.PGSQL.DISK.UTIL.WARN}`	Warning	Depends on: GCP PostgreSQL: Disk space is critically low
GCP PostgreSQL: Disk space is critically low	Critical utilization of the disk space.	`last(/GCP Cloud SQL PostgreSQL by HTTP/gcp.cloudsql.pgsql.disk.utilization) >= {$CLOUD_SQL.PGSQL.DISK.UTIL.CRIT}`	Average
GCP PostgreSQL: High memory utilization	RAM utilization is too high. The system might be slow to respond.	`min(/GCP Cloud SQL PostgreSQL by HTTP/gcp.cloudsql.pgsql.memory.utilization,5m) >= {$CLOUD_SQL.PGSQL.RAM.UTIL.MAX}`	High
GCP PostgreSQL: Instance is in suspended state	The instance is in suspended state. It is not available, for example, due to problems with billing.	`last(/GCP Cloud SQL PostgreSQL by HTTP/gcp.cloudsql.pgsql.inst.state) = 1`	Warning
GCP PostgreSQL: Instance is stopped by the owner	The instance has been stopped by the owner. It is not currently running, but it's ready to be restarted.	`last(/GCP Cloud SQL PostgreSQL by HTTP/gcp.cloudsql.pgsql.inst.state) = 2`	Info
GCP PostgreSQL: Instance is in maintenance	The instance is down for maintenance.	`last(/GCP Cloud SQL PostgreSQL by HTTP/gcp.cloudsql.pgsql.inst.state) = 4`	Info
GCP PostgreSQL: Instance is in failed state	The instance creation failed, or an operation left the instance in an own bad state.	`last(/GCP Cloud SQL PostgreSQL by HTTP/gcp.cloudsql.pgsql.inst.state) = 5`	Average
GCP PostgreSQL: Instance is in unknown state	The state of the instance is unknown.	`last(/GCP Cloud SQL PostgreSQL by HTTP/gcp.cloudsql.pgsql.inst.state) = 6`	Average
GCP PostgreSQL: Failed to get the instance state	Failed to get the instance state. Check access permissions to GCP API or service account.	`last(/GCP Cloud SQL PostgreSQL by HTTP/gcp.cloudsql.pgsql.inst.state) = 10`	Average
GCP PostgreSQL: Database engine is down	Database engine is down. If an instance experiences unplanned (non-maintenance) downtime, the instance state will still be RUNNING, but the database engine state metric will report 0.	`last(/GCP Cloud SQL PostgreSQL by HTTP/gcp.cloudsql.pgsql.db.state)=0`	Average	Depends on: GCP PostgreSQL: Instance is stopped by the owner GCP PostgreSQL: Instance is in suspended state GCP PostgreSQL: Instance is in maintenance GCP PostgreSQL: Instance is in failed state GCP PostgreSQL: Instance is in unknown state GCP PostgreSQL: Failed to get the instance state

LLD rule GCP Cloud SQL PostgreSQL: Databases discovery

Name Description Type Key and additional info

GCP Cloud SQL PostgreSQL: Databases discovery

Name	Description	Type	Key and additional info
GCP Cloud SQL PostgreSQL: Databases discovery	Databases discovery for the particular PostgreSQL instance.	HTTP agent	gcp.cloudsql.pgsql.db.discovery Preprocessing JSON Path: `$.items` Discard unchanged with heartbeat: `3h`

Databases discovery for the particular PostgreSQL instance.

HTTP agent

gcp.cloudsql.pgsql.db.discovery

Preprocessing

JSON Path: $.items
Discard unchanged with heartbeat: 3h

Item prototypes for GCP Cloud SQL PostgreSQL: Databases discovery

Name	Description	Type	Key and additional info
Database [{#PGSQL.DB.NAME}]: Metrics raw	PostgreSQL metrics in raw format.	Script	gcp.cloudsql.pgsql.db.metrics.get[{#PGSQL.DB.NAME}] Preprocessing Check for not supported value: `any error` ⛔️Custom on fail: Discard value
Database [{#PGSQL.DB.NAME}]: Deadlocks count	Number of deadlocks detected in the [{#PGSQL.DB.NAME}] database.	Dependent item	gcp.cloudsql.pgsql.deadlock_count[{#PGSQL.DB.NAME}] Preprocessing JSON Path: `$.deadlock_count`
Database [{#PGSQL.DB.NAME}]: Tuples returned	Total number of rows scanned while processing the queries of the [{#PGSQL.DB.NAME}] database.	Dependent item	gcp.cloudsql.pgsql.tuples_returned_count[{#PGSQL.DB.NAME}] Preprocessing JSON Path: `$.tuples_returned_count`
Database [{#PGSQL.DB.NAME}]: Tuples fetched	Total number of rows fetched as a result of queries to the [{#PGSQL.DB.NAME}] database.	Dependent item	gcp.cloudsql.pgsql.tuples_fetched_count[{#PGSQL.DB.NAME}] Preprocessing JSON Path: `$.tuples_fetched_count`
Database [{#PGSQL.DB.NAME}]: Committed transactions	Delta count of number of committed transactions to the [{#PGSQL.DB.NAME}] database.	Dependent item	gcp.cloudsql.pgsql.transaction_count_commit[{#PGSQL.DB.NAME}] Preprocessing JSON Path: `$.commit`
Database [{#PGSQL.DB.NAME}]: Rolled-back transactions	Delta count of number of rolled-back transactions in the [{#PGSQL.DB.NAME}] database.	Dependent item	gcp.cloudsql.pgsql.transaction_count_rollback[{#PGSQL.DB.NAME}] Preprocessing JSON Path: `$.rollback`
Database [{#PGSQL.DB.NAME}]: Buffer cache blocks read.	Number of buffer cache blocks read by the [{#PGSQL.DB.NAME}] database.	Dependent item	gcp.cloudsql.pgsql.blocks_read_count_buffer_cache[{#PGSQL.DB.NAME}] Preprocessing JSON Path: `$.buffer_cache`
Database [{#PGSQL.DB.NAME}]: Disk blocks read.	Number of disk blocks read by the [{#PGSQL.DB.NAME}] database.	Dependent item	gcp.cloudsql.pgsql.blocks_read_count_disk[{#PGSQL.DB.NAME}] Preprocessing JSON Path: `$.disk`
Database [{#PGSQL.DB.NAME}]: Inserted rows processed.	Number of tuples(rows) processed for insert operations for the database with the name [{#PGSQL.DB.NAME}].	Dependent item	gcp.cloudsql.pgsql.tuples_processed_count_insert[{#PGSQL.DB.NAME}] Preprocessing JSON Path: `$.insert`
Database [{#PGSQL.DB.NAME}]: Deleted rows processed	Number of tuples(rows) processed for delete operations for the database with the name [{#PGSQL.DB.NAME}].	Dependent item	gcp.cloudsql.pgsql.tuples_processed_count_delete[{#PGSQL.DB.NAME}] Preprocessing JSON Path: `$.delete`
Database [{#PGSQL.DB.NAME}]: Updated rows processed	Number of tuples(rows) processed for update operations for the database with the name [{#PGSQL.DB.NAME}].	Dependent item	gcp.cloudsql.pgsql.tuples_processed_count_update[{#PGSQL.DB.NAME}] Preprocessing JSON Path: `$.update`
Database [{#PGSQL.DB.NAME}]: Live tuples	Number of live tuples(rows) in the [{#PGSQL.DB.NAME}] database.	Dependent item	gcp.cloudsql.pgsql.tuple_size_live[{#PGSQL.DB.NAME}] Preprocessing JSON Path: `$.live`
Database [{#PGSQL.DB.NAME}]: Dead tuples	Number of live tuples(rows) in the [{#PGSQL.DB.NAME}] database.	Dependent item	gcp.cloudsql.pgsql.tuple_size_dead[{#PGSQL.DB.NAME}] Preprocessing JSON Path: `$.dead`

Zabbix version 7.4 7.2 7.0 6.4 6.0

Source: templates/cloud/gcp

GCP Cloud SQL PostgreSQL by HTTP

Overview

This template is designed to monitor Google Cloud Platform Cloud SQL PostgreSQL database metrics by Zabbix.

Requirements

Zabbix version: 7.2 and higher.

Tested versions

This template has been tested on:

GCP Cloud SQL PostgreSQL versions: 14, 13, 12

Configuration

Setup

This template will be automatically connected to discovered entities with all their required parameters pre-defined.

Macros used

Name	Description	Default
{$GCP.DATA.TIMEOUT}	A response timeout for an API.	`15s`
{$GCP.TIME.WINDOW}	Time interval for the data requests. Supported usage type: 1. The default update interval for most of the items. 2. The minimal time window for the data requested in the Monitoring Query Language REST API request.	`5m`
{$GCP.PROXY}	Sets HTTP proxy value. If this macro is empty then no proxy is used.
{$GCP.CLOUD_SQL.DB.NAME.MATCHES}	The filter to include GCP Cloud SQL PostgreSQL databases by namespace.	`.*`
{$GCP.CLOUD_SQL.DB.NAME.NOT_MATCHES}	The filter to exclude GCP Cloud SQL PostgreSQL databases by namespace.	`CHANGE_IF_NEEDED`
{$CLOUD_SQL.PGSQL.DISK.UTIL.WARN}	GCP Cloud SQL PostgreSQL instance warning disk usage threshold.	`80`
{$CLOUD_SQL.PGSQL.DISK.UTIL.CRIT}	GCP Cloud SQL PostgreSQL instance critical disk usage threshold.	`90`
{$CLOUD_SQL.PGSQL.CPU.UTIL.MAX}	GCP Cloud SQL PostgreSQL instance CPU usage threshold.	`95`
{$CLOUD_SQL.PGSQL.RAM.UTIL.MAX}	GCP Cloud SQL PostgreSQL instance RAM usage threshold.	`90`

Items

Name	Description	Type	Key and additional info
Metrics get	PostgreSQL metrics data in raw format.	Script	gcp.cloudsql.pgsql.metrics.get Preprocessing Check for not supported value: `any error` ⛔️Custom on fail: Discard value
Reserved CPU cores	Number of cores reserved for the database.	Dependent item	gcp.cloudsql.pgsql.cpu.reserved_cores Preprocessing JSON Path: `$.base_reserved_cores`
CPU usage time	Cumulative CPU usage time in seconds.	Dependent item	gcp.cloudsql.pgsql.cpu.usage_time Preprocessing JSON Path: `$.base_usage_time`
CPU utilization	Current CPU utilization represented as a percentage of the reserved CPU that is currently in use.	Dependent item	gcp.cloudsql.pgsql.cpu.utilization Preprocessing JSON Path: `$.base_utilization` Custom multiplier: `100`
Disk size	Maximum data disk size in bytes.	Dependent item	gcp.cloudsql.pgsql.disk.quota Preprocessing JSON Path: `$.pgsql_quota`
Disk bytes used	Data utilization in bytes.	Dependent item	gcp.cloudsql.pgsql.disk.bytes_used Preprocessing JSON Path: `$.pgsql_bytes_used`
Disk read I/O	Delta count of data disk read I/O operations.	Dependent item	gcp.cloudsql.pgsql.disk.read_ops_count Preprocessing JSON Path: `$.base_read_ops_count`
Disk write I/O	Delta count of data disk write I/O operations.	Dependent item	gcp.cloudsql.pgsql.disk.write_ops_count Preprocessing JSON Path: `$.base_write_ops_count`
Disk utilization	The fraction of the disk quota that is currently in use. Shown as percentage.	Dependent item	gcp.cloudsql.pgsql.disk.utilization Preprocessing JSON Path: `$.pgsql_utilization` Custom multiplier: `100`
Memory size	Maximum RAM size in bytes.	Dependent item	gcp.cloudsql.pgsql.memory.quota Preprocessing JSON Path: `$.base_quota`
Memory used by DB engine	Total RAM usage in bytes. This metric reports the RAM usage of the database process, including the buffer/cache.	Dependent item	gcp.cloudsql.pgsql.memory.total_usage Preprocessing JSON Path: `$.base_total_usage`
Memory usage	The RAM usage in bytes. This metric reports the RAM usage of the server, excluding the buffer/cache.	Dependent item	gcp.cloudsql.pgsql.memory.usage Preprocessing JSON Path: `$.base_usage`
Memory utilization	The fraction of the memory quota that is currently in use. Shown as percentage.	Dependent item	gcp.cloudsql.pgsql.memory.utilization Preprocessing JSON Path: `$.base_ram_pused`
Network: Received bytes	Delta count of bytes received through the network.	Dependent item	gcp.cloudsql.pgsql.network.received_bytes_count Preprocessing JSON Path: `$.base_received_bytes_count`
Network: Sent bytes	Delta count of bytes sent through the network.	Dependent item	gcp.cloudsql.pgsql.network.sent_bytes_count Preprocessing JSON Path: `$.base_sent_bytes_count`
Instance state	GCP Cloud SQL PostgreSQL Current instance state.	HTTP agent	gcp.cloudsql.pgsql.inst.state Preprocessing JSON Path: `$.timeSeriesData[0].pointData[0].values[0].stringValue` ⛔️Custom on fail: Set value to: `10` JavaScript: `The text is too long. Please see the template.` Discard unchanged with heartbeat: `10m`
DB engine state	GCP Cloud SQL PostgreSQL DB Engine State.	HTTP agent	gcp.cloudsql.pgsql.db.state Preprocessing Check for not supported value: `any error` ⛔️Custom on fail: Discard value JSON Path: `$.timeSeriesData[0].pointData[0].values[0].int64Value` ⛔️Custom on fail: Discard value Discard unchanged with heartbeat: `10m`
Transaction ID utilization	Current utilization represented as a percentage of transaction IDs consumed by the Cloud SQL PostgreSQL instance.	Dependent item	gcp.cloudsql.pgsql.transaction_id_utilization Preprocessing JSON Path: `$.pgsql_transaction_id_utilization` Custom multiplier: `100`
Assigned transactions	Delta count of assigned transaction IDs.	Dependent item	gcp.cloudsql.pgsql.transaction_id_count_assigned Preprocessing JSON Path: `$.pgsql_assigned`
Frozen transactions	Delta count of frozen transaction IDs.	Dependent item	gcp.cloudsql.pgsql.transaction_id_count_frozen Preprocessing JSON Path: `$.pgsql_frozen`
Data written to temporary	Total data size (in bytes) written to temporary files by the queries.	Dependent item	gcp.cloudsql.pgsql.temp_bytes_written_count Preprocessing JSON Path: `$.pgsql_temp_bytes_written_count`
Temporary files used for writing data	Total number of temporary files used for writing data while performing algorithms such as join and sort.	Dependent item	gcp.cloudsql.pgsql.temp_files_written_count Preprocessing JSON Path: `$.pgsql_temp_files_written_count`
Oldest running transaction age	Age of the oldest running transaction yet to be vacuumed in the Cloud SQL PostgreSQL instance, measured in number of transactions that have happened since the oldest transaction. Empty value when there is no such transaction type.	Dependent item	gcp.cloudsql.pgsql.oldest_transaction.running Preprocessing JSON Path: `$.pgsql_running` ⛔️Custom on fail: Discard value
Oldest prepared transaction age	Age of the oldest prepared transaction yet to be vacuumed in the Cloud SQL PostgreSQL instance, measured in number of transactions that have happened since the oldest transaction. Empty value when there is no such transaction type.	Dependent item	gcp.cloudsql.pgsql.oldest_transaction.prepared Preprocessing JSON Path: `$.pgsql_prepared` ⛔️Custom on fail: Discard value
Oldest replication slot transaction age	Age of the oldest replication slot transaction yet to be vacuumed in the Cloud SQL PostgreSQL instance, measured in number of transactions that have happened since the oldest transaction. Empty value when there is no such transaction type.	Dependent item	gcp.cloudsql.pgsql.oldest_transaction.replication_slot Preprocessing JSON Path: `$.pgsql_replication_slot` ⛔️Custom on fail: Discard value
Oldest replica transaction age	Age of the oldest replica transaction yet to be vacuumed in the Cloud SQL PostgreSQL instance, measured in number of transactions that have happened since the oldest transaction. Empty value when there is no such transaction type.	Dependent item	gcp.cloudsql.pgsql.oldest_transaction.replica Preprocessing JSON Path: `$.pgsql_replica` ⛔️Custom on fail: Discard value
Connections	The number of the connections to the Cloud SQL PostgreSQL instance. Includes connections to the system databases, which aren't visible by default.	Dependent item	gcp.cloudsql.pgsql.num_backends Preprocessing JSON Path: `$.pgsql_num_backends`

Triggers

Name	Description	Expression	Severity	Dependencies and additional info
GCP PostgreSQL: High CPU utilization	The CPU utilization is too high. The system might be slow to respond.	`min(/GCP Cloud SQL PostgreSQL by HTTP/gcp.cloudsql.pgsql.cpu.utilization,5m) >= {$CLOUD_SQL.PGSQL.CPU.UTIL.MAX}`	Average
GCP PostgreSQL: Disk space is low	High utilization of the storage space.	`last(/GCP Cloud SQL PostgreSQL by HTTP/gcp.cloudsql.pgsql.disk.utilization) >= {$CLOUD_SQL.PGSQL.DISK.UTIL.WARN}`	Warning	Depends on: GCP PostgreSQL: Disk space is critically low
GCP PostgreSQL: Disk space is critically low	Critical utilization of the disk space.	`last(/GCP Cloud SQL PostgreSQL by HTTP/gcp.cloudsql.pgsql.disk.utilization) >= {$CLOUD_SQL.PGSQL.DISK.UTIL.CRIT}`	Average
GCP PostgreSQL: High memory utilization	RAM utilization is too high. The system might be slow to respond.	`min(/GCP Cloud SQL PostgreSQL by HTTP/gcp.cloudsql.pgsql.memory.utilization,5m) >= {$CLOUD_SQL.PGSQL.RAM.UTIL.MAX}`	High
GCP PostgreSQL: Instance is in suspended state	The instance is in suspended state. It is not available, for example, due to problems with billing.	`last(/GCP Cloud SQL PostgreSQL by HTTP/gcp.cloudsql.pgsql.inst.state) = 1`	Warning
GCP PostgreSQL: Instance is stopped by the owner	The instance has been stopped by the owner. It is not currently running, but it's ready to be restarted.	`last(/GCP Cloud SQL PostgreSQL by HTTP/gcp.cloudsql.pgsql.inst.state) = 2`	Info
GCP PostgreSQL: Instance is in maintenance	The instance is down for maintenance.	`last(/GCP Cloud SQL PostgreSQL by HTTP/gcp.cloudsql.pgsql.inst.state) = 4`	Info
GCP PostgreSQL: Instance is in failed state	The instance creation failed, or an operation left the instance in an own bad state.	`last(/GCP Cloud SQL PostgreSQL by HTTP/gcp.cloudsql.pgsql.inst.state) = 5`	Average
GCP PostgreSQL: Instance is in unknown state	The state of the instance is unknown.	`last(/GCP Cloud SQL PostgreSQL by HTTP/gcp.cloudsql.pgsql.inst.state) = 6`	Average
GCP PostgreSQL: Failed to get the instance state	Failed to get the instance state. Check access permissions to GCP API or service account.	`last(/GCP Cloud SQL PostgreSQL by HTTP/gcp.cloudsql.pgsql.inst.state) = 10`	Average
GCP PostgreSQL: Database engine is down	Database engine is down. If an instance experiences unplanned (non-maintenance) downtime, the instance state will still be RUNNING, but the database engine state metric will report 0.	`last(/GCP Cloud SQL PostgreSQL by HTTP/gcp.cloudsql.pgsql.db.state)=0`	Average	Depends on: GCP PostgreSQL: Instance is stopped by the owner GCP PostgreSQL: Instance is in suspended state GCP PostgreSQL: Instance is in maintenance GCP PostgreSQL: Instance is in failed state GCP PostgreSQL: Instance is in unknown state GCP PostgreSQL: Failed to get the instance state

LLD rule GCP Cloud SQL PostgreSQL: Databases discovery

Name Description Type Key and additional info

GCP Cloud SQL PostgreSQL: Databases discovery

Name	Description	Type	Key and additional info
GCP Cloud SQL PostgreSQL: Databases discovery	Databases discovery for the particular PostgreSQL instance.	HTTP agent	gcp.cloudsql.pgsql.db.discovery Preprocessing JSON Path: `$.items` Discard unchanged with heartbeat: `3h`

Databases discovery for the particular PostgreSQL instance.

HTTP agent

gcp.cloudsql.pgsql.db.discovery

Preprocessing

JSON Path: $.items
Discard unchanged with heartbeat: 3h

Item prototypes for GCP Cloud SQL PostgreSQL: Databases discovery

Name	Description	Type	Key and additional info
Database [{#PGSQL.DB.NAME}]: Metrics raw	PostgreSQL metrics in raw format.	Script	gcp.cloudsql.pgsql.db.metrics.get[{#PGSQL.DB.NAME}] Preprocessing Check for not supported value: `any error` ⛔️Custom on fail: Discard value
Database [{#PGSQL.DB.NAME}]: Deadlocks count	Number of deadlocks detected in the [{#PGSQL.DB.NAME}] database.	Dependent item	gcp.cloudsql.pgsql.deadlock_count[{#PGSQL.DB.NAME}] Preprocessing JSON Path: `$.deadlock_count`
Database [{#PGSQL.DB.NAME}]: Tuples returned	Total number of rows scanned while processing the queries of the [{#PGSQL.DB.NAME}] database.	Dependent item	gcp.cloudsql.pgsql.tuples_returned_count[{#PGSQL.DB.NAME}] Preprocessing JSON Path: `$.tuples_returned_count`
Database [{#PGSQL.DB.NAME}]: Tuples fetched	Total number of rows fetched as a result of queries to the [{#PGSQL.DB.NAME}] database.	Dependent item	gcp.cloudsql.pgsql.tuples_fetched_count[{#PGSQL.DB.NAME}] Preprocessing JSON Path: `$.tuples_fetched_count`
Database [{#PGSQL.DB.NAME}]: Committed transactions	Delta count of number of committed transactions to the [{#PGSQL.DB.NAME}] database.	Dependent item	gcp.cloudsql.pgsql.transaction_count_commit[{#PGSQL.DB.NAME}] Preprocessing JSON Path: `$.commit`
Database [{#PGSQL.DB.NAME}]: Rolled-back transactions	Delta count of number of rolled-back transactions in the [{#PGSQL.DB.NAME}] database.	Dependent item	gcp.cloudsql.pgsql.transaction_count_rollback[{#PGSQL.DB.NAME}] Preprocessing JSON Path: `$.rollback`
Database [{#PGSQL.DB.NAME}]: Buffer cache blocks read.	Number of buffer cache blocks read by the [{#PGSQL.DB.NAME}] database.	Dependent item	gcp.cloudsql.pgsql.blocks_read_count_buffer_cache[{#PGSQL.DB.NAME}] Preprocessing JSON Path: `$.buffer_cache`
Database [{#PGSQL.DB.NAME}]: Disk blocks read.	Number of disk blocks read by the [{#PGSQL.DB.NAME}] database.	Dependent item	gcp.cloudsql.pgsql.blocks_read_count_disk[{#PGSQL.DB.NAME}] Preprocessing JSON Path: `$.disk`
Database [{#PGSQL.DB.NAME}]: Inserted rows processed.	Number of tuples(rows) processed for insert operations for the database with the name [{#PGSQL.DB.NAME}].	Dependent item	gcp.cloudsql.pgsql.tuples_processed_count_insert[{#PGSQL.DB.NAME}] Preprocessing JSON Path: `$.insert`
Database [{#PGSQL.DB.NAME}]: Deleted rows processed	Number of tuples(rows) processed for delete operations for the database with the name [{#PGSQL.DB.NAME}].	Dependent item	gcp.cloudsql.pgsql.tuples_processed_count_delete[{#PGSQL.DB.NAME}] Preprocessing JSON Path: `$.delete`
Database [{#PGSQL.DB.NAME}]: Updated rows processed	Number of tuples(rows) processed for update operations for the database with the name [{#PGSQL.DB.NAME}].	Dependent item	gcp.cloudsql.pgsql.tuples_processed_count_update[{#PGSQL.DB.NAME}] Preprocessing JSON Path: `$.update`
Database [{#PGSQL.DB.NAME}]: Live tuples	Number of live tuples(rows) in the [{#PGSQL.DB.NAME}] database.	Dependent item	gcp.cloudsql.pgsql.tuple_size_live[{#PGSQL.DB.NAME}] Preprocessing JSON Path: `$.live`
Database [{#PGSQL.DB.NAME}]: Dead tuples	Number of live tuples(rows) in the [{#PGSQL.DB.NAME}] database.	Dependent item	gcp.cloudsql.pgsql.tuple_size_dead[{#PGSQL.DB.NAME}] Preprocessing JSON Path: `$.dead`

Zabbix version 7.4 7.2 7.0 6.4 6.0

Source: templates/cloud/gcp

GCP Cloud SQL PostgreSQL by HTTP

Overview

This template is designed to monitor Google Cloud Platform Cloud SQL PostgreSQL database metrics by Zabbix.

Requirements

Zabbix version: 7.0 and higher.

Tested versions

This template has been tested on:

GCP Cloud SQL PostgreSQL versions: 14, 13, 12

Configuration

Setup

This template will be automatically connected to discovered entities with all their required parameters pre-defined.

Macros used

Name	Description	Default
{$GCP.DATA.TIMEOUT}	A response timeout for an API.	`15s`
{$GCP.TIME.WINDOW}	Time interval for the data requests. Supported usage type: 1. The default update interval for most of the items. 2. The minimal time window for the data requested in the Monitoring Query Language REST API request.	`5m`
{$GCP.PROXY}	Sets HTTP proxy value. If this macro is empty then no proxy is used.
{$HTTP.TLS.VERIFY}	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 "GCP Cloud SQL PostgreSQL", e.g. {$HTTP.TLS.VERIFY:"GCP Cloud SQL PostgreSQL"}.	`full`
{$GCP.CLOUD_SQL.DB.NAME.MATCHES}	The filter to include GCP Cloud SQL PostgreSQL databases by namespace.	`.*`
{$GCP.CLOUD_SQL.DB.NAME.NOT_MATCHES}	The filter to exclude GCP Cloud SQL PostgreSQL databases by namespace.	`CHANGE_IF_NEEDED`
{$CLOUD_SQL.PGSQL.DISK.UTIL.WARN}	GCP Cloud SQL PostgreSQL instance warning disk usage threshold.	`80`
{$CLOUD_SQL.PGSQL.DISK.UTIL.CRIT}	GCP Cloud SQL PostgreSQL instance critical disk usage threshold.	`90`
{$CLOUD_SQL.PGSQL.CPU.UTIL.MAX}	GCP Cloud SQL PostgreSQL instance CPU usage threshold.	`95`
{$CLOUD_SQL.PGSQL.RAM.UTIL.MAX}	GCP Cloud SQL PostgreSQL instance RAM usage threshold.	`90`

Items

Name	Description	Type	Key and additional info
Metrics get	PostgreSQL metrics data in raw format.	Script	gcp.cloudsql.pgsql.metrics.get Preprocessing Check for not supported value: `any error` ⛔️Custom on fail: Discard value
Reserved CPU cores	Number of cores reserved for the database.	Dependent item	gcp.cloudsql.pgsql.cpu.reserved_cores Preprocessing JSON Path: `$.base_reserved_cores`
CPU usage time	Cumulative CPU usage time in seconds.	Dependent item	gcp.cloudsql.pgsql.cpu.usage_time Preprocessing JSON Path: `$.base_usage_time`
CPU utilization	Current CPU utilization represented as a percentage of the reserved CPU that is currently in use.	Dependent item	gcp.cloudsql.pgsql.cpu.utilization Preprocessing JSON Path: `$.base_utilization` Custom multiplier: `100`
Disk size	Maximum data disk size in bytes.	Dependent item	gcp.cloudsql.pgsql.disk.quota Preprocessing JSON Path: `$.pgsql_quota`
Disk bytes used	Data utilization in bytes.	Dependent item	gcp.cloudsql.pgsql.disk.bytes_used Preprocessing JSON Path: `$.pgsql_bytes_used`
Disk read I/O	Delta count of data disk read I/O operations.	Dependent item	gcp.cloudsql.pgsql.disk.read_ops_count Preprocessing JSON Path: `$.base_read_ops_count`
Disk write I/O	Delta count of data disk write I/O operations.	Dependent item	gcp.cloudsql.pgsql.disk.write_ops_count Preprocessing JSON Path: `$.base_write_ops_count`
Disk utilization	The fraction of the disk quota that is currently in use. Shown as percentage.	Dependent item	gcp.cloudsql.pgsql.disk.utilization Preprocessing JSON Path: `$.pgsql_utilization` Custom multiplier: `100`
Memory size	Maximum RAM size in bytes.	Dependent item	gcp.cloudsql.pgsql.memory.quota Preprocessing JSON Path: `$.base_quota`
Memory used by DB engine	Total RAM usage in bytes. This metric reports the RAM usage of the database process, including the buffer/cache.	Dependent item	gcp.cloudsql.pgsql.memory.total_usage Preprocessing JSON Path: `$.base_total_usage`
Memory usage	The RAM usage in bytes. This metric reports the RAM usage of the server, excluding the buffer/cache.	Dependent item	gcp.cloudsql.pgsql.memory.usage Preprocessing JSON Path: `$.base_usage`
Memory utilization	The fraction of the memory quota that is currently in use. Shown as percentage.	Dependent item	gcp.cloudsql.pgsql.memory.utilization Preprocessing JSON Path: `$.base_ram_pused`
Network: Received bytes	Delta count of bytes received through the network.	Dependent item	gcp.cloudsql.pgsql.network.received_bytes_count Preprocessing JSON Path: `$.base_received_bytes_count`
Network: Sent bytes	Delta count of bytes sent through the network.	Dependent item	gcp.cloudsql.pgsql.network.sent_bytes_count Preprocessing JSON Path: `$.base_sent_bytes_count`
Instance state	GCP Cloud SQL PostgreSQL Current instance state.	HTTP agent	gcp.cloudsql.pgsql.inst.state Preprocessing JSON Path: `$.timeSeriesData[0].pointData[0].values[0].stringValue` ⛔️Custom on fail: Set value to: `10` JavaScript: `The text is too long. Please see the template.` Discard unchanged with heartbeat: `10m`
DB engine state	GCP Cloud SQL PostgreSQL DB Engine State.	HTTP agent	gcp.cloudsql.pgsql.db.state Preprocessing Check for not supported value: `any error` ⛔️Custom on fail: Discard value JSON Path: `$.timeSeriesData[0].pointData[0].values[0].int64Value` ⛔️Custom on fail: Discard value Discard unchanged with heartbeat: `10m`
Transaction ID utilization	Current utilization represented as a percentage of transaction IDs consumed by the Cloud SQL PostgreSQL instance.	Dependent item	gcp.cloudsql.pgsql.transaction_id_utilization Preprocessing JSON Path: `$.pgsql_transaction_id_utilization` Custom multiplier: `100`
Assigned transactions	Delta count of assigned transaction IDs.	Dependent item	gcp.cloudsql.pgsql.transaction_id_count_assigned Preprocessing JSON Path: `$.pgsql_assigned`
Frozen transactions	Delta count of frozen transaction IDs.	Dependent item	gcp.cloudsql.pgsql.transaction_id_count_frozen Preprocessing JSON Path: `$.pgsql_frozen`
Data written to temporary	Total data size (in bytes) written to temporary files by the queries.	Dependent item	gcp.cloudsql.pgsql.temp_bytes_written_count Preprocessing JSON Path: `$.pgsql_temp_bytes_written_count`
Temporary files used for writing data	Total number of temporary files used for writing data while performing algorithms such as join and sort.	Dependent item	gcp.cloudsql.pgsql.temp_files_written_count Preprocessing JSON Path: `$.pgsql_temp_files_written_count`
Oldest running transaction age	Age of the oldest running transaction yet to be vacuumed in the Cloud SQL PostgreSQL instance, measured in number of transactions that have happened since the oldest transaction. Empty value when there is no such transaction type.	Dependent item	gcp.cloudsql.pgsql.oldest_transaction.running Preprocessing JSON Path: `$.pgsql_running` ⛔️Custom on fail: Discard value
Oldest prepared transaction age	Age of the oldest prepared transaction yet to be vacuumed in the Cloud SQL PostgreSQL instance, measured in number of transactions that have happened since the oldest transaction. Empty value when there is no such transaction type.	Dependent item	gcp.cloudsql.pgsql.oldest_transaction.prepared Preprocessing JSON Path: `$.pgsql_prepared` ⛔️Custom on fail: Discard value
Oldest replication slot transaction age	Age of the oldest replication slot transaction yet to be vacuumed in the Cloud SQL PostgreSQL instance, measured in number of transactions that have happened since the oldest transaction. Empty value when there is no such transaction type.	Dependent item	gcp.cloudsql.pgsql.oldest_transaction.replication_slot Preprocessing JSON Path: `$.pgsql_replication_slot` ⛔️Custom on fail: Discard value
Oldest replica transaction age	Age of the oldest replica transaction yet to be vacuumed in the Cloud SQL PostgreSQL instance, measured in number of transactions that have happened since the oldest transaction. Empty value when there is no such transaction type.	Dependent item	gcp.cloudsql.pgsql.oldest_transaction.replica Preprocessing JSON Path: `$.pgsql_replica` ⛔️Custom on fail: Discard value
Connections	The number of the connections to the Cloud SQL PostgreSQL instance. Includes connections to the system databases, which aren't visible by default.	Dependent item	gcp.cloudsql.pgsql.num_backends Preprocessing JSON Path: `$.pgsql_num_backends`

Triggers

Name	Description	Expression	Severity	Dependencies and additional info
GCP PostgreSQL: High CPU utilization	The CPU utilization is too high. The system might be slow to respond.	`min(/GCP Cloud SQL PostgreSQL by HTTP/gcp.cloudsql.pgsql.cpu.utilization,5m) >= {$CLOUD_SQL.PGSQL.CPU.UTIL.MAX}`	Average
GCP PostgreSQL: Disk space is low	High utilization of the storage space.	`last(/GCP Cloud SQL PostgreSQL by HTTP/gcp.cloudsql.pgsql.disk.utilization) >= {$CLOUD_SQL.PGSQL.DISK.UTIL.WARN}`	Warning	Depends on: GCP PostgreSQL: Disk space is critically low
GCP PostgreSQL: Disk space is critically low	Critical utilization of the disk space.	`last(/GCP Cloud SQL PostgreSQL by HTTP/gcp.cloudsql.pgsql.disk.utilization) >= {$CLOUD_SQL.PGSQL.DISK.UTIL.CRIT}`	Average
GCP PostgreSQL: High memory utilization	RAM utilization is too high. The system might be slow to respond.	`min(/GCP Cloud SQL PostgreSQL by HTTP/gcp.cloudsql.pgsql.memory.utilization,5m) >= {$CLOUD_SQL.PGSQL.RAM.UTIL.MAX}`	High
GCP PostgreSQL: Instance is in suspended state	The instance is in suspended state. It is not available, for example, due to problems with billing.	`last(/GCP Cloud SQL PostgreSQL by HTTP/gcp.cloudsql.pgsql.inst.state) = 1`	Warning
GCP PostgreSQL: Instance is stopped by the owner	The instance has been stopped by the owner. It is not currently running, but it's ready to be restarted.	`last(/GCP Cloud SQL PostgreSQL by HTTP/gcp.cloudsql.pgsql.inst.state) = 2`	Info
GCP PostgreSQL: Instance is in maintenance	The instance is down for maintenance.	`last(/GCP Cloud SQL PostgreSQL by HTTP/gcp.cloudsql.pgsql.inst.state) = 4`	Info
GCP PostgreSQL: Instance is in failed state	The instance creation failed, or an operation left the instance in an own bad state.	`last(/GCP Cloud SQL PostgreSQL by HTTP/gcp.cloudsql.pgsql.inst.state) = 5`	Average
GCP PostgreSQL: Instance is in unknown state	The state of the instance is unknown.	`last(/GCP Cloud SQL PostgreSQL by HTTP/gcp.cloudsql.pgsql.inst.state) = 6`	Average
GCP PostgreSQL: Failed to get the instance state	Failed to get the instance state. Check access permissions to GCP API or service account.	`last(/GCP Cloud SQL PostgreSQL by HTTP/gcp.cloudsql.pgsql.inst.state) = 10`	Average
GCP PostgreSQL: Database engine is down	Database engine is down. If an instance experiences unplanned (non-maintenance) downtime, the instance state will still be RUNNING, but the database engine state metric will report 0.	`last(/GCP Cloud SQL PostgreSQL by HTTP/gcp.cloudsql.pgsql.db.state)=0`	Average	Depends on: GCP PostgreSQL: Instance is stopped by the owner GCP PostgreSQL: Instance is in suspended state GCP PostgreSQL: Instance is in maintenance GCP PostgreSQL: Instance is in failed state GCP PostgreSQL: Instance is in unknown state GCP PostgreSQL: Failed to get the instance state

LLD rule GCP Cloud SQL PostgreSQL: Databases discovery

Name Description Type Key and additional info

GCP Cloud SQL PostgreSQL: Databases discovery

Name	Description	Type	Key and additional info
GCP Cloud SQL PostgreSQL: Databases discovery	Databases discovery for the particular PostgreSQL instance.	HTTP agent	gcp.cloudsql.pgsql.db.discovery Preprocessing JSON Path: `$.items` Discard unchanged with heartbeat: `3h`

Databases discovery for the particular PostgreSQL instance.

HTTP agent

gcp.cloudsql.pgsql.db.discovery

Preprocessing

JSON Path: $.items
Discard unchanged with heartbeat: 3h

Item prototypes for GCP Cloud SQL PostgreSQL: Databases discovery

Name	Description	Type	Key and additional info
Database [{#PGSQL.DB.NAME}]: Metrics raw	PostgreSQL metrics in raw format.	Script	gcp.cloudsql.pgsql.db.metrics.get[{#PGSQL.DB.NAME}] Preprocessing Check for not supported value: `any error` ⛔️Custom on fail: Discard value
Database [{#PGSQL.DB.NAME}]: Deadlocks count	Number of deadlocks detected in the [{#PGSQL.DB.NAME}] database.	Dependent item	gcp.cloudsql.pgsql.deadlock_count[{#PGSQL.DB.NAME}] Preprocessing JSON Path: `$.deadlock_count`
Database [{#PGSQL.DB.NAME}]: Tuples returned	Total number of rows scanned while processing the queries of the [{#PGSQL.DB.NAME}] database.	Dependent item	gcp.cloudsql.pgsql.tuples_returned_count[{#PGSQL.DB.NAME}] Preprocessing JSON Path: `$.tuples_returned_count`
Database [{#PGSQL.DB.NAME}]: Tuples fetched	Total number of rows fetched as a result of queries to the [{#PGSQL.DB.NAME}] database.	Dependent item	gcp.cloudsql.pgsql.tuples_fetched_count[{#PGSQL.DB.NAME}] Preprocessing JSON Path: `$.tuples_fetched_count`
Database [{#PGSQL.DB.NAME}]: Committed transactions	Delta count of number of committed transactions to the [{#PGSQL.DB.NAME}] database.	Dependent item	gcp.cloudsql.pgsql.transaction_count_commit[{#PGSQL.DB.NAME}] Preprocessing JSON Path: `$.commit`
Database [{#PGSQL.DB.NAME}]: Rolled-back transactions	Delta count of number of rolled-back transactions in the [{#PGSQL.DB.NAME}] database.	Dependent item	gcp.cloudsql.pgsql.transaction_count_rollback[{#PGSQL.DB.NAME}] Preprocessing JSON Path: `$.rollback`
Database [{#PGSQL.DB.NAME}]: Buffer cache blocks read.	Number of buffer cache blocks read by the [{#PGSQL.DB.NAME}] database.	Dependent item	gcp.cloudsql.pgsql.blocks_read_count_buffer_cache[{#PGSQL.DB.NAME}] Preprocessing JSON Path: `$.buffer_cache`
Database [{#PGSQL.DB.NAME}]: Disk blocks read.	Number of disk blocks read by the [{#PGSQL.DB.NAME}] database.	Dependent item	gcp.cloudsql.pgsql.blocks_read_count_disk[{#PGSQL.DB.NAME}] Preprocessing JSON Path: `$.disk`
Database [{#PGSQL.DB.NAME}]: Inserted rows processed.	Number of tuples(rows) processed for insert operations for the database with the name [{#PGSQL.DB.NAME}].	Dependent item	gcp.cloudsql.pgsql.tuples_processed_count_insert[{#PGSQL.DB.NAME}] Preprocessing JSON Path: `$.insert`
Database [{#PGSQL.DB.NAME}]: Deleted rows processed	Number of tuples(rows) processed for delete operations for the database with the name [{#PGSQL.DB.NAME}].	Dependent item	gcp.cloudsql.pgsql.tuples_processed_count_delete[{#PGSQL.DB.NAME}] Preprocessing JSON Path: `$.delete`
Database [{#PGSQL.DB.NAME}]: Updated rows processed	Number of tuples(rows) processed for update operations for the database with the name [{#PGSQL.DB.NAME}].	Dependent item	gcp.cloudsql.pgsql.tuples_processed_count_update[{#PGSQL.DB.NAME}] Preprocessing JSON Path: `$.update`
Database [{#PGSQL.DB.NAME}]: Live tuples	Number of live tuples(rows) in the [{#PGSQL.DB.NAME}] database.	Dependent item	gcp.cloudsql.pgsql.tuple_size_live[{#PGSQL.DB.NAME}] Preprocessing JSON Path: `$.live`
Database [{#PGSQL.DB.NAME}]: Dead tuples	Number of live tuples(rows) in the [{#PGSQL.DB.NAME}] database.	Dependent item	gcp.cloudsql.pgsql.tuple_size_dead[{#PGSQL.DB.NAME}] Preprocessing JSON Path: `$.dead`

Zabbix version 7.4 7.2 7.0 6.4 6.0

Source: templates/cloud/gcp

GCP Cloud SQL PostgreSQL by HTTP

Overview

This template is designed to monitor Google Cloud Platform Cloud SQL PostgreSQL database metrics by Zabbix.

Requirements

Zabbix version: 6.4 and higher.

Tested versions

This template has been tested on:

GCP Cloud SQL PostgreSQL versions: 14, 13, 12

Configuration

Setup

This template will be automatically connected to discovered entities with all their required parameters pre-defined.

Macros used

Name	Description	Default
{$GCP.DATA.TIMEOUT}	A response timeout for an API.	`15s`
{$GCP.TIME.WINDOW}	Time interval for the data requests. Supported usage type: 1. The default update interval for most of the items. 2. The minimal time window for the data requested in the Monitoring Query Language REST API request.	`5m`
{$GCP.PROXY}	Sets HTTP proxy value. If this macro is empty then no proxy is used.
{$GCP.CLOUD_SQL.DB.NAME.MATCHES}	The filter to include GCP Cloud SQL PostgreSQL databases by namespace.	`.*`
{$GCP.CLOUD_SQL.DB.NAME.NOT_MATCHES}	The filter to exclude GCP Cloud SQL PostgreSQL databases by namespace.	`CHANGE_IF_NEEDED`
{$CLOUD_SQL.PGSQL.DISK.UTIL.WARN}	GCP Cloud SQL PostgreSQL instance warning disk usage threshold.	`80`
{$CLOUD_SQL.PGSQL.DISK.UTIL.CRIT}	GCP Cloud SQL PostgreSQL instance critical disk usage threshold.	`90`
{$CLOUD_SQL.PGSQL.CPU.UTIL.MAX}	GCP Cloud SQL PostgreSQL instance CPU usage threshold.	`95`
{$CLOUD_SQL.PGSQL.RAM.UTIL.MAX}	GCP Cloud SQL PostgreSQL instance RAM usage threshold.	`90`

Items

Name	Description	Type	Key and additional info
GCP Cloud SQL PostgreSQL: Metrics get	PostgreSQL metrics data in raw format.	Script	gcp.cloudsql.pgsql.metrics.get Preprocessing Check for not supported value ⛔️Custom on fail: Discard value
GCP Cloud SQL PostgreSQL: Reserved CPU cores	Number of cores reserved for the database.	Dependent item	gcp.cloudsql.pgsql.cpu.reserved_cores Preprocessing JSON Path: `$.base_reserved_cores`
GCP Cloud SQL PostgreSQL: CPU usage time	Cumulative CPU usage time in seconds.	Dependent item	gcp.cloudsql.pgsql.cpu.usage_time Preprocessing JSON Path: `$.base_usage_time`
GCP Cloud SQL PostgreSQL: CPU utilization	Current CPU utilization represented as a percentage of the reserved CPU that is currently in use.	Dependent item	gcp.cloudsql.pgsql.cpu.utilization Preprocessing JSON Path: `$.base_utilization` Custom multiplier: `100`
GCP Cloud SQL PostgreSQL: Disk size	Maximum data disk size in bytes.	Dependent item	gcp.cloudsql.pgsql.disk.quota Preprocessing JSON Path: `$.pgsql_quota`
GCP Cloud SQL PostgreSQL: Disk bytes used	Data utilization in bytes.	Dependent item	gcp.cloudsql.pgsql.disk.bytes_used Preprocessing JSON Path: `$.pgsql_bytes_used`
GCP Cloud SQL PostgreSQL: Disk read I/O	Delta count of data disk read I/O operations.	Dependent item	gcp.cloudsql.pgsql.disk.read_ops_count Preprocessing JSON Path: `$.base_read_ops_count`
GCP Cloud SQL PostgreSQL: Disk write I/O	Delta count of data disk write I/O operations.	Dependent item	gcp.cloudsql.pgsql.disk.write_ops_count Preprocessing JSON Path: `$.base_write_ops_count`
GCP Cloud SQL PostgreSQL: Disk utilization	The fraction of the disk quota that is currently in use. Shown as percentage.	Dependent item	gcp.cloudsql.pgsql.disk.utilization Preprocessing JSON Path: `$.pgsql_utilization` Custom multiplier: `100`
GCP Cloud SQL PostgreSQL: Memory size	Maximum RAM size in bytes.	Dependent item	gcp.cloudsql.pgsql.memory.quota Preprocessing JSON Path: `$.base_quota`
GCP Cloud SQL PostgreSQL: Memory used by DB engine	Total RAM usage in bytes. This metric reports the RAM usage of the database process, including the buffer/cache.	Dependent item	gcp.cloudsql.pgsql.memory.total_usage Preprocessing JSON Path: `$.base_total_usage`
GCP Cloud SQL PostgreSQL: Memory usage	The RAM usage in bytes. This metric reports the RAM usage of the server, excluding the buffer/cache.	Dependent item	gcp.cloudsql.pgsql.memory.usage Preprocessing JSON Path: `$.base_usage`
GCP Cloud SQL PostgreSQL: Memory utilization	The fraction of the memory quota that is currently in use. Shown as percentage.	Dependent item	gcp.cloudsql.pgsql.memory.utilization Preprocessing JSON Path: `$.base_ram_pused`
GCP Cloud SQL PostgreSQL: Network: Received bytes	Delta count of bytes received through the network.	Dependent item	gcp.cloudsql.pgsql.network.received_bytes_count Preprocessing JSON Path: `$.base_received_bytes_count`
GCP Cloud SQL PostgreSQL: Network: Sent bytes	Delta count of bytes sent through the network.	Dependent item	gcp.cloudsql.pgsql.network.sent_bytes_count Preprocessing JSON Path: `$.base_sent_bytes_count`
GCP Cloud SQL PostgreSQL: Instance state	GCP Cloud SQL PostgreSQL Current instance state.	HTTP agent	gcp.cloudsql.pgsql.inst.state Preprocessing JSON Path: `$.timeSeriesData[0].pointData[0].values[0].stringValue` ⛔️Custom on fail: Set value to: `10` JavaScript: `The text is too long. Please see the template.` Discard unchanged with heartbeat: `10m`
GCP Cloud SQL PostgreSQL: DB engine state	GCP Cloud SQL PostgreSQL DB Engine State.	HTTP agent	gcp.cloudsql.pgsql.db.state Preprocessing Check for not supported value ⛔️Custom on fail: Discard value JSON Path: `$.timeSeriesData[0].pointData[0].values[0].int64Value` ⛔️Custom on fail: Discard value Discard unchanged with heartbeat: `10m`
GCP Cloud SQL PostgreSQL: Transaction ID utilization	Current utilization represented as a percentage of transaction IDs consumed by the Cloud SQL PostgreSQL instance.	Dependent item	gcp.cloudsql.pgsql.transaction_id_utilization Preprocessing JSON Path: `$.pgsql_transaction_id_utilization` Custom multiplier: `100`
GCP Cloud SQL PostgreSQL: Assigned transactions	Delta count of assigned transaction IDs.	Dependent item	gcp.cloudsql.pgsql.transaction_id_count_assigned Preprocessing JSON Path: `$.pgsql_assigned`
GCP Cloud SQL PostgreSQL: Frozen transactions	Delta count of frozen transaction IDs.	Dependent item	gcp.cloudsql.pgsql.transaction_id_count_frozen Preprocessing JSON Path: `$.pgsql_frozen`
GCP Cloud SQL PostgreSQL: Data written to temporary	Total data size (in bytes) written to temporary files by the queries.	Dependent item	gcp.cloudsql.pgsql.temp_bytes_written_count Preprocessing JSON Path: `$.pgsql_temp_bytes_written_count`
GCP Cloud SQL PostgreSQL: Temporary files used for writing data	Total number of temporary files used for writing data while performing algorithms such as join and sort.	Dependent item	gcp.cloudsql.pgsql.temp_files_written_count Preprocessing JSON Path: `$.pgsql_temp_files_written_count`
GCP Cloud SQL PostgreSQL: Oldest running transaction age	Age of the oldest running transaction yet to be vacuumed in the Cloud SQL PostgreSQL instance, measured in number of transactions that have happened since the oldest transaction. Empty value when there is no such transaction type.	Dependent item	gcp.cloudsql.pgsql.oldest_transaction.running Preprocessing JSON Path: `$.pgsql_running` ⛔️Custom on fail: Discard value
GCP Cloud SQL PostgreSQL: Oldest prepared transaction age	Age of the oldest prepared transaction yet to be vacuumed in the Cloud SQL PostgreSQL instance, measured in number of transactions that have happened since the oldest transaction. Empty value when there is no such transaction type.	Dependent item	gcp.cloudsql.pgsql.oldest_transaction.prepared Preprocessing JSON Path: `$.pgsql_prepared` ⛔️Custom on fail: Discard value
GCP Cloud SQL PostgreSQL: Oldest replication slot transaction age	Age of the oldest replication slot transaction yet to be vacuumed in the Cloud SQL PostgreSQL instance, measured in number of transactions that have happened since the oldest transaction. Empty value when there is no such transaction type.	Dependent item	gcp.cloudsql.pgsql.oldest_transaction.replication_slot Preprocessing JSON Path: `$.pgsql_replication_slot` ⛔️Custom on fail: Discard value
GCP Cloud SQL PostgreSQL: Oldest replica transaction age	Age of the oldest replica transaction yet to be vacuumed in the Cloud SQL PostgreSQL instance, measured in number of transactions that have happened since the oldest transaction. Empty value when there is no such transaction type.	Dependent item	gcp.cloudsql.pgsql.oldest_transaction.replica Preprocessing JSON Path: `$.pgsql_replica` ⛔️Custom on fail: Discard value
GCP Cloud SQL PostgreSQL: Connections	The number of the connections to the Cloud SQL PostgreSQL instance. Includes connections to the system databases, which aren't visible by default.	Dependent item	gcp.cloudsql.pgsql.num_backends Preprocessing JSON Path: `$.pgsql_num_backends`

Triggers

Name	Description	Expression	Severity	Dependencies and additional info
GCP Cloud SQL PostgreSQL: High CPU utilization	The CPU utilization is too high. The system might be slow to respond.	`min(/GCP Cloud SQL PostgreSQL by HTTP/gcp.cloudsql.pgsql.cpu.utilization,5m) >= {$CLOUD_SQL.PGSQL.CPU.UTIL.MAX}`	Average
GCP Cloud SQL PostgreSQL: Disk space is low	High utilization of the storage space.	`last(/GCP Cloud SQL PostgreSQL by HTTP/gcp.cloudsql.pgsql.disk.utilization) >= {$CLOUD_SQL.PGSQL.DISK.UTIL.WARN}`	Warning	Depends on: GCP Cloud SQL PostgreSQL: Disk space is critically low
GCP Cloud SQL PostgreSQL: Disk space is critically low	Critical utilization of the disk space.	`last(/GCP Cloud SQL PostgreSQL by HTTP/gcp.cloudsql.pgsql.disk.utilization) >= {$CLOUD_SQL.PGSQL.DISK.UTIL.CRIT}`	Average
GCP Cloud SQL PostgreSQL: High memory utilization	RAM utilization is too high. The system might be slow to respond.	`min(/GCP Cloud SQL PostgreSQL by HTTP/gcp.cloudsql.pgsql.memory.utilization,5m) >= {$CLOUD_SQL.PGSQL.RAM.UTIL.MAX}`	High
GCP Cloud SQL PostgreSQL: Instance is in suspended state	The instance is in suspended state. It is not available, for example, due to problems with billing.	`last(/GCP Cloud SQL PostgreSQL by HTTP/gcp.cloudsql.pgsql.inst.state) = 1`	Warning
GCP Cloud SQL PostgreSQL: Instance is stopped by the owner	The instance has been stopped by the owner. It is not currently running, but it's ready to be restarted.	`last(/GCP Cloud SQL PostgreSQL by HTTP/gcp.cloudsql.pgsql.inst.state) = 2`	Info
GCP Cloud SQL PostgreSQL: Instance is in maintenance	The instance is down for maintenance.	`last(/GCP Cloud SQL PostgreSQL by HTTP/gcp.cloudsql.pgsql.inst.state) = 4`	Info
GCP Cloud SQL PostgreSQL: Instance is in failed state	The instance creation failed, or an operation left the instance in an own bad state.	`last(/GCP Cloud SQL PostgreSQL by HTTP/gcp.cloudsql.pgsql.inst.state) = 5`	Average
GCP Cloud SQL PostgreSQL: Instance is in unknown state	The state of the instance is unknown.	`last(/GCP Cloud SQL PostgreSQL by HTTP/gcp.cloudsql.pgsql.inst.state) = 6`	Average
GCP Cloud SQL PostgreSQL: Failed to get the instance state	Failed to get the instance state. Check access permissions to GCP API or service account.	`last(/GCP Cloud SQL PostgreSQL by HTTP/gcp.cloudsql.pgsql.inst.state) = 10`	Average
GCP Cloud SQL PostgreSQL: Database engine is down	Database engine is down. If an instance experiences unplanned (non-maintenance) downtime, the instance state will still be RUNNING, but the database engine state metric will report 0.	`last(/GCP Cloud SQL PostgreSQL by HTTP/gcp.cloudsql.pgsql.db.state)=0`	Average	Depends on: GCP Cloud SQL PostgreSQL: Instance is stopped by the owner GCP Cloud SQL PostgreSQL: Instance is in suspended state GCP Cloud SQL PostgreSQL: Instance is in maintenance GCP Cloud SQL PostgreSQL: Instance is in failed state GCP Cloud SQL PostgreSQL: Instance is in unknown state GCP Cloud SQL PostgreSQL: Failed to get the instance state

LLD rule GCP Cloud SQL PostgreSQL: Databases discovery

Name Description Type Key and additional info

GCP Cloud SQL PostgreSQL: Databases discovery

Name	Description	Type	Key and additional info
GCP Cloud SQL PostgreSQL: Databases discovery	Databases discovery for the particular PostgreSQL instance.	HTTP agent	gcp.cloudsql.pgsql.db.discovery Preprocessing JSON Path: `$.items` Discard unchanged with heartbeat: `3h`

Databases discovery for the particular PostgreSQL instance.

HTTP agent

gcp.cloudsql.pgsql.db.discovery

Preprocessing

JSON Path: $.items
Discard unchanged with heartbeat: 3h

Item prototypes for GCP Cloud SQL PostgreSQL: Databases discovery

Name	Description	Type	Key and additional info
GCP Cloud SQL PostgreSQL: Database [{#PGSQL.DB.NAME}]: Metrics raw	PostgreSQL metrics in raw format.	Script	gcp.cloudsql.pgsql.db.metrics.get[{#PGSQL.DB.NAME}] Preprocessing Check for not supported value ⛔️Custom on fail: Discard value
GCP Cloud SQL PostgreSQL: Database [{#PGSQL.DB.NAME}]: Deadlocks count	Number of deadlocks detected in the [{#PGSQL.DB.NAME}] database.	Dependent item	gcp.cloudsql.pgsql.deadlock_count[{#PGSQL.DB.NAME}] Preprocessing JSON Path: `$.deadlock_count`
GCP Cloud SQL PostgreSQL: Database [{#PGSQL.DB.NAME}]: Tuples returned	Total number of rows scanned while processing the queries of the [{#PGSQL.DB.NAME}] database.	Dependent item	gcp.cloudsql.pgsql.tuples_returned_count[{#PGSQL.DB.NAME}] Preprocessing JSON Path: `$.tuples_returned_count`
GCP Cloud SQL PostgreSQL: Database [{#PGSQL.DB.NAME}]: Tuples fetched	Total number of rows fetched as a result of queries to the [{#PGSQL.DB.NAME}] database.	Dependent item	gcp.cloudsql.pgsql.tuples_fetched_count[{#PGSQL.DB.NAME}] Preprocessing JSON Path: `$.tuples_fetched_count`
GCP Cloud SQL PostgreSQL: Database [{#PGSQL.DB.NAME}]: Committed transactions	Delta count of number of committed transactions to the [{#PGSQL.DB.NAME}] database.	Dependent item	gcp.cloudsql.pgsql.transaction_count_commit[{#PGSQL.DB.NAME}] Preprocessing JSON Path: `$.commit`
GCP Cloud SQL PostgreSQL: Database [{#PGSQL.DB.NAME}]: Rolled-back transactions	Delta count of number of rolled-back transactions in the [{#PGSQL.DB.NAME}] database.	Dependent item	gcp.cloudsql.pgsql.transaction_count_rollback[{#PGSQL.DB.NAME}] Preprocessing JSON Path: `$.rollback`
GCP Cloud SQL PostgreSQL: Database [{#PGSQL.DB.NAME}]: Buffer cache blocks read.	Number of buffer cache blocks read by the [{#PGSQL.DB.NAME}] database.	Dependent item	gcp.cloudsql.pgsql.blocks_read_count_buffer_cache[{#PGSQL.DB.NAME}] Preprocessing JSON Path: `$.buffer_cache`
GCP Cloud SQL PostgreSQL: Database [{#PGSQL.DB.NAME}]: Disk blocks read.	Number of disk blocks read by the [{#PGSQL.DB.NAME}] database.	Dependent item	gcp.cloudsql.pgsql.blocks_read_count_disk[{#PGSQL.DB.NAME}] Preprocessing JSON Path: `$.disk`
GCP Cloud SQL PostgreSQL: Database [{#PGSQL.DB.NAME}]: Inserted rows processed.	Number of tuples(rows) processed for insert operations for the database with the name [{#PGSQL.DB.NAME}].	Dependent item	gcp.cloudsql.pgsql.tuples_processed_count_insert[{#PGSQL.DB.NAME}] Preprocessing JSON Path: `$.insert`
GCP Cloud SQL PostgreSQL: Database [{#PGSQL.DB.NAME}]: Deleted rows processed	Number of tuples(rows) processed for delete operations for the database with the name [{#PGSQL.DB.NAME}].	Dependent item	gcp.cloudsql.pgsql.tuples_processed_count_delete[{#PGSQL.DB.NAME}] Preprocessing JSON Path: `$.delete`
GCP Cloud SQL PostgreSQL: Database [{#PGSQL.DB.NAME}]: Updated rows processed	Number of tuples(rows) processed for update operations for the database with the name [{#PGSQL.DB.NAME}].	Dependent item	gcp.cloudsql.pgsql.tuples_processed_count_update[{#PGSQL.DB.NAME}] Preprocessing JSON Path: `$.update`
GCP Cloud SQL PostgreSQL: Database [{#PGSQL.DB.NAME}]: Live tuples	Number of live tuples(rows) in the [{#PGSQL.DB.NAME}] database.	Dependent item	gcp.cloudsql.pgsql.tuple_size_live[{#PGSQL.DB.NAME}] Preprocessing JSON Path: `$.live`
GCP Cloud SQL PostgreSQL: Database [{#PGSQL.DB.NAME}]: Dead tuples	Number of live tuples(rows) in the [{#PGSQL.DB.NAME}] database.	Dependent item	gcp.cloudsql.pgsql.tuple_size_dead[{#PGSQL.DB.NAME}] Preprocessing JSON Path: `$.dead`

Zabbix version 7.4 7.2 7.0 6.4 6.0

Source: templates/cloud/gcp

GCP Cloud SQL PostgreSQL by HTTP

Overview

This template is designed to monitor Google Cloud Platform Cloud SQL PostgreSQL database metrics by Zabbix.

Requirements

Zabbix version: 6.0 and higher.

Tested versions

This template has been tested on:

GCP Cloud SQL PostgreSQL versions: 14, 13, 12

Configuration

Setup

This template will be automatically connected to discovered entities with all their required parameters pre-defined.

Macros used

Name	Description	Default
{$GCP.DATA.TIMEOUT}	A response timeout for an API.	`15s`
{$GCP.TIME.WINDOW}	Time interval for the data requests. Supported usage type: 1. The default update interval for most of the items. 2. The minimal time window for the data requested in the Monitoring Query Language REST API request.	`5m`
{$GCP.PROXY}	Sets HTTP proxy value. If this macro is empty then no proxy is used.
{$GCP.CLOUD_SQL.DB.NAME.MATCHES}	The filter to include GCP Cloud SQL PostgreSQL databases by namespace.	`.*`
{$GCP.CLOUD_SQL.DB.NAME.NOT_MATCHES}	The filter to exclude GCP Cloud SQL PostgreSQL databases by namespace.	`CHANGE_IF_NEEDED`
{$CLOUD_SQL.PGSQL.DISK.UTIL.WARN}	GCP Cloud SQL PostgreSQL instance warning disk usage threshold.	`80`
{$CLOUD_SQL.PGSQL.DISK.UTIL.CRIT}	GCP Cloud SQL PostgreSQL instance critical disk usage threshold.	`90`
{$CLOUD_SQL.PGSQL.CPU.UTIL.MAX}	GCP Cloud SQL PostgreSQL instance CPU usage threshold.	`95`
{$CLOUD_SQL.PGSQL.RAM.UTIL.MAX}	GCP Cloud SQL PostgreSQL instance RAM usage threshold.	`90`

Items

Name	Description	Type	Key and additional info
GCP Cloud SQL PostgreSQL: Metrics get	PostgreSQL metrics data in raw format.	Script	gcp.cloudsql.pgsql.metrics.get Preprocessing Check for not supported value ⛔️Custom on fail: Discard value
GCP Cloud SQL PostgreSQL: Reserved CPU cores	Number of cores reserved for the database.	Dependent item	gcp.cloudsql.pgsql.cpu.reserved_cores Preprocessing JSON Path: `$.base_reserved_cores`
GCP Cloud SQL PostgreSQL: CPU usage time	Cumulative CPU usage time in seconds.	Dependent item	gcp.cloudsql.pgsql.cpu.usage_time Preprocessing JSON Path: `$.base_usage_time`
GCP Cloud SQL PostgreSQL: CPU utilization	Current CPU utilization represented as a percentage of the reserved CPU that is currently in use.	Dependent item	gcp.cloudsql.pgsql.cpu.utilization Preprocessing JSON Path: `$.base_utilization` Custom multiplier: `100`
GCP Cloud SQL PostgreSQL: Disk size	Maximum data disk size in bytes.	Dependent item	gcp.cloudsql.pgsql.disk.quota Preprocessing JSON Path: `$.pgsql_quota`
GCP Cloud SQL PostgreSQL: Disk bytes used	Data utilization in bytes.	Dependent item	gcp.cloudsql.pgsql.disk.bytes_used Preprocessing JSON Path: `$.pgsql_bytes_used`
GCP Cloud SQL PostgreSQL: Disk read I/O	Delta count of data disk read I/O operations.	Dependent item	gcp.cloudsql.pgsql.disk.read_ops_count Preprocessing JSON Path: `$.base_read_ops_count`
GCP Cloud SQL PostgreSQL: Disk write I/O	Delta count of data disk write I/O operations.	Dependent item	gcp.cloudsql.pgsql.disk.write_ops_count Preprocessing JSON Path: `$.base_write_ops_count`
GCP Cloud SQL PostgreSQL: Disk utilization	The fraction of the disk quota that is currently in use. Shown as percentage.	Dependent item	gcp.cloudsql.pgsql.disk.utilization Preprocessing JSON Path: `$.pgsql_utilization` Custom multiplier: `100`
GCP Cloud SQL PostgreSQL: Memory size	Maximum RAM size in bytes.	Dependent item	gcp.cloudsql.pgsql.memory.quota Preprocessing JSON Path: `$.base_quota`
GCP Cloud SQL PostgreSQL: Memory used by DB engine	Total RAM usage in bytes. This metric reports the RAM usage of the database process, including the buffer/cache.	Dependent item	gcp.cloudsql.pgsql.memory.total_usage Preprocessing JSON Path: `$.base_total_usage`
GCP Cloud SQL PostgreSQL: Memory usage	The RAM usage in bytes. This metric reports the RAM usage of the server, excluding the buffer/cache.	Dependent item	gcp.cloudsql.pgsql.memory.usage Preprocessing JSON Path: `$.base_usage`
GCP Cloud SQL PostgreSQL: Memory utilization	The fraction of the memory quota that is currently in use. Shown as percentage.	Dependent item	gcp.cloudsql.pgsql.memory.utilization Preprocessing JSON Path: `$.base_ram_pused`
GCP Cloud SQL PostgreSQL: Network: Received bytes	Delta count of bytes received through the network.	Dependent item	gcp.cloudsql.pgsql.network.received_bytes_count Preprocessing JSON Path: `$.base_received_bytes_count`
GCP Cloud SQL PostgreSQL: Network: Sent bytes	Delta count of bytes sent through the network.	Dependent item	gcp.cloudsql.pgsql.network.sent_bytes_count Preprocessing JSON Path: `$.base_sent_bytes_count`
GCP Cloud SQL PostgreSQL: Instance state	GCP Cloud SQL PostgreSQL Current instance state.	HTTP agent	gcp.cloudsql.pgsql.inst.state Preprocessing JSON Path: `$.timeSeriesData[0].pointData[0].values[0].stringValue` ⛔️Custom on fail: Set value to: `10` JavaScript: `The text is too long. Please see the template.` Discard unchanged with heartbeat: `10m`
GCP Cloud SQL PostgreSQL: DB engine state	GCP Cloud SQL PostgreSQL DB Engine State.	HTTP agent	gcp.cloudsql.pgsql.db.state Preprocessing Check for not supported value ⛔️Custom on fail: Discard value JSON Path: `$.timeSeriesData[0].pointData[0].values[0].int64Value` ⛔️Custom on fail: Discard value Discard unchanged with heartbeat: `10m`
GCP Cloud SQL PostgreSQL: Transaction ID utilization	Current utilization represented as a percentage of transaction IDs consumed by the Cloud SQL PostgreSQL instance.	Dependent item	gcp.cloudsql.pgsql.transaction_id_utilization Preprocessing JSON Path: `$.pgsql_transaction_id_utilization` Custom multiplier: `100`
GCP Cloud SQL PostgreSQL: Assigned transactions	Delta count of assigned transaction IDs.	Dependent item	gcp.cloudsql.pgsql.transaction_id_count_assigned Preprocessing JSON Path: `$.pgsql_assigned`
GCP Cloud SQL PostgreSQL: Frozen transactions	Delta count of frozen transaction IDs.	Dependent item	gcp.cloudsql.pgsql.transaction_id_count_frozen Preprocessing JSON Path: `$.pgsql_frozen`
GCP Cloud SQL PostgreSQL: Data written to temporary	Total data size (in bytes) written to temporary files by the queries.	Dependent item	gcp.cloudsql.pgsql.temp_bytes_written_count Preprocessing JSON Path: `$.pgsql_temp_bytes_written_count`
GCP Cloud SQL PostgreSQL: Temporary files used for writing data	Total number of temporary files used for writing data while performing algorithms such as join and sort.	Dependent item	gcp.cloudsql.pgsql.temp_files_written_count Preprocessing JSON Path: `$.pgsql_temp_files_written_count`
GCP Cloud SQL PostgreSQL: Oldest running transaction age	Age of the oldest running transaction yet to be vacuumed in the Cloud SQL PostgreSQL instance, measured in number of transactions that have happened since the oldest transaction. Empty value when there is no such transaction type.	Dependent item	gcp.cloudsql.pgsql.oldest_transaction.running Preprocessing JSON Path: `$.pgsql_running` ⛔️Custom on fail: Discard value
GCP Cloud SQL PostgreSQL: Oldest prepared transaction age	Age of the oldest prepared transaction yet to be vacuumed in the Cloud SQL PostgreSQL instance, measured in number of transactions that have happened since the oldest transaction. Empty value when there is no such transaction type.	Dependent item	gcp.cloudsql.pgsql.oldest_transaction.prepared Preprocessing JSON Path: `$.pgsql_prepared` ⛔️Custom on fail: Discard value
GCP Cloud SQL PostgreSQL: Oldest replication slot transaction age	Age of the oldest replication slot transaction yet to be vacuumed in the Cloud SQL PostgreSQL instance, measured in number of transactions that have happened since the oldest transaction. Empty value when there is no such transaction type.	Dependent item	gcp.cloudsql.pgsql.oldest_transaction.replication_slot Preprocessing JSON Path: `$.pgsql_replication_slot` ⛔️Custom on fail: Discard value
GCP Cloud SQL PostgreSQL: Oldest replica transaction age	Age of the oldest replica transaction yet to be vacuumed in the Cloud SQL PostgreSQL instance, measured in number of transactions that have happened since the oldest transaction. Empty value when there is no such transaction type.	Dependent item	gcp.cloudsql.pgsql.oldest_transaction.replica Preprocessing JSON Path: `$.pgsql_replica` ⛔️Custom on fail: Discard value
GCP Cloud SQL PostgreSQL: Connections	The number of the connections to the Cloud SQL PostgreSQL instance. Includes connections to the system databases, which aren't visible by default.	Dependent item	gcp.cloudsql.pgsql.num_backends Preprocessing JSON Path: `$.pgsql_num_backends`

Triggers

Name	Description	Expression	Severity	Dependencies and additional info
GCP Cloud SQL PostgreSQL: High CPU utilization	The CPU utilization is too high. The system might be slow to respond.	`min(/GCP Cloud SQL PostgreSQL by HTTP/gcp.cloudsql.pgsql.cpu.utilization,5m) >= {$CLOUD_SQL.PGSQL.CPU.UTIL.MAX}`	Average
GCP Cloud SQL PostgreSQL: Disk space is low	High utilization of the storage space.	`last(/GCP Cloud SQL PostgreSQL by HTTP/gcp.cloudsql.pgsql.disk.utilization) >= {$CLOUD_SQL.PGSQL.DISK.UTIL.WARN}`	Warning	Depends on: GCP Cloud SQL PostgreSQL: Disk space is critically low
GCP Cloud SQL PostgreSQL: Disk space is critically low	Critical utilization of the disk space.	`last(/GCP Cloud SQL PostgreSQL by HTTP/gcp.cloudsql.pgsql.disk.utilization) >= {$CLOUD_SQL.PGSQL.DISK.UTIL.CRIT}`	Average
GCP Cloud SQL PostgreSQL: High memory utilization	RAM utilization is too high. The system might be slow to respond.	`min(/GCP Cloud SQL PostgreSQL by HTTP/gcp.cloudsql.pgsql.memory.utilization,5m) >= {$CLOUD_SQL.PGSQL.RAM.UTIL.MAX}`	High
GCP Cloud SQL PostgreSQL: Instance is in suspended state	The instance is in suspended state. It is not available, for example, due to problems with billing.	`last(/GCP Cloud SQL PostgreSQL by HTTP/gcp.cloudsql.pgsql.inst.state) = 1`	Warning
GCP Cloud SQL PostgreSQL: Instance is stopped by the owner	The instance has been stopped by the owner. It is not currently running, but it's ready to be restarted.	`last(/GCP Cloud SQL PostgreSQL by HTTP/gcp.cloudsql.pgsql.inst.state) = 2`	Info
GCP Cloud SQL PostgreSQL: Instance is in maintenance	The instance is down for maintenance.	`last(/GCP Cloud SQL PostgreSQL by HTTP/gcp.cloudsql.pgsql.inst.state) = 4`	Info
GCP Cloud SQL PostgreSQL: Instance is in failed state	The instance creation failed, or an operation left the instance in an own bad state.	`last(/GCP Cloud SQL PostgreSQL by HTTP/gcp.cloudsql.pgsql.inst.state) = 5`	Average
GCP Cloud SQL PostgreSQL: Instance is in unknown state	The state of the instance is unknown.	`last(/GCP Cloud SQL PostgreSQL by HTTP/gcp.cloudsql.pgsql.inst.state) = 6`	Average
GCP Cloud SQL PostgreSQL: Failed to get the instance state	Failed to get the instance state. Check access permissions to GCP API or service account.	`last(/GCP Cloud SQL PostgreSQL by HTTP/gcp.cloudsql.pgsql.inst.state) = 10`	Average
GCP Cloud SQL PostgreSQL: Database engine is down	Database engine is down. If an instance experiences unplanned (non-maintenance) downtime, the instance state will still be RUNNING, but the database engine state metric will report 0.	`last(/GCP Cloud SQL PostgreSQL by HTTP/gcp.cloudsql.pgsql.db.state)=0`	Average	Depends on: GCP Cloud SQL PostgreSQL: Instance is stopped by the owner GCP Cloud SQL PostgreSQL: Instance is in suspended state GCP Cloud SQL PostgreSQL: Instance is in maintenance GCP Cloud SQL PostgreSQL: Instance is in failed state GCP Cloud SQL PostgreSQL: Instance is in unknown state GCP Cloud SQL PostgreSQL: Failed to get the instance state

LLD rule GCP Cloud SQL PostgreSQL: Databases discovery

Name Description Type Key and additional info

GCP Cloud SQL PostgreSQL: Databases discovery

Name	Description	Type	Key and additional info
GCP Cloud SQL PostgreSQL: Databases discovery	Databases discovery for the particular PostgreSQL instance.	HTTP agent	gcp.cloudsql.pgsql.db.discovery Preprocessing JSON Path: `$.items` Discard unchanged with heartbeat: `3h`

Databases discovery for the particular PostgreSQL instance.

HTTP agent

gcp.cloudsql.pgsql.db.discovery

Preprocessing

JSON Path: $.items
Discard unchanged with heartbeat: 3h

Item prototypes for GCP Cloud SQL PostgreSQL: Databases discovery

Name	Description	Type	Key and additional info
GCP Cloud SQL PostgreSQL: Database [{#PGSQL.DB.NAME}]: Metrics raw	PostgreSQL metrics in raw format.	Script	gcp.cloudsql.pgsql.db.metrics.get[{#PGSQL.DB.NAME}] Preprocessing Check for not supported value ⛔️Custom on fail: Discard value
GCP Cloud SQL PostgreSQL: Database [{#PGSQL.DB.NAME}]: Deadlocks count	Number of deadlocks detected in the [{#PGSQL.DB.NAME}] database.	Dependent item	gcp.cloudsql.pgsql.deadlock_count[{#PGSQL.DB.NAME}] Preprocessing JSON Path: `$.deadlock_count`
GCP Cloud SQL PostgreSQL: Database [{#PGSQL.DB.NAME}]: Tuples returned	Total number of rows scanned while processing the queries of the [{#PGSQL.DB.NAME}] database.	Dependent item	gcp.cloudsql.pgsql.tuples_returned_count[{#PGSQL.DB.NAME}] Preprocessing JSON Path: `$.tuples_returned_count`
GCP Cloud SQL PostgreSQL: Database [{#PGSQL.DB.NAME}]: Tuples fetched	Total number of rows fetched as a result of queries to the [{#PGSQL.DB.NAME}] database.	Dependent item	gcp.cloudsql.pgsql.tuples_fetched_count[{#PGSQL.DB.NAME}] Preprocessing JSON Path: `$.tuples_fetched_count`
GCP Cloud SQL PostgreSQL: Database [{#PGSQL.DB.NAME}]: Committed transactions	Delta count of number of committed transactions to the [{#PGSQL.DB.NAME}] database.	Dependent item	gcp.cloudsql.pgsql.transaction_count_commit[{#PGSQL.DB.NAME}] Preprocessing JSON Path: `$.commit`
GCP Cloud SQL PostgreSQL: Database [{#PGSQL.DB.NAME}]: Rolled-back transactions	Delta count of number of rolled-back transactions in the [{#PGSQL.DB.NAME}] database.	Dependent item	gcp.cloudsql.pgsql.transaction_count_rollback[{#PGSQL.DB.NAME}] Preprocessing JSON Path: `$.rollback`
GCP Cloud SQL PostgreSQL: Database [{#PGSQL.DB.NAME}]: Buffer cache blocks read.	Number of buffer cache blocks read by the [{#PGSQL.DB.NAME}] database.	Dependent item	gcp.cloudsql.pgsql.blocks_read_count_buffer_cache[{#PGSQL.DB.NAME}] Preprocessing JSON Path: `$.buffer_cache`
GCP Cloud SQL PostgreSQL: Database [{#PGSQL.DB.NAME}]: Disk blocks read.	Number of disk blocks read by the [{#PGSQL.DB.NAME}] database.	Dependent item	gcp.cloudsql.pgsql.blocks_read_count_disk[{#PGSQL.DB.NAME}] Preprocessing JSON Path: `$.disk`
GCP Cloud SQL PostgreSQL: Database [{#PGSQL.DB.NAME}]: Inserted rows processed.	Number of tuples(rows) processed for insert operations for the database with the name [{#PGSQL.DB.NAME}].	Dependent item	gcp.cloudsql.pgsql.tuples_processed_count_insert[{#PGSQL.DB.NAME}] Preprocessing JSON Path: `$.insert`
GCP Cloud SQL PostgreSQL: Database [{#PGSQL.DB.NAME}]: Deleted rows processed	Number of tuples(rows) processed for delete operations for the database with the name [{#PGSQL.DB.NAME}].	Dependent item	gcp.cloudsql.pgsql.tuples_processed_count_delete[{#PGSQL.DB.NAME}] Preprocessing JSON Path: `$.delete`
GCP Cloud SQL PostgreSQL: Database [{#PGSQL.DB.NAME}]: Updated rows processed	Number of tuples(rows) processed for update operations for the database with the name [{#PGSQL.DB.NAME}].	Dependent item	gcp.cloudsql.pgsql.tuples_processed_count_update[{#PGSQL.DB.NAME}] Preprocessing JSON Path: `$.update`
GCP Cloud SQL PostgreSQL: Database [{#PGSQL.DB.NAME}]: Live tuples	Number of live tuples(rows) in the [{#PGSQL.DB.NAME}] database.	Dependent item	gcp.cloudsql.pgsql.tuple_size_live[{#PGSQL.DB.NAME}] Preprocessing JSON Path: `$.live`
GCP Cloud SQL PostgreSQL: Database [{#PGSQL.DB.NAME}]: Dead tuples	Number of live tuples(rows) in the [{#PGSQL.DB.NAME}] database.	Dependent item	gcp.cloudsql.pgsql.tuple_size_dead[{#PGSQL.DB.NAME}] Preprocessing JSON Path: `$.dead`

Zabbix version 7.4 7.2 7.0 6.4 6.0

Source: templates/cloud/gcp

GCP Cloud SQL PostgreSQL Replica by HTTP

Overview

This template is designed to monitor Google Cloud Platform Cloud SQL PostgreSQL read-only replica instances by Zabbix.

Requirements

Zabbix version: 7.4 and higher.

Tested versions

This template has been tested on:

GCP Cloud SQL PostgreSQL read replica versions: 14, 13, 12

Configuration

Setup

This template will be automatically connected to discovered entities with all their required parameters pre-defined.

Macros used

Name	Description	Default
{$GCP.DATA.TIMEOUT}	A response timeout for an API.	`15s`
{$GCP.TIME.WINDOW}	Time interval for the data requests. Supported usage type: 1. The default update interval for most of the items. 2. The minimal time window for the data requested in the Monitoring Query Language REST API request.	`5m`
{$GCP.PROXY}	Sets HTTP proxy value. If this macro is empty then no proxy is used.
{$HTTP.TLS.VERIFY}	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 "GCP Cloud SQL PostgreSQL Replica", e.g. {$HTTP.TLS.VERIFY:"GCP Cloud SQL PostgreSQL Replica"}.	`full`

Items

Name	Description	Type	Key and additional info
Replica metrics get	PostgreSQL replica metrics data in raw format.	Script	gcp.cloudsql.pgsql.repl.metrics.get Preprocessing Check for not supported value: `any error` ⛔️Custom on fail: Discard value
Network lag	Indicates time taken from primary binary log to IO thread on replica.	Dependent item	gcp.cloudsql.pgsql.repl.network_lag Preprocessing JSON Path: `$.network_lag`
Replication lag	Number of seconds the read replica is behind its primary (approximation).	Dependent item	gcp.cloudsql.pgsql.repl.replica_lag Preprocessing JSON Path: `$.replica_lag`
Replication state	The current serving state of replication. This metric is only available for the MySQL/PostgreSQL instances.	Dependent item	gcp.cloudsql.pgsql.repl.state Preprocessing JSON Path: `$.state` JavaScript: `The text is too long. Please see the template.`
Replay location lag	Replay location replication lag in bytes.	Dependent item	gcp.cloudsql.pgsql.repl.replay_location Preprocessing JSON Path: `$.replay_location`
Write location lag	Write location replication lag in bytes.	Dependent item	gcp.cloudsql.pgsql.repl.write_location Preprocessing JSON Path: `$.write_location`
Flush location lag	Flush location replication lag in bytes.	Dependent item	gcp.cloudsql.pgsql.repl.flush_location Preprocessing JSON Path: `$.flush_location`
Sent location lag	Sent location replication lag in bytes.	Dependent item	gcp.cloudsql.pgsql.repl.sent_location Preprocessing JSON Path: `$.sent_location`
Number of log archival failures	Number of failed attempts for archiving replication log files.	Dependent item	gcp.cloudsql.pgsql.repl.log_archive_failure_count Preprocessing JSON Path: `$.log_archive_failure_count`
Number of log archival successes	Number of failed attempts for archiving replication log files.	Dependent item	gcp.cloudsql.pgsql.repl.log_archive_success_count Preprocessing JSON Path: `$.log_archive_success_count`

Zabbix version 7.4 7.2 7.0 6.4 6.0

Source: templates/cloud/gcp

GCP Cloud SQL PostgreSQL Replica by HTTP

Overview

This template is designed to monitor Google Cloud Platform Cloud SQL PostgreSQL read-only replica instances by Zabbix.

Requirements

Zabbix version: 7.2 and higher.

Tested versions

This template has been tested on:

GCP Cloud SQL PostgreSQL read replica versions: 14, 13, 12

Configuration

Setup

This template will be automatically connected to discovered entities with all their required parameters pre-defined.

Macros used

Name Description Default

{$GCP.DATA.TIMEOUT}

A response timeout for an API.

15s

{$GCP.TIME.WINDOW}

Time interval for the data requests.

Supported usage type:

1. The default update interval for most of the items.

2. The minimal time window for the data requested in the Monitoring Query Language REST API request.

5m

{$GCP.PROXY}

Sets HTTP proxy value. If this macro is empty then no proxy is used.

Items

Name	Description	Type	Key and additional info
Replica metrics get	PostgreSQL replica metrics data in raw format.	Script	gcp.cloudsql.pgsql.repl.metrics.get Preprocessing Check for not supported value: `any error` ⛔️Custom on fail: Discard value
Network lag	Indicates time taken from primary binary log to IO thread on replica.	Dependent item	gcp.cloudsql.pgsql.repl.network_lag Preprocessing JSON Path: `$.network_lag`
Replication lag	Number of seconds the read replica is behind its primary (approximation).	Dependent item	gcp.cloudsql.pgsql.repl.replica_lag Preprocessing JSON Path: `$.replica_lag`
Replication state	The current serving state of replication. This metric is only available for the MySQL/PostgreSQL instances.	Dependent item	gcp.cloudsql.pgsql.repl.state Preprocessing JSON Path: `$.state` JavaScript: `The text is too long. Please see the template.`
Replay location lag	Replay location replication lag in bytes.	Dependent item	gcp.cloudsql.pgsql.repl.replay_location Preprocessing JSON Path: `$.replay_location`
Write location lag	Write location replication lag in bytes.	Dependent item	gcp.cloudsql.pgsql.repl.write_location Preprocessing JSON Path: `$.write_location`
Flush location lag	Flush location replication lag in bytes.	Dependent item	gcp.cloudsql.pgsql.repl.flush_location Preprocessing JSON Path: `$.flush_location`
Sent location lag	Sent location replication lag in bytes.	Dependent item	gcp.cloudsql.pgsql.repl.sent_location Preprocessing JSON Path: `$.sent_location`
Number of log archival failures	Number of failed attempts for archiving replication log files.	Dependent item	gcp.cloudsql.pgsql.repl.log_archive_failure_count Preprocessing JSON Path: `$.log_archive_failure_count`
Number of log archival successes	Number of failed attempts for archiving replication log files.	Dependent item	gcp.cloudsql.pgsql.repl.log_archive_success_count Preprocessing JSON Path: `$.log_archive_success_count`

Zabbix version 7.4 7.2 7.0 6.4 6.0

Source: templates/cloud/gcp

GCP Cloud SQL PostgreSQL Replica by HTTP

Overview

This template is designed to monitor Google Cloud Platform Cloud SQL PostgreSQL read-only replica instances by Zabbix.

Requirements

Zabbix version: 7.0 and higher.

Tested versions

This template has been tested on:

GCP Cloud SQL PostgreSQL read replica versions: 14, 13, 12

Configuration

Setup

This template will be automatically connected to discovered entities with all their required parameters pre-defined.

Macros used

Name	Description	Default
{$GCP.DATA.TIMEOUT}	A response timeout for an API.	`15s`
{$GCP.TIME.WINDOW}	Time interval for the data requests. Supported usage type: 1. The default update interval for most of the items. 2. The minimal time window for the data requested in the Monitoring Query Language REST API request.	`5m`
{$GCP.PROXY}	Sets HTTP proxy value. If this macro is empty then no proxy is used.
{$HTTP.TLS.VERIFY}	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 "GCP Cloud SQL PostgreSQL Replica", e.g. {$HTTP.TLS.VERIFY:"GCP Cloud SQL PostgreSQL Replica"}.	`full`

Items

Name	Description	Type	Key and additional info
Replica metrics get	PostgreSQL replica metrics data in raw format.	Script	gcp.cloudsql.pgsql.repl.metrics.get Preprocessing Check for not supported value: `any error` ⛔️Custom on fail: Discard value
Network lag	Indicates time taken from primary binary log to IO thread on replica.	Dependent item	gcp.cloudsql.pgsql.repl.network_lag Preprocessing JSON Path: `$.network_lag`
Replication lag	Number of seconds the read replica is behind its primary (approximation).	Dependent item	gcp.cloudsql.pgsql.repl.replica_lag Preprocessing JSON Path: `$.replica_lag`
Replication state	The current serving state of replication. This metric is only available for the MySQL/PostgreSQL instances.	Dependent item	gcp.cloudsql.pgsql.repl.state Preprocessing JSON Path: `$.state` JavaScript: `The text is too long. Please see the template.`
Replay location lag	Replay location replication lag in bytes.	Dependent item	gcp.cloudsql.pgsql.repl.replay_location Preprocessing JSON Path: `$.replay_location`
Write location lag	Write location replication lag in bytes.	Dependent item	gcp.cloudsql.pgsql.repl.write_location Preprocessing JSON Path: `$.write_location`
Flush location lag	Flush location replication lag in bytes.	Dependent item	gcp.cloudsql.pgsql.repl.flush_location Preprocessing JSON Path: `$.flush_location`
Sent location lag	Sent location replication lag in bytes.	Dependent item	gcp.cloudsql.pgsql.repl.sent_location Preprocessing JSON Path: `$.sent_location`
Number of log archival failures	Number of failed attempts for archiving replication log files.	Dependent item	gcp.cloudsql.pgsql.repl.log_archive_failure_count Preprocessing JSON Path: `$.log_archive_failure_count`
Number of log archival successes	Number of failed attempts for archiving replication log files.	Dependent item	gcp.cloudsql.pgsql.repl.log_archive_success_count Preprocessing JSON Path: `$.log_archive_success_count`

Zabbix version 7.4 7.2 7.0 6.4 6.0

Source: templates/cloud/gcp

GCP Cloud SQL PostgreSQL Replica by HTTP

Overview

This template is designed to monitor Google Cloud Platform Cloud SQL PostgreSQL read-only replica instances by Zabbix.

Requirements

Zabbix version: 6.4 and higher.

Tested versions

This template has been tested on:

GCP Cloud SQL PostgreSQL read replica versions: 14, 13, 12

Configuration

Setup

This template will be automatically connected to discovered entities with all their required parameters pre-defined.

Macros used

Name Description Default

{$GCP.DATA.TIMEOUT}

A response timeout for an API.

15s

{$GCP.TIME.WINDOW}

Time interval for the data requests.

Supported usage type:

1. The default update interval for most of the items.

2. The minimal time window for the data requested in the Monitoring Query Language REST API request.

5m

{$GCP.PROXY}

Sets HTTP proxy value. If this macro is empty then no proxy is used.

Items

Name	Description	Type	Key and additional info
GCP Cloud SQL PostgreSQL: Replica metrics get	PostgreSQL replica metrics data in raw format.	Script	gcp.cloudsql.pgsql.repl.metrics.get Preprocessing Check for not supported value ⛔️Custom on fail: Discard value
GCP Cloud SQL PostgreSQL: Network lag	Indicates time taken from primary binary log to IO thread on replica.	Dependent item	gcp.cloudsql.pgsql.repl.network_lag Preprocessing JSON Path: `$.network_lag`
GCP Cloud SQL PostgreSQL: Replication lag	Number of seconds the read replica is behind its primary (approximation).	Dependent item	gcp.cloudsql.pgsql.repl.replica_lag Preprocessing JSON Path: `$.replica_lag`
GCP Cloud SQL PostgreSQL: Replication state	The current serving state of replication. This metric is only available for the MySQL/PostgreSQL instances.	Dependent item	gcp.cloudsql.pgsql.repl.state Preprocessing JSON Path: `$.state` JavaScript: `The text is too long. Please see the template.`
GCP Cloud SQL PostgreSQL: Replay location lag	Replay location replication lag in bytes.	Dependent item	gcp.cloudsql.pgsql.repl.replay_location Preprocessing JSON Path: `$.replay_location`
GCP Cloud SQL PostgreSQL: Write location lag	Write location replication lag in bytes.	Dependent item	gcp.cloudsql.pgsql.repl.write_location Preprocessing JSON Path: `$.write_location`
GCP Cloud SQL PostgreSQL: Flush location lag	Flush location replication lag in bytes.	Dependent item	gcp.cloudsql.pgsql.repl.flush_location Preprocessing JSON Path: `$.flush_location`
GCP Cloud SQL PostgreSQL: Sent location lag	Sent location replication lag in bytes.	Dependent item	gcp.cloudsql.pgsql.repl.sent_location Preprocessing JSON Path: `$.sent_location`
GCP Cloud SQL PostgreSQL: Number of log archival failures	Number of failed attempts for archiving replication log files.	Dependent item	gcp.cloudsql.pgsql.repl.log_archive_failure_count Preprocessing JSON Path: `$.log_archive_failure_count`
GCP Cloud SQL PostgreSQL: Number of log archival successes	Number of failed attempts for archiving replication log files.	Dependent item	gcp.cloudsql.pgsql.repl.log_archive_success_count Preprocessing JSON Path: `$.log_archive_success_count`

Zabbix version 7.4 7.2 7.0 6.4 6.0

Source: templates/cloud/gcp

GCP Cloud SQL PostgreSQL Replica by HTTP

Overview

This template is designed to monitor Google Cloud Platform Cloud SQL PostgreSQL read-only replica instances by Zabbix.

Requirements

Zabbix version: 6.0 and higher.

Tested versions

This template has been tested on:

GCP Cloud SQL PostgreSQL read replica versions: 14, 13, 12

Configuration

Setup

This template will be automatically connected to discovered entities with all their required parameters pre-defined.

Macros used

Name Description Default

{$GCP.DATA.TIMEOUT}

A response timeout for an API.

15s

{$GCP.TIME.WINDOW}

Time interval for the data requests.

Supported usage type:

1. The default update interval for most of the items.

2. The minimal time window for the data requested in the Monitoring Query Language REST API request.

5m

{$GCP.PROXY}

Sets HTTP proxy value. If this macro is empty then no proxy is used.

Items

Name	Description	Type	Key and additional info
GCP Cloud SQL PostgreSQL: Replica metrics get	PostgreSQL replica metrics data in raw format.	Script	gcp.cloudsql.pgsql.repl.metrics.get Preprocessing Check for not supported value ⛔️Custom on fail: Discard value
GCP Cloud SQL PostgreSQL: Network lag	Indicates time taken from primary binary log to IO thread on replica.	Dependent item	gcp.cloudsql.pgsql.repl.network_lag Preprocessing JSON Path: `$.network_lag`
GCP Cloud SQL PostgreSQL: Replication lag	Number of seconds the read replica is behind its primary (approximation).	Dependent item	gcp.cloudsql.pgsql.repl.replica_lag Preprocessing JSON Path: `$.replica_lag`
GCP Cloud SQL PostgreSQL: Replication state	The current serving state of replication. This metric is only available for the MySQL/PostgreSQL instances.	Dependent item	gcp.cloudsql.pgsql.repl.state Preprocessing JSON Path: `$.state` JavaScript: `The text is too long. Please see the template.`
GCP Cloud SQL PostgreSQL: Replay location lag	Replay location replication lag in bytes.	Dependent item	gcp.cloudsql.pgsql.repl.replay_location Preprocessing JSON Path: `$.replay_location`
GCP Cloud SQL PostgreSQL: Write location lag	Write location replication lag in bytes.	Dependent item	gcp.cloudsql.pgsql.repl.write_location Preprocessing JSON Path: `$.write_location`
GCP Cloud SQL PostgreSQL: Flush location lag	Flush location replication lag in bytes.	Dependent item	gcp.cloudsql.pgsql.repl.flush_location Preprocessing JSON Path: `$.flush_location`
GCP Cloud SQL PostgreSQL: Sent location lag	Sent location replication lag in bytes.	Dependent item	gcp.cloudsql.pgsql.repl.sent_location Preprocessing JSON Path: `$.sent_location`
GCP Cloud SQL PostgreSQL: Number of log archival failures	Number of failed attempts for archiving replication log files.	Dependent item	gcp.cloudsql.pgsql.repl.log_archive_failure_count Preprocessing JSON Path: `$.log_archive_failure_count`
GCP Cloud SQL PostgreSQL: Number of log archival successes	Number of failed attempts for archiving replication log files.	Dependent item	gcp.cloudsql.pgsql.repl.log_archive_success_count Preprocessing JSON Path: `$.log_archive_success_count`

Zabbix version 7.4 7.2 7.0 6.4 6.0

Source: templates/cloud/gcp

GCP Cloud SQL MSSQL by HTTP

Overview

This template is designed to monitor Google Cloud Platform Cloud SQL MSSQL instances by Zabbix.

Requirements

Zabbix version: 7.4 and higher.

Tested versions

This template has been tested on:

GCP Cloud SQL MSSQL versions: 2022 Standard/Enterprise, 2019 Standard/Enterprise, 2017 Standard/Enterprise.

Configuration

Setup

This template will be automatically connected to discovered entities with all their required parameters pre-defined.

Macros used

Name	Description	Default
{$GCP.DATA.TIMEOUT}	A response timeout for an API.	`15s`
{$GCP.TIME.WINDOW}	Time interval for the data requests. Supported usage type: 1. The default update interval for most of the items. 2. The minimal time window for the data requested in the Monitoring Query Language REST API request.	`5m`
{$GCP.PROXY}	Sets HTTP proxy value. If this macro is empty then no proxy is used.
{$HTTP.TLS.VERIFY}	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 "GCP Cloud SQL MSSQL", e.g. {$HTTP.TLS.VERIFY:"GCP Cloud SQL MSSQL"}.	`full`
{$CLOUD_SQL.MSSQL.RES.NAME.MATCHES}	The filter to include GCP Cloud SQL MSSQL resources by namespace.	`.*`
{$CLOUD_SQL.MSSQL.RES.NAME.NOT_MATCHES}	The filter to exclude GCP Cloud SQL MSSQL resources by namespace.	`CHANGE_IF_NEEDED`
{$CLOUD_SQL.MSSQL.DB.NAME.MATCHES}	The filter to include GCP Cloud SQL MSSQL databases by namespace.	`.*`
{$CLOUD_SQL.MSSQL.DB.NAME.NOT_MATCHES}	The filter to exclude GCP Cloud SQL MSSQL databases by namespace.	`CHANGE_IF_NEEDED`
{$CLOUD_SQL.MSSQL.SCHEDULER.ID.MATCHES}	The filter to include GCP Cloud SQL MSSQL schedulers by namespace.	`.*`
{$CLOUD_SQL.MSSQL.SCHEDULER.ID.NOT_MATCHES}	The filter to exclude GCP Cloud SQL MSSQL schedulers by namespace.	`CHANGE_IF_NEEDED`
{$CLOUD_SQL.MSSQL.DISK.UTIL.WARN}	GCP Cloud SQL MSSQL instance warning disk usage threshold.	`80`
{$CLOUD_SQL.MSSQL.DISK.UTIL.CRIT}	GCP Cloud SQL MSSQL instance critical disk usage threshold.	`90`
{$CLOUD_SQL.MSSQL.CPU.UTIL.MAX}	GCP Cloud SQL MSSQL instance CPU usage threshold.	`95`
{$CLOUD_SQL.MSSQL.RAM.UTIL.MAX}	GCP Cloud SQL MSSQL instance RAM usage threshold.	`90`

Items

Name	Description	Type	Key and additional info
Metrics get	MSSQL metrics data in raw format.	Script	gcp.cloudsql.mssql.metrics.get Preprocessing Check for not supported value: `any error` ⛔️Custom on fail: Discard value
Reserved CPU cores	Number of cores reserved for the database.	Dependent item	gcp.cloudsql.mssql.cpu.reserved_cores Preprocessing JSON Path: `$.base_reserved_cores`
CPU usage time	Cumulative CPU usage time in seconds.	Dependent item	gcp.cloudsql.mssql.cpu.usage_time Preprocessing JSON Path: `$.base_usage_time`
CPU utilization	Current CPU utilization represented as a percentage of the reserved CPU that is currently in use.	Dependent item	gcp.cloudsql.mssql.cpu.utilization Preprocessing JSON Path: `$.base_utilization` Custom multiplier: `100`
Disk size	Maximum data disk size in bytes.	Dependent item	gcp.cloudsql.mssql.disk.quota Preprocessing JSON Path: `$.mssql_quota`
Disk bytes used	Data utilization in bytes.	Dependent item	gcp.cloudsql.mssql.disk.bytes_used Preprocessing JSON Path: `$.mssql_bytes_used`
Disk read I/O	Delta count of data disk read I/O operations.	Dependent item	gcp.cloudsql.mssql.disk.read_ops_count Preprocessing JSON Path: `$.base_read_ops_count`
Disk write I/O	Delta count of data disk write I/O operations.	Dependent item	gcp.cloudsql.mssql.disk.write_ops_count Preprocessing JSON Path: `$.base_write_ops_count`
Disk utilization	The fraction of the disk quota that is currently in use. Shown as percentage.	Dependent item	gcp.cloudsql.mssql.disk.utilization Preprocessing JSON Path: `$.mssql_utilization` Custom multiplier: `100`
Memory size	Maximum RAM size in bytes.	Dependent item	gcp.cloudsql.mssql.memory.quota Preprocessing JSON Path: `$.base_quota`
Memory used by DB engine	Total RAM usage in bytes. This metric reports the RAM usage of the database process, including the buffer/cache.	Dependent item	gcp.cloudsql.mssql.memory.total_usage Preprocessing JSON Path: `$.base_total_usage`
Memory usage	The RAM usage in bytes. This metric reports the RAM usage of the server, excluding the buffer/cache.	Dependent item	gcp.cloudsql.mssql.memory.usage Preprocessing JSON Path: `$.base_usage`
Memory utilization	The fraction of the memory quota that is currently in use. Shown as percentage.	Dependent item	gcp.cloudsql.mssql.memory.utilization Preprocessing JSON Path: `$.base_ram_pused`
Network: Received bytes	Delta count of bytes received through the network.	Dependent item	gcp.cloudsql.mssql.network.received_bytes_count Preprocessing JSON Path: `$.base_received_bytes_count`
Network: Sent bytes	Delta count of bytes sent through the network.	Dependent item	gcp.cloudsql.mssql.network.sent_bytes_count Preprocessing JSON Path: `$.base_sent_bytes_count`
Connections	Number of connections to the databases on the Cloud SQL instance.	Dependent item	gcp.cloudsql.mssql.network.connections Preprocessing JSON Path: `$.base_connections`
Instance state	GCP Cloud SQL MSSQL Current instance state.	HTTP agent	gcp.cloudsql.mssql.inst.state Preprocessing JSON Path: `$.timeSeriesData[0].pointData[0].values[0].stringValue` ⛔️Custom on fail: Set value to: `10` JavaScript: `The text is too long. Please see the template.` Discard unchanged with heartbeat: `10m`
DB engine state	GCP Cloud SQL MSSQL DB Engine State.	HTTP agent	gcp.cloudsql.mssql.db.state Preprocessing Check for not supported value: `any error` ⛔️Custom on fail: Discard value JSON Path: `$.timeSeriesData[0].pointData[0].values[0].int64Value` ⛔️Custom on fail: Discard value Discard unchanged with heartbeat: `10m`
Connection resets	Total number of login operations started from the connection pool since the last restart of SQL Server service.	Dependent item	gcp.cloudsql.mssql.conn.connection_reset_count Preprocessing JSON Path: `$.mssql_connection_reset_count`
Login attempts	Total number of login attempts since the last restart of SQL Server service. This does not include pooled connections.	Dependent item	gcp.cloudsql.mssql.conn.login_attempt_count Preprocessing JSON Path: `$.mssql_login_attempt_count`
Logouts	Total number of logout operations since the last restart of SQL Server service.	Dependent item	gcp.cloudsql.mssql.conn.logout_count Preprocessing JSON Path: `$.mssql_logout_count`
Processes blocked	Current number of blocked processes.	Dependent item	gcp.cloudsql.mssql.conn.processes_blocked Preprocessing JSON Path: `$.mssql_processes_blocked`
Buffer cache hit ratio	Current percentage of pages found in the buffer cache without having to read from disk. The ratio is the total number of cache hits divided by the total number of cache lookups.	Dependent item	gcp.cloudsql.mssql.memory.buffer_cache_hit_ratio Preprocessing JSON Path: `$.mssql_buffer_cache_hit_ratio`
Checkpoint pages	Total number of pages flushed to disk by a checkpoint or other operation that requires all dirty pages to be flushed.	Dependent item	gcp.cloudsql.mssql.memory.checkpoint_page_count Preprocessing JSON Path: `$.mssql_checkpoint_page_count`
Free list stalls	Total number of requests that had to wait for a free page.	Dependent item	gcp.cloudsql.mssql.memory.free_list_stall_count Preprocessing JSON Path: `$.mssql_free_list_stall_count`
Lazy writes	Total number of buffers written by the buffer manager's lazy writer. The lazy writer is a system process that flushes out batches of dirty, aged buffers (buffers that contain changes that must be written back to disk before the buffer can be reused for a different page) and makes them available to user processes.	Dependent item	gcp.cloudsql.mssql.memory.lazy_write_count Preprocessing JSON Path: `$.mssql_lazy_write_count`
Memory grants pending	Current number of processes waiting for a workspace memory grant.	Dependent item	gcp.cloudsql.mssql.memory.memory_grants_pending Preprocessing JSON Path: `$.mssql_memory_grants_pending`
Page life expectancy	Current number of seconds a page will stay in the buffer pool without references.	Dependent item	gcp.cloudsql.mssql.memory.page_life_expectancy Preprocessing JSON Path: `$.mssql_page_life_expectancy`
Batch requests	Total number of Transact-SQL command batches received.	Dependent item	gcp.cloudsql.mssql.trans.batch_request_count Preprocessing JSON Path: `$.mssql_batch_request_count`
Forwarded records	Total number of records fetched through forwarded record pointers.	Dependent item	gcp.cloudsql.mssql.trans.forwarded_record_count Preprocessing JSON Path: `$.mssql_forwarded_record_count`
Full scans	Total number of unrestricted full scans. These can be either base-table or full-index scans.	Dependent item	gcp.cloudsql.mssql.trans.full_scan_count Preprocessing JSON Path: `$.mssql_full_scan_count`
Page splits	Total number of page splits that occur as the result of overflowing index pages.	Dependent item	gcp.cloudsql.mssql.trans.page_split_count Preprocessing JSON Path: `$.mssql_page_split_count`
Probe scans	Total number of probe scans that are used to find at least one single qualified row in an index or base table directly.	Dependent item	gcp.cloudsql.mssql.trans.probe_scan_count Preprocessing JSON Path: `$.mssql_probe_scan_count`
SQL compilations	Total number of SQL compilations.	Dependent item	gcp.cloudsql.mssql.trans.sql_compilation_count Preprocessing JSON Path: `$.mssql_sql_compilation_count`
SQL recompilations	Total number of SQL recompilations.	Dependent item	gcp.cloudsql.mssql.trans.sql_recompilation_count Preprocessing JSON Path: `$.mssql_sql_recompilation_count`
Read page operations	Total number of physical database page reads. This metric counts physical page reads across all databases.	Dependent item	gcp.cloudsql.mssql.memory.page_ops.read Preprocessing JSON Path: `$.mssql_read`
Write age operations	Total number of physical database page writes. This metric counts physical page writes across all databases.	Dependent item	gcp.cloudsql.mssql.memory.page_ops.write Preprocessing JSON Path: `$.mssql_write`
Audits size	Tracks the size in bytes of stored SQLServer audit files on an instance. Empty value if there are no audits enabled.	Dependent item	gcp.cloudsql.mssql.audits_size Preprocessing JSON Path: `$.base_audits_size` ⛔️Custom on fail: Discard value
Audits successfully uploaded	Tracks the size in bytes of stored SQLServer audit files on an instance. Empty value if there are no audits enabled.	Dependent item	gcp.cloudsql.mssql.audits_upload_count Preprocessing JSON Path: `$.mssql_success` ⛔️Custom on fail: Discard value
Resources get	MSSQL resources data in raw format.	Script	gcp.cloudsql.mssql.resources.get Preprocessing Check for not supported value: `any error` ⛔️Custom on fail: Discard value
Databases get	MSSQL databases data in raw format.	Script	gcp.cloudsql.mssql.db.get Preprocessing Check for not supported value: `any error` ⛔️Custom on fail: Discard value
Schedulers get	MSSQL schedulers data in raw format.	Script	gcp.cloudsql.mssql.schedulers.get Preprocessing Check for not supported value: `any error` ⛔️Custom on fail: Discard value

Triggers

Name	Description	Expression	Severity	Dependencies and additional info
GCP MSSQL: High CPU utilization	The CPU utilization is too high. The system might be slow to respond.	`min(/GCP Cloud SQL MSSQL by HTTP/gcp.cloudsql.mssql.cpu.utilization,5m) >= {$CLOUD_SQL.MSSQL.CPU.UTIL.MAX}`	Average
GCP MSSQL: Disk space is low	High utilization of the storage space.	`last(/GCP Cloud SQL MSSQL by HTTP/gcp.cloudsql.mssql.disk.utilization) >= {$CLOUD_SQL.MSSQL.DISK.UTIL.WARN}`	Warning	Depends on: GCP MSSQL: Disk space is critically low
GCP MSSQL: Disk space is critically low	Critical utilization of the disk space.	`last(/GCP Cloud SQL MSSQL by HTTP/gcp.cloudsql.mssql.disk.utilization) >= {$CLOUD_SQL.MSSQL.DISK.UTIL.CRIT}`	Average
GCP MSSQL: High memory utilization	RAM utilization is too high. The system might be slow to respond.	`min(/GCP Cloud SQL MSSQL by HTTP/gcp.cloudsql.mssql.memory.utilization,5m) >= {$CLOUD_SQL.MSSQL.RAM.UTIL.MAX}`	High
GCP MSSQL: Instance is in suspended state	The instance is in suspended state. It is not available, for example, due to problems with billing.	`last(/GCP Cloud SQL MSSQL by HTTP/gcp.cloudsql.mssql.inst.state) = 1`	Warning
GCP MSSQL: Instance is stopped by the owner	The instance has been stopped by the owner. It is not currently running, but it's ready to be restarted.	`last(/GCP Cloud SQL MSSQL by HTTP/gcp.cloudsql.mssql.inst.state) = 2`	Info
GCP MSSQL: Instance is in maintenance	The instance is down for maintenance.	`last(/GCP Cloud SQL MSSQL by HTTP/gcp.cloudsql.mssql.inst.state) = 4`	Info
GCP MSSQL: Instance is in failed state	The instance creation failed, or an operation left the instance in an own bad state.	`last(/GCP Cloud SQL MSSQL by HTTP/gcp.cloudsql.mssql.inst.state) = 5`	Average
GCP MSSQL: Instance is in unknown state	The state of the instance is unknown.	`last(/GCP Cloud SQL MSSQL by HTTP/gcp.cloudsql.mssql.inst.state) = 6`	Average
GCP MSSQL: Failed to get the instance state	Failed to get the instance state. Check access permissions to GCP API or service account.	`last(/GCP Cloud SQL MSSQL by HTTP/gcp.cloudsql.mssql.inst.state) = 10`	Average
GCP MSSQL: Database engine is down	Database engine is down. If an instance experiences unplanned (non-maintenance) downtime, the instance state will still be RUNNING, but the database engine state metric will report 0.	`last(/GCP Cloud SQL MSSQL by HTTP/gcp.cloudsql.mssql.db.state)=0`	Average	Depends on: GCP MSSQL: Instance is stopped by the owner GCP MSSQL: Instance is in suspended state GCP MSSQL: Instance is in maintenance GCP MSSQL: Instance is in failed state GCP MSSQL: Instance is in unknown state GCP MSSQL: Failed to get the instance state

LLD rule Resources discovery

Name Description Type Key and additional info

Resources discovery

Resources discovery.

Dependent item

gcp.cloudsql.resources.discovery

Preprocessing

Discard unchanged with heartbeat: 3h

Item prototypes for Resources discovery

Name	Description	Type	Key and additional info
Resource [{#RESOURCE.NAME}]: Raw data	Data in raw format for the [{#RESOURCE.NAME}] resource.	Dependent item	gcp.cloudsql.mssql.resource.raw[{#RESOURCE.NAME}] Preprocessing JSON Path: `$[?(@.resource == "{#RESOURCE.NAME}")].metrics.first()`
Resource [{#RESOURCE.NAME}]: Deadlocks	Total number of lock requests that resulted in a deadlock for the [{#RESOURCE.NAME}] resource.	Dependent item	gcp.cloudsql.mssql.resource.deadlock_count[{#RESOURCE.NAME}] Preprocessing JSON Path: `$.deadlock_count`
Resource [{#RESOURCE.NAME}]: Lock waits	Total number of lock requests that required the caller to wait for the [{#RESOURCE.NAME}] resource.	Dependent item	gcp.cloudsql.mssql.resource.lock_wait_count[{#RESOURCE.NAME}] Preprocessing JSON Path: `$.lock_wait_count`
Resource [{#RESOURCE.NAME}]: Lock wait time	Total time lock requests were waiting for locks for the [{#RESOURCE.NAME}] resource.	Dependent item	gcp.cloudsql.mssql.resource.lock_wait_time[{#RESOURCE.NAME}] Preprocessing JSON Path: `$.lock_wait_time`

LLD rule Databases discovery

Name Description Type Key and additional info

Databases discovery

Databases discovery.

Dependent item

gcp.cloudsql.db.discovery

Preprocessing

Discard unchanged with heartbeat: 3h

Item prototypes for Databases discovery

Name Description Type Key and additional info

Database [{#DB.NAME}]: Raw data

Data in raw format for the [{#DB.NAME}] database.

Dependent item

gcp.cloudsql.mssql.db.raw[{#DB.NAME}]

Preprocessing

JSON Path: $[?(@.database == "{#DB.NAME}")].metrics.first()

Database [{#DB.NAME}]: Log bytes flushed

Total number of log bytes flushed for the [{#DB.NAME}] database.

Dependent item

gcp.cloudsql.mssql.db.log_bytes_flushed_count[{#DB.NAME}]

Preprocessing

JSON Path: $.log_bytes_flushed_count

Database [{#DB.NAME}]: Transactions started

Total number of transactions started for the [{#DB.NAME}] database.

Dependent item

gcp.cloudsql.mssql.db.transaction_count[{#DB.NAME}]

Preprocessing

JSON Path: $.transaction_count

LLD rule Schedulers discovery

Name Description Type Key and additional info

Schedulers discovery

Schedulers discovery.

Dependent item

gcp.cloudsql.schedulers.discovery

Preprocessing

Discard unchanged with heartbeat: 3h

Item prototypes for Schedulers discovery

Name	Description	Type	Key and additional info
Scheduler [{#SCHEDULER.ID}]: Raw data	Data in raw format associated with the scheduler that goes by its ID [{#SCHEDULER.ID}].	Dependent item	gcp.cloudsql.mssql.scheduler.raw[{#SCHEDULER.ID}] Preprocessing JSON Path: `$[?(@.scheduler == "{#SCHEDULER.ID}")].metrics.first()`
Scheduler [{#SCHEDULER.ID}]: Active workers	Current number of active workers associated with the scheduler that goes by its ID [{#SCHEDULER.ID}]. An active worker is never preemptive, must have an associated task, and is either running, runnable, or suspended.	Dependent item	gcp.cloudsql.mssql.scheduler.active_workers[{#SCHEDULER.ID}] Preprocessing JSON Path: `$.active_workers`
Scheduler [{#SCHEDULER.ID}]: Current tasks	Current number of present tasks associated with the scheduler that goes by its ID [{#SCHEDULER.ID}]. This count includes tasks that are waiting for a worker to execute them and tasks that are currently waiting or running (in SUSPENDED or RUNNABLE state).	Dependent item	gcp.cloudsql.mssql.scheduler.current_tasks[{#SCHEDULER.ID}] Preprocessing JSON Path: `$.current_tasks`
Scheduler [{#SCHEDULER.ID}]: Current workers	Current number of workers associated with the scheduler that goes by its ID [{#SCHEDULER.ID}]. It includes workers that are not assigned any task.	Dependent item	gcp.cloudsql.mssql.scheduler.current_workers[{#SCHEDULER.ID}] Preprocessing JSON Path: `$.current_workers`
Scheduler [{#SCHEDULER.ID}]: Pending I/O operations	Current number of pending I/Os waiting to be completed that are associated with the scheduler that goes by its ID [{#SCHEDULER.ID}]. Each scheduler has a list of pending I/Os that are checked to determine whether they have been completed every time there is a context switch. The count is incremented when the request is inserted. This count is decremented when the request is completed. This number does not indicate the state of the I/Os.	Dependent item	gcp.cloudsql.mssql.scheduler.pending_disk_io[{#SCHEDULER.ID}] Preprocessing JSON Path: `$.pending_disk_io`
Scheduler [{#SCHEDULER.ID}]: Runnable tasks	Current number of workers that are associated with the scheduler that goes by its ID [{#SCHEDULER.ID}] and have assigned tasks waiting to be scheduled on the runnable queue.	Dependent item	gcp.cloudsql.mssql.scheduler.runnable_tasks[{#SCHEDULER.ID}] Preprocessing JSON Path: `$.runnable_tasks`
Scheduler [{#SCHEDULER.ID}]: Work queue	Current number of tasks in the pending queue associated with the scheduler that goes by its ID [{#SCHEDULER.ID}]. These tasks are waiting for a worker to pick them up.	Dependent item	gcp.cloudsql.mssql.scheduler.work_queue[{#SCHEDULER.ID}] Preprocessing JSON Path: `$.work_queue`

Zabbix version 7.4 7.2 7.0 6.4 6.0

Source: templates/cloud/gcp

GCP Cloud SQL MSSQL by HTTP

Overview

This template is designed to monitor Google Cloud Platform Cloud SQL MSSQL instances by Zabbix.

Requirements

Zabbix version: 7.2 and higher.

Tested versions

This template has been tested on:

GCP Cloud SQL MSSQL versions: 2022 Standard/Enterprise, 2019 Standard/Enterprise, 2017 Standard/Enterprise.

Configuration

Setup

This template will be automatically connected to discovered entities with all their required parameters pre-defined.

Macros used

Name	Description	Default
{$GCP.DATA.TIMEOUT}	A response timeout for an API.	`15s`
{$GCP.TIME.WINDOW}	Time interval for the data requests. Supported usage type: 1. The default update interval for most of the items. 2. The minimal time window for the data requested in the Monitoring Query Language REST API request.	`5m`
{$GCP.PROXY}	Sets HTTP proxy value. If this macro is empty then no proxy is used.
{$CLOUD_SQL.MSSQL.RES.NAME.MATCHES}	The filter to include GCP Cloud SQL MSSQL resources by namespace.	`.*`
{$CLOUD_SQL.MSSQL.RES.NAME.NOT_MATCHES}	The filter to exclude GCP Cloud SQL MSSQL resources by namespace.	`CHANGE_IF_NEEDED`
{$CLOUD_SQL.MSSQL.DB.NAME.MATCHES}	The filter to include GCP Cloud SQL MSSQL databases by namespace.	`.*`
{$CLOUD_SQL.MSSQL.DB.NAME.NOT_MATCHES}	The filter to exclude GCP Cloud SQL MSSQL databases by namespace.	`CHANGE_IF_NEEDED`
{$CLOUD_SQL.MSSQL.SCHEDULER.ID.MATCHES}	The filter to include GCP Cloud SQL MSSQL schedulers by namespace.	`.*`
{$CLOUD_SQL.MSSQL.SCHEDULER.ID.NOT_MATCHES}	The filter to exclude GCP Cloud SQL MSSQL schedulers by namespace.	`CHANGE_IF_NEEDED`
{$CLOUD_SQL.MSSQL.DISK.UTIL.WARN}	GCP Cloud SQL MSSQL instance warning disk usage threshold.	`80`
{$CLOUD_SQL.MSSQL.DISK.UTIL.CRIT}	GCP Cloud SQL MSSQL instance critical disk usage threshold.	`90`
{$CLOUD_SQL.MSSQL.CPU.UTIL.MAX}	GCP Cloud SQL MSSQL instance CPU usage threshold.	`95`
{$CLOUD_SQL.MSSQL.RAM.UTIL.MAX}	GCP Cloud SQL MSSQL instance RAM usage threshold.	`90`

Items

Name	Description	Type	Key and additional info
Metrics get	MSSQL metrics data in raw format.	Script	gcp.cloudsql.mssql.metrics.get Preprocessing Check for not supported value: `any error` ⛔️Custom on fail: Discard value
Reserved CPU cores	Number of cores reserved for the database.	Dependent item	gcp.cloudsql.mssql.cpu.reserved_cores Preprocessing JSON Path: `$.base_reserved_cores`
CPU usage time	Cumulative CPU usage time in seconds.	Dependent item	gcp.cloudsql.mssql.cpu.usage_time Preprocessing JSON Path: `$.base_usage_time`
CPU utilization	Current CPU utilization represented as a percentage of the reserved CPU that is currently in use.	Dependent item	gcp.cloudsql.mssql.cpu.utilization Preprocessing JSON Path: `$.base_utilization` Custom multiplier: `100`
Disk size	Maximum data disk size in bytes.	Dependent item	gcp.cloudsql.mssql.disk.quota Preprocessing JSON Path: `$.mssql_quota`
Disk bytes used	Data utilization in bytes.	Dependent item	gcp.cloudsql.mssql.disk.bytes_used Preprocessing JSON Path: `$.mssql_bytes_used`
Disk read I/O	Delta count of data disk read I/O operations.	Dependent item	gcp.cloudsql.mssql.disk.read_ops_count Preprocessing JSON Path: `$.base_read_ops_count`
Disk write I/O	Delta count of data disk write I/O operations.	Dependent item	gcp.cloudsql.mssql.disk.write_ops_count Preprocessing JSON Path: `$.base_write_ops_count`
Disk utilization	The fraction of the disk quota that is currently in use. Shown as percentage.	Dependent item	gcp.cloudsql.mssql.disk.utilization Preprocessing JSON Path: `$.mssql_utilization` Custom multiplier: `100`
Memory size	Maximum RAM size in bytes.	Dependent item	gcp.cloudsql.mssql.memory.quota Preprocessing JSON Path: `$.base_quota`
Memory used by DB engine	Total RAM usage in bytes. This metric reports the RAM usage of the database process, including the buffer/cache.	Dependent item	gcp.cloudsql.mssql.memory.total_usage Preprocessing JSON Path: `$.base_total_usage`
Memory usage	The RAM usage in bytes. This metric reports the RAM usage of the server, excluding the buffer/cache.	Dependent item	gcp.cloudsql.mssql.memory.usage Preprocessing JSON Path: `$.base_usage`
Memory utilization	The fraction of the memory quota that is currently in use. Shown as percentage.	Dependent item	gcp.cloudsql.mssql.memory.utilization Preprocessing JSON Path: `$.base_ram_pused`
Network: Received bytes	Delta count of bytes received through the network.	Dependent item	gcp.cloudsql.mssql.network.received_bytes_count Preprocessing JSON Path: `$.base_received_bytes_count`
Network: Sent bytes	Delta count of bytes sent through the network.	Dependent item	gcp.cloudsql.mssql.network.sent_bytes_count Preprocessing JSON Path: `$.base_sent_bytes_count`
Connections	Number of connections to the databases on the Cloud SQL instance.	Dependent item	gcp.cloudsql.mssql.network.connections Preprocessing JSON Path: `$.base_connections`
Instance state	GCP Cloud SQL MSSQL Current instance state.	HTTP agent	gcp.cloudsql.mssql.inst.state Preprocessing JSON Path: `$.timeSeriesData[0].pointData[0].values[0].stringValue` ⛔️Custom on fail: Set value to: `10` JavaScript: `The text is too long. Please see the template.` Discard unchanged with heartbeat: `10m`
DB engine state	GCP Cloud SQL MSSQL DB Engine State.	HTTP agent	gcp.cloudsql.mssql.db.state Preprocessing Check for not supported value: `any error` ⛔️Custom on fail: Discard value JSON Path: `$.timeSeriesData[0].pointData[0].values[0].int64Value` ⛔️Custom on fail: Discard value Discard unchanged with heartbeat: `10m`
Connection resets	Total number of login operations started from the connection pool since the last restart of SQL Server service.	Dependent item	gcp.cloudsql.mssql.conn.connection_reset_count Preprocessing JSON Path: `$.mssql_connection_reset_count`
Login attempts	Total number of login attempts since the last restart of SQL Server service. This does not include pooled connections.	Dependent item	gcp.cloudsql.mssql.conn.login_attempt_count Preprocessing JSON Path: `$.mssql_login_attempt_count`
Logouts	Total number of logout operations since the last restart of SQL Server service.	Dependent item	gcp.cloudsql.mssql.conn.logout_count Preprocessing JSON Path: `$.mssql_logout_count`
Processes blocked	Current number of blocked processes.	Dependent item	gcp.cloudsql.mssql.conn.processes_blocked Preprocessing JSON Path: `$.mssql_processes_blocked`
Buffer cache hit ratio	Current percentage of pages found in the buffer cache without having to read from disk. The ratio is the total number of cache hits divided by the total number of cache lookups.	Dependent item	gcp.cloudsql.mssql.memory.buffer_cache_hit_ratio Preprocessing JSON Path: `$.mssql_buffer_cache_hit_ratio`
Checkpoint pages	Total number of pages flushed to disk by a checkpoint or other operation that requires all dirty pages to be flushed.	Dependent item	gcp.cloudsql.mssql.memory.checkpoint_page_count Preprocessing JSON Path: `$.mssql_checkpoint_page_count`
Free list stalls	Total number of requests that had to wait for a free page.	Dependent item	gcp.cloudsql.mssql.memory.free_list_stall_count Preprocessing JSON Path: `$.mssql_free_list_stall_count`
Lazy writes	Total number of buffers written by the buffer manager's lazy writer. The lazy writer is a system process that flushes out batches of dirty, aged buffers (buffers that contain changes that must be written back to disk before the buffer can be reused for a different page) and makes them available to user processes.	Dependent item	gcp.cloudsql.mssql.memory.lazy_write_count Preprocessing JSON Path: `$.mssql_lazy_write_count`
Memory grants pending	Current number of processes waiting for a workspace memory grant.	Dependent item	gcp.cloudsql.mssql.memory.memory_grants_pending Preprocessing JSON Path: `$.mssql_memory_grants_pending`
Page life expectancy	Current number of seconds a page will stay in the buffer pool without references.	Dependent item	gcp.cloudsql.mssql.memory.page_life_expectancy Preprocessing JSON Path: `$.mssql_page_life_expectancy`
Batch requests	Total number of Transact-SQL command batches received.	Dependent item	gcp.cloudsql.mssql.trans.batch_request_count Preprocessing JSON Path: `$.mssql_batch_request_count`
Forwarded records	Total number of records fetched through forwarded record pointers.	Dependent item	gcp.cloudsql.mssql.trans.forwarded_record_count Preprocessing JSON Path: `$.mssql_forwarded_record_count`
Full scans	Total number of unrestricted full scans. These can be either base-table or full-index scans.	Dependent item	gcp.cloudsql.mssql.trans.full_scan_count Preprocessing JSON Path: `$.mssql_full_scan_count`
Page splits	Total number of page splits that occur as the result of overflowing index pages.	Dependent item	gcp.cloudsql.mssql.trans.page_split_count Preprocessing JSON Path: `$.mssql_page_split_count`
Probe scans	Total number of probe scans that are used to find at least one single qualified row in an index or base table directly.	Dependent item	gcp.cloudsql.mssql.trans.probe_scan_count Preprocessing JSON Path: `$.mssql_probe_scan_count`
SQL compilations	Total number of SQL compilations.	Dependent item	gcp.cloudsql.mssql.trans.sql_compilation_count Preprocessing JSON Path: `$.mssql_sql_compilation_count`
SQL recompilations	Total number of SQL recompilations.	Dependent item	gcp.cloudsql.mssql.trans.sql_recompilation_count Preprocessing JSON Path: `$.mssql_sql_recompilation_count`
Read page operations	Total number of physical database page reads. This metric counts physical page reads across all databases.	Dependent item	gcp.cloudsql.mssql.memory.page_ops.read Preprocessing JSON Path: `$.mssql_read`
Write age operations	Total number of physical database page writes. This metric counts physical page writes across all databases.	Dependent item	gcp.cloudsql.mssql.memory.page_ops.write Preprocessing JSON Path: `$.mssql_write`
Audits size	Tracks the size in bytes of stored SQLServer audit files on an instance. Empty value if there are no audits enabled.	Dependent item	gcp.cloudsql.mssql.audits_size Preprocessing JSON Path: `$.base_audits_size` ⛔️Custom on fail: Discard value
Audits successfully uploaded	Tracks the size in bytes of stored SQLServer audit files on an instance. Empty value if there are no audits enabled.	Dependent item	gcp.cloudsql.mssql.audits_upload_count Preprocessing JSON Path: `$.mssql_success` ⛔️Custom on fail: Discard value
Resources get	MSSQL resources data in raw format.	Script	gcp.cloudsql.mssql.resources.get Preprocessing Check for not supported value: `any error` ⛔️Custom on fail: Discard value
Databases get	MSSQL databases data in raw format.	Script	gcp.cloudsql.mssql.db.get Preprocessing Check for not supported value: `any error` ⛔️Custom on fail: Discard value
Schedulers get	MSSQL schedulers data in raw format.	Script	gcp.cloudsql.mssql.schedulers.get Preprocessing Check for not supported value: `any error` ⛔️Custom on fail: Discard value

Triggers

Name	Description	Expression	Severity	Dependencies and additional info
GCP MSSQL: High CPU utilization	The CPU utilization is too high. The system might be slow to respond.	`min(/GCP Cloud SQL MSSQL by HTTP/gcp.cloudsql.mssql.cpu.utilization,5m) >= {$CLOUD_SQL.MSSQL.CPU.UTIL.MAX}`	Average
GCP MSSQL: Disk space is low	High utilization of the storage space.	`last(/GCP Cloud SQL MSSQL by HTTP/gcp.cloudsql.mssql.disk.utilization) >= {$CLOUD_SQL.MSSQL.DISK.UTIL.WARN}`	Warning	Depends on: GCP MSSQL: Disk space is critically low
GCP MSSQL: Disk space is critically low	Critical utilization of the disk space.	`last(/GCP Cloud SQL MSSQL by HTTP/gcp.cloudsql.mssql.disk.utilization) >= {$CLOUD_SQL.MSSQL.DISK.UTIL.CRIT}`	Average
GCP MSSQL: High memory utilization	RAM utilization is too high. The system might be slow to respond.	`min(/GCP Cloud SQL MSSQL by HTTP/gcp.cloudsql.mssql.memory.utilization,5m) >= {$CLOUD_SQL.MSSQL.RAM.UTIL.MAX}`	High
GCP MSSQL: Instance is in suspended state	The instance is in suspended state. It is not available, for example, due to problems with billing.	`last(/GCP Cloud SQL MSSQL by HTTP/gcp.cloudsql.mssql.inst.state) = 1`	Warning
GCP MSSQL: Instance is stopped by the owner	The instance has been stopped by the owner. It is not currently running, but it's ready to be restarted.	`last(/GCP Cloud SQL MSSQL by HTTP/gcp.cloudsql.mssql.inst.state) = 2`	Info
GCP MSSQL: Instance is in maintenance	The instance is down for maintenance.	`last(/GCP Cloud SQL MSSQL by HTTP/gcp.cloudsql.mssql.inst.state) = 4`	Info
GCP MSSQL: Instance is in failed state	The instance creation failed, or an operation left the instance in an own bad state.	`last(/GCP Cloud SQL MSSQL by HTTP/gcp.cloudsql.mssql.inst.state) = 5`	Average
GCP MSSQL: Instance is in unknown state	The state of the instance is unknown.	`last(/GCP Cloud SQL MSSQL by HTTP/gcp.cloudsql.mssql.inst.state) = 6`	Average
GCP MSSQL: Failed to get the instance state	Failed to get the instance state. Check access permissions to GCP API or service account.	`last(/GCP Cloud SQL MSSQL by HTTP/gcp.cloudsql.mssql.inst.state) = 10`	Average
GCP MSSQL: Database engine is down	Database engine is down. If an instance experiences unplanned (non-maintenance) downtime, the instance state will still be RUNNING, but the database engine state metric will report 0.	`last(/GCP Cloud SQL MSSQL by HTTP/gcp.cloudsql.mssql.db.state)=0`	Average	Depends on: GCP MSSQL: Instance is stopped by the owner GCP MSSQL: Instance is in suspended state GCP MSSQL: Instance is in maintenance GCP MSSQL: Instance is in failed state GCP MSSQL: Instance is in unknown state GCP MSSQL: Failed to get the instance state

LLD rule Resources discovery

Name Description Type Key and additional info

Resources discovery

Resources discovery.

Dependent item

gcp.cloudsql.resources.discovery

Preprocessing

Discard unchanged with heartbeat: 3h

Item prototypes for Resources discovery

Name	Description	Type	Key and additional info
Resource [{#RESOURCE.NAME}]: Raw data	Data in raw format for the [{#RESOURCE.NAME}] resource.	Dependent item	gcp.cloudsql.mssql.resource.raw[{#RESOURCE.NAME}] Preprocessing JSON Path: `$[?(@.resource == "{#RESOURCE.NAME}")].metrics.first()`
Resource [{#RESOURCE.NAME}]: Deadlocks	Total number of lock requests that resulted in a deadlock for the [{#RESOURCE.NAME}] resource.	Dependent item	gcp.cloudsql.mssql.resource.deadlock_count[{#RESOURCE.NAME}] Preprocessing JSON Path: `$.deadlock_count`
Resource [{#RESOURCE.NAME}]: Lock waits	Total number of lock requests that required the caller to wait for the [{#RESOURCE.NAME}] resource.	Dependent item	gcp.cloudsql.mssql.resource.lock_wait_count[{#RESOURCE.NAME}] Preprocessing JSON Path: `$.lock_wait_count`
Resource [{#RESOURCE.NAME}]: Lock wait time	Total time lock requests were waiting for locks for the [{#RESOURCE.NAME}] resource.	Dependent item	gcp.cloudsql.mssql.resource.lock_wait_time[{#RESOURCE.NAME}] Preprocessing JSON Path: `$.lock_wait_time`

LLD rule Databases discovery

Name Description Type Key and additional info

Databases discovery

Databases discovery.

Dependent item

gcp.cloudsql.db.discovery

Preprocessing

Discard unchanged with heartbeat: 3h

Item prototypes for Databases discovery

Name Description Type Key and additional info

Database [{#DB.NAME}]: Raw data

Data in raw format for the [{#DB.NAME}] database.

Dependent item

gcp.cloudsql.mssql.db.raw[{#DB.NAME}]

Preprocessing

JSON Path: $[?(@.database == "{#DB.NAME}")].metrics.first()

Database [{#DB.NAME}]: Log bytes flushed

Total number of log bytes flushed for the [{#DB.NAME}] database.

Dependent item

gcp.cloudsql.mssql.db.log_bytes_flushed_count[{#DB.NAME}]

Preprocessing

JSON Path: $.log_bytes_flushed_count

Database [{#DB.NAME}]: Transactions started

Total number of transactions started for the [{#DB.NAME}] database.

Dependent item

gcp.cloudsql.mssql.db.transaction_count[{#DB.NAME}]

Preprocessing

JSON Path: $.transaction_count

LLD rule Schedulers discovery

Name Description Type Key and additional info

Schedulers discovery

Schedulers discovery.

Dependent item

gcp.cloudsql.schedulers.discovery

Preprocessing

Discard unchanged with heartbeat: 3h

Item prototypes for Schedulers discovery

Name	Description	Type	Key and additional info
Scheduler [{#SCHEDULER.ID}]: Raw data	Data in raw format associated with the scheduler that goes by its ID [{#SCHEDULER.ID}].	Dependent item	gcp.cloudsql.mssql.scheduler.raw[{#SCHEDULER.ID}] Preprocessing JSON Path: `$[?(@.scheduler == "{#SCHEDULER.ID}")].metrics.first()`
Scheduler [{#SCHEDULER.ID}]: Active workers	Current number of active workers associated with the scheduler that goes by its ID [{#SCHEDULER.ID}]. An active worker is never preemptive, must have an associated task, and is either running, runnable, or suspended.	Dependent item	gcp.cloudsql.mssql.scheduler.active_workers[{#SCHEDULER.ID}] Preprocessing JSON Path: `$.active_workers`
Scheduler [{#SCHEDULER.ID}]: Current tasks	Current number of present tasks associated with the scheduler that goes by its ID [{#SCHEDULER.ID}]. This count includes tasks that are waiting for a worker to execute them and tasks that are currently waiting or running (in SUSPENDED or RUNNABLE state).	Dependent item	gcp.cloudsql.mssql.scheduler.current_tasks[{#SCHEDULER.ID}] Preprocessing JSON Path: `$.current_tasks`
Scheduler [{#SCHEDULER.ID}]: Current workers	Current number of workers associated with the scheduler that goes by its ID [{#SCHEDULER.ID}]. It includes workers that are not assigned any task.	Dependent item	gcp.cloudsql.mssql.scheduler.current_workers[{#SCHEDULER.ID}] Preprocessing JSON Path: `$.current_workers`
Scheduler [{#SCHEDULER.ID}]: Pending I/O operations	Current number of pending I/Os waiting to be completed that are associated with the scheduler that goes by its ID [{#SCHEDULER.ID}]. Each scheduler has a list of pending I/Os that are checked to determine whether they have been completed every time there is a context switch. The count is incremented when the request is inserted. This count is decremented when the request is completed. This number does not indicate the state of the I/Os.	Dependent item	gcp.cloudsql.mssql.scheduler.pending_disk_io[{#SCHEDULER.ID}] Preprocessing JSON Path: `$.pending_disk_io`
Scheduler [{#SCHEDULER.ID}]: Runnable tasks	Current number of workers that are associated with the scheduler that goes by its ID [{#SCHEDULER.ID}] and have assigned tasks waiting to be scheduled on the runnable queue.	Dependent item	gcp.cloudsql.mssql.scheduler.runnable_tasks[{#SCHEDULER.ID}] Preprocessing JSON Path: `$.runnable_tasks`
Scheduler [{#SCHEDULER.ID}]: Work queue	Current number of tasks in the pending queue associated with the scheduler that goes by its ID [{#SCHEDULER.ID}]. These tasks are waiting for a worker to pick them up.	Dependent item	gcp.cloudsql.mssql.scheduler.work_queue[{#SCHEDULER.ID}] Preprocessing JSON Path: `$.work_queue`

Zabbix version 7.4 7.2 7.0 6.4 6.0

Source: templates/cloud/gcp

GCP Cloud SQL MSSQL by HTTP

Overview

This template is designed to monitor Google Cloud Platform Cloud SQL MSSQL instances by Zabbix.

Requirements

Zabbix version: 7.0 and higher.

Tested versions

This template has been tested on:

GCP Cloud SQL MSSQL versions: 2022 Standard/Enterprise, 2019 Standard/Enterprise, 2017 Standard/Enterprise.

Configuration

Setup

This template will be automatically connected to discovered entities with all their required parameters pre-defined.

Macros used

Name	Description	Default
{$GCP.DATA.TIMEOUT}	A response timeout for an API.	`15s`
{$GCP.TIME.WINDOW}	Time interval for the data requests. Supported usage type: 1. The default update interval for most of the items. 2. The minimal time window for the data requested in the Monitoring Query Language REST API request.	`5m`
{$GCP.PROXY}	Sets HTTP proxy value. If this macro is empty then no proxy is used.
{$HTTP.TLS.VERIFY}	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 "GCP Cloud SQL MSSQL", e.g. {$HTTP.TLS.VERIFY:"GCP Cloud SQL MSSQL"}.	`full`
{$CLOUD_SQL.MSSQL.RES.NAME.MATCHES}	The filter to include GCP Cloud SQL MSSQL resources by namespace.	`.*`
{$CLOUD_SQL.MSSQL.RES.NAME.NOT_MATCHES}	The filter to exclude GCP Cloud SQL MSSQL resources by namespace.	`CHANGE_IF_NEEDED`
{$CLOUD_SQL.MSSQL.DB.NAME.MATCHES}	The filter to include GCP Cloud SQL MSSQL databases by namespace.	`.*`
{$CLOUD_SQL.MSSQL.DB.NAME.NOT_MATCHES}	The filter to exclude GCP Cloud SQL MSSQL databases by namespace.	`CHANGE_IF_NEEDED`
{$CLOUD_SQL.MSSQL.SCHEDULER.ID.MATCHES}	The filter to include GCP Cloud SQL MSSQL schedulers by namespace.	`.*`
{$CLOUD_SQL.MSSQL.SCHEDULER.ID.NOT_MATCHES}	The filter to exclude GCP Cloud SQL MSSQL schedulers by namespace.	`CHANGE_IF_NEEDED`
{$CLOUD_SQL.MSSQL.DISK.UTIL.WARN}	GCP Cloud SQL MSSQL instance warning disk usage threshold.	`80`
{$CLOUD_SQL.MSSQL.DISK.UTIL.CRIT}	GCP Cloud SQL MSSQL instance critical disk usage threshold.	`90`
{$CLOUD_SQL.MSSQL.CPU.UTIL.MAX}	GCP Cloud SQL MSSQL instance CPU usage threshold.	`95`
{$CLOUD_SQL.MSSQL.RAM.UTIL.MAX}	GCP Cloud SQL MSSQL instance RAM usage threshold.	`90`

Items

Name	Description	Type	Key and additional info
Metrics get	MSSQL metrics data in raw format.	Script	gcp.cloudsql.mssql.metrics.get Preprocessing Check for not supported value: `any error` ⛔️Custom on fail: Discard value
Reserved CPU cores	Number of cores reserved for the database.	Dependent item	gcp.cloudsql.mssql.cpu.reserved_cores Preprocessing JSON Path: `$.base_reserved_cores`
CPU usage time	Cumulative CPU usage time in seconds.	Dependent item	gcp.cloudsql.mssql.cpu.usage_time Preprocessing JSON Path: `$.base_usage_time`
CPU utilization	Current CPU utilization represented as a percentage of the reserved CPU that is currently in use.	Dependent item	gcp.cloudsql.mssql.cpu.utilization Preprocessing JSON Path: `$.base_utilization` Custom multiplier: `100`
Disk size	Maximum data disk size in bytes.	Dependent item	gcp.cloudsql.mssql.disk.quota Preprocessing JSON Path: `$.mssql_quota`
Disk bytes used	Data utilization in bytes.	Dependent item	gcp.cloudsql.mssql.disk.bytes_used Preprocessing JSON Path: `$.mssql_bytes_used`
Disk read I/O	Delta count of data disk read I/O operations.	Dependent item	gcp.cloudsql.mssql.disk.read_ops_count Preprocessing JSON Path: `$.base_read_ops_count`
Disk write I/O	Delta count of data disk write I/O operations.	Dependent item	gcp.cloudsql.mssql.disk.write_ops_count Preprocessing JSON Path: `$.base_write_ops_count`
Disk utilization	The fraction of the disk quota that is currently in use. Shown as percentage.	Dependent item	gcp.cloudsql.mssql.disk.utilization Preprocessing JSON Path: `$.mssql_utilization` Custom multiplier: `100`
Memory size	Maximum RAM size in bytes.	Dependent item	gcp.cloudsql.mssql.memory.quota Preprocessing JSON Path: `$.base_quota`
Memory used by DB engine	Total RAM usage in bytes. This metric reports the RAM usage of the database process, including the buffer/cache.	Dependent item	gcp.cloudsql.mssql.memory.total_usage Preprocessing JSON Path: `$.base_total_usage`
Memory usage	The RAM usage in bytes. This metric reports the RAM usage of the server, excluding the buffer/cache.	Dependent item	gcp.cloudsql.mssql.memory.usage Preprocessing JSON Path: `$.base_usage`
Memory utilization	The fraction of the memory quota that is currently in use. Shown as percentage.	Dependent item	gcp.cloudsql.mssql.memory.utilization Preprocessing JSON Path: `$.base_ram_pused`
Network: Received bytes	Delta count of bytes received through the network.	Dependent item	gcp.cloudsql.mssql.network.received_bytes_count Preprocessing JSON Path: `$.base_received_bytes_count`
Network: Sent bytes	Delta count of bytes sent through the network.	Dependent item	gcp.cloudsql.mssql.network.sent_bytes_count Preprocessing JSON Path: `$.base_sent_bytes_count`
Connections	Number of connections to the databases on the Cloud SQL instance.	Dependent item	gcp.cloudsql.mssql.network.connections Preprocessing JSON Path: `$.base_connections`
Instance state	GCP Cloud SQL MSSQL Current instance state.	HTTP agent	gcp.cloudsql.mssql.inst.state Preprocessing JSON Path: `$.timeSeriesData[0].pointData[0].values[0].stringValue` ⛔️Custom on fail: Set value to: `10` JavaScript: `The text is too long. Please see the template.` Discard unchanged with heartbeat: `10m`
DB engine state	GCP Cloud SQL MSSQL DB Engine State.	HTTP agent	gcp.cloudsql.mssql.db.state Preprocessing Check for not supported value: `any error` ⛔️Custom on fail: Discard value JSON Path: `$.timeSeriesData[0].pointData[0].values[0].int64Value` ⛔️Custom on fail: Discard value Discard unchanged with heartbeat: `10m`
Connection resets	Total number of login operations started from the connection pool since the last restart of SQL Server service.	Dependent item	gcp.cloudsql.mssql.conn.connection_reset_count Preprocessing JSON Path: `$.mssql_connection_reset_count`
Login attempts	Total number of login attempts since the last restart of SQL Server service. This does not include pooled connections.	Dependent item	gcp.cloudsql.mssql.conn.login_attempt_count Preprocessing JSON Path: `$.mssql_login_attempt_count`
Logouts	Total number of logout operations since the last restart of SQL Server service.	Dependent item	gcp.cloudsql.mssql.conn.logout_count Preprocessing JSON Path: `$.mssql_logout_count`
Processes blocked	Current number of blocked processes.	Dependent item	gcp.cloudsql.mssql.conn.processes_blocked Preprocessing JSON Path: `$.mssql_processes_blocked`
Buffer cache hit ratio	Current percentage of pages found in the buffer cache without having to read from disk. The ratio is the total number of cache hits divided by the total number of cache lookups.	Dependent item	gcp.cloudsql.mssql.memory.buffer_cache_hit_ratio Preprocessing JSON Path: `$.mssql_buffer_cache_hit_ratio`
Checkpoint pages	Total number of pages flushed to disk by a checkpoint or other operation that requires all dirty pages to be flushed.	Dependent item	gcp.cloudsql.mssql.memory.checkpoint_page_count Preprocessing JSON Path: `$.mssql_checkpoint_page_count`
Free list stalls	Total number of requests that had to wait for a free page.	Dependent item	gcp.cloudsql.mssql.memory.free_list_stall_count Preprocessing JSON Path: `$.mssql_free_list_stall_count`
Lazy writes	Total number of buffers written by the buffer manager's lazy writer. The lazy writer is a system process that flushes out batches of dirty, aged buffers (buffers that contain changes that must be written back to disk before the buffer can be reused for a different page) and makes them available to user processes.	Dependent item	gcp.cloudsql.mssql.memory.lazy_write_count Preprocessing JSON Path: `$.mssql_lazy_write_count`
Memory grants pending	Current number of processes waiting for a workspace memory grant.	Dependent item	gcp.cloudsql.mssql.memory.memory_grants_pending Preprocessing JSON Path: `$.mssql_memory_grants_pending`
Page life expectancy	Current number of seconds a page will stay in the buffer pool without references.	Dependent item	gcp.cloudsql.mssql.memory.page_life_expectancy Preprocessing JSON Path: `$.mssql_page_life_expectancy`
Batch requests	Total number of Transact-SQL command batches received.	Dependent item	gcp.cloudsql.mssql.trans.batch_request_count Preprocessing JSON Path: `$.mssql_batch_request_count`
Forwarded records	Total number of records fetched through forwarded record pointers.	Dependent item	gcp.cloudsql.mssql.trans.forwarded_record_count Preprocessing JSON Path: `$.mssql_forwarded_record_count`
Full scans	Total number of unrestricted full scans. These can be either base-table or full-index scans.	Dependent item	gcp.cloudsql.mssql.trans.full_scan_count Preprocessing JSON Path: `$.mssql_full_scan_count`
Page splits	Total number of page splits that occur as the result of overflowing index pages.	Dependent item	gcp.cloudsql.mssql.trans.page_split_count Preprocessing JSON Path: `$.mssql_page_split_count`
Probe scans	Total number of probe scans that are used to find at least one single qualified row in an index or base table directly.	Dependent item	gcp.cloudsql.mssql.trans.probe_scan_count Preprocessing JSON Path: `$.mssql_probe_scan_count`
SQL compilations	Total number of SQL compilations.	Dependent item	gcp.cloudsql.mssql.trans.sql_compilation_count Preprocessing JSON Path: `$.mssql_sql_compilation_count`
SQL recompilations	Total number of SQL recompilations.	Dependent item	gcp.cloudsql.mssql.trans.sql_recompilation_count Preprocessing JSON Path: `$.mssql_sql_recompilation_count`
Read page operations	Total number of physical database page reads. This metric counts physical page reads across all databases.	Dependent item	gcp.cloudsql.mssql.memory.page_ops.read Preprocessing JSON Path: `$.mssql_read`
Write age operations	Total number of physical database page writes. This metric counts physical page writes across all databases.	Dependent item	gcp.cloudsql.mssql.memory.page_ops.write Preprocessing JSON Path: `$.mssql_write`
Audits size	Tracks the size in bytes of stored SQLServer audit files on an instance. Empty value if there are no audits enabled.	Dependent item	gcp.cloudsql.mssql.audits_size Preprocessing JSON Path: `$.base_audits_size` ⛔️Custom on fail: Discard value
Audits successfully uploaded	Tracks the size in bytes of stored SQLServer audit files on an instance. Empty value if there are no audits enabled.	Dependent item	gcp.cloudsql.mssql.audits_upload_count Preprocessing JSON Path: `$.mssql_success` ⛔️Custom on fail: Discard value
Resources get	MSSQL resources data in raw format.	Script	gcp.cloudsql.mssql.resources.get Preprocessing Check for not supported value: `any error` ⛔️Custom on fail: Discard value
Databases get	MSSQL databases data in raw format.	Script	gcp.cloudsql.mssql.db.get Preprocessing Check for not supported value: `any error` ⛔️Custom on fail: Discard value
Schedulers get	MSSQL schedulers data in raw format.	Script	gcp.cloudsql.mssql.schedulers.get Preprocessing Check for not supported value: `any error` ⛔️Custom on fail: Discard value

Triggers

Name	Description	Expression	Severity	Dependencies and additional info
GCP MSSQL: High CPU utilization	The CPU utilization is too high. The system might be slow to respond.	`min(/GCP Cloud SQL MSSQL by HTTP/gcp.cloudsql.mssql.cpu.utilization,5m) >= {$CLOUD_SQL.MSSQL.CPU.UTIL.MAX}`	Average
GCP MSSQL: Disk space is low	High utilization of the storage space.	`last(/GCP Cloud SQL MSSQL by HTTP/gcp.cloudsql.mssql.disk.utilization) >= {$CLOUD_SQL.MSSQL.DISK.UTIL.WARN}`	Warning	Depends on: GCP MSSQL: Disk space is critically low
GCP MSSQL: Disk space is critically low	Critical utilization of the disk space.	`last(/GCP Cloud SQL MSSQL by HTTP/gcp.cloudsql.mssql.disk.utilization) >= {$CLOUD_SQL.MSSQL.DISK.UTIL.CRIT}`	Average
GCP MSSQL: High memory utilization	RAM utilization is too high. The system might be slow to respond.	`min(/GCP Cloud SQL MSSQL by HTTP/gcp.cloudsql.mssql.memory.utilization,5m) >= {$CLOUD_SQL.MSSQL.RAM.UTIL.MAX}`	High
GCP MSSQL: Instance is in suspended state	The instance is in suspended state. It is not available, for example, due to problems with billing.	`last(/GCP Cloud SQL MSSQL by HTTP/gcp.cloudsql.mssql.inst.state) = 1`	Warning
GCP MSSQL: Instance is stopped by the owner	The instance has been stopped by the owner. It is not currently running, but it's ready to be restarted.	`last(/GCP Cloud SQL MSSQL by HTTP/gcp.cloudsql.mssql.inst.state) = 2`	Info
GCP MSSQL: Instance is in maintenance	The instance is down for maintenance.	`last(/GCP Cloud SQL MSSQL by HTTP/gcp.cloudsql.mssql.inst.state) = 4`	Info
GCP MSSQL: Instance is in failed state	The instance creation failed, or an operation left the instance in an own bad state.	`last(/GCP Cloud SQL MSSQL by HTTP/gcp.cloudsql.mssql.inst.state) = 5`	Average
GCP MSSQL: Instance is in unknown state	The state of the instance is unknown.	`last(/GCP Cloud SQL MSSQL by HTTP/gcp.cloudsql.mssql.inst.state) = 6`	Average
GCP MSSQL: Failed to get the instance state	Failed to get the instance state. Check access permissions to GCP API or service account.	`last(/GCP Cloud SQL MSSQL by HTTP/gcp.cloudsql.mssql.inst.state) = 10`	Average
GCP MSSQL: Database engine is down	Database engine is down. If an instance experiences unplanned (non-maintenance) downtime, the instance state will still be RUNNING, but the database engine state metric will report 0.	`last(/GCP Cloud SQL MSSQL by HTTP/gcp.cloudsql.mssql.db.state)=0`	Average	Depends on: GCP MSSQL: Instance is stopped by the owner GCP MSSQL: Instance is in suspended state GCP MSSQL: Instance is in maintenance GCP MSSQL: Instance is in failed state GCP MSSQL: Instance is in unknown state GCP MSSQL: Failed to get the instance state

LLD rule Resources discovery

Name Description Type Key and additional info

Resources discovery

Resources discovery.

Dependent item

gcp.cloudsql.resources.discovery

Preprocessing

Discard unchanged with heartbeat: 3h

Item prototypes for Resources discovery

Name	Description	Type	Key and additional info
Resource [{#RESOURCE.NAME}]: Raw data	Data in raw format for the [{#RESOURCE.NAME}] resource.	Dependent item	gcp.cloudsql.mssql.resource.raw[{#RESOURCE.NAME}] Preprocessing JSON Path: `$[?(@.resource == "{#RESOURCE.NAME}")].metrics.first()`
Resource [{#RESOURCE.NAME}]: Deadlocks	Total number of lock requests that resulted in a deadlock for the [{#RESOURCE.NAME}] resource.	Dependent item	gcp.cloudsql.mssql.resource.deadlock_count[{#RESOURCE.NAME}] Preprocessing JSON Path: `$.deadlock_count`
Resource [{#RESOURCE.NAME}]: Lock waits	Total number of lock requests that required the caller to wait for the [{#RESOURCE.NAME}] resource.	Dependent item	gcp.cloudsql.mssql.resource.lock_wait_count[{#RESOURCE.NAME}] Preprocessing JSON Path: `$.lock_wait_count`
Resource [{#RESOURCE.NAME}]: Lock wait time	Total time lock requests were waiting for locks for the [{#RESOURCE.NAME}] resource.	Dependent item	gcp.cloudsql.mssql.resource.lock_wait_time[{#RESOURCE.NAME}] Preprocessing JSON Path: `$.lock_wait_time`

LLD rule Databases discovery

Name Description Type Key and additional info

Databases discovery

Databases discovery.

Dependent item

gcp.cloudsql.db.discovery

Preprocessing

Discard unchanged with heartbeat: 3h

Item prototypes for Databases discovery

Name Description Type Key and additional info

Database [{#DB.NAME}]: Raw data

Data in raw format for the [{#DB.NAME}] database.

Dependent item

gcp.cloudsql.mssql.db.raw[{#DB.NAME}]

Preprocessing

JSON Path: $[?(@.database == "{#DB.NAME}")].metrics.first()

Database [{#DB.NAME}]: Log bytes flushed

Total number of log bytes flushed for the [{#DB.NAME}] database.

Dependent item

gcp.cloudsql.mssql.db.log_bytes_flushed_count[{#DB.NAME}]

Preprocessing

JSON Path: $.log_bytes_flushed_count

Database [{#DB.NAME}]: Transactions started

Total number of transactions started for the [{#DB.NAME}] database.

Dependent item

gcp.cloudsql.mssql.db.transaction_count[{#DB.NAME}]

Preprocessing

JSON Path: $.transaction_count

LLD rule Schedulers discovery

Name Description Type Key and additional info

Schedulers discovery

Schedulers discovery.

Dependent item

gcp.cloudsql.schedulers.discovery

Preprocessing

Discard unchanged with heartbeat: 3h

Item prototypes for Schedulers discovery

Name	Description	Type	Key and additional info
Scheduler [{#SCHEDULER.ID}]: Raw data	Data in raw format associated with the scheduler that goes by its ID [{#SCHEDULER.ID}].	Dependent item	gcp.cloudsql.mssql.scheduler.raw[{#SCHEDULER.ID}] Preprocessing JSON Path: `$[?(@.scheduler == "{#SCHEDULER.ID}")].metrics.first()`
Scheduler [{#SCHEDULER.ID}]: Active workers	Current number of active workers associated with the scheduler that goes by its ID [{#SCHEDULER.ID}]. An active worker is never preemptive, must have an associated task, and is either running, runnable, or suspended.	Dependent item	gcp.cloudsql.mssql.scheduler.active_workers[{#SCHEDULER.ID}] Preprocessing JSON Path: `$.active_workers`
Scheduler [{#SCHEDULER.ID}]: Current tasks	Current number of present tasks associated with the scheduler that goes by its ID [{#SCHEDULER.ID}]. This count includes tasks that are waiting for a worker to execute them and tasks that are currently waiting or running (in SUSPENDED or RUNNABLE state).	Dependent item	gcp.cloudsql.mssql.scheduler.current_tasks[{#SCHEDULER.ID}] Preprocessing JSON Path: `$.current_tasks`
Scheduler [{#SCHEDULER.ID}]: Current workers	Current number of workers associated with the scheduler that goes by its ID [{#SCHEDULER.ID}]. It includes workers that are not assigned any task.	Dependent item	gcp.cloudsql.mssql.scheduler.current_workers[{#SCHEDULER.ID}] Preprocessing JSON Path: `$.current_workers`
Scheduler [{#SCHEDULER.ID}]: Pending I/O operations	Current number of pending I/Os waiting to be completed that are associated with the scheduler that goes by its ID [{#SCHEDULER.ID}]. Each scheduler has a list of pending I/Os that are checked to determine whether they have been completed every time there is a context switch. The count is incremented when the request is inserted. This count is decremented when the request is completed. This number does not indicate the state of the I/Os.	Dependent item	gcp.cloudsql.mssql.scheduler.pending_disk_io[{#SCHEDULER.ID}] Preprocessing JSON Path: `$.pending_disk_io`
Scheduler [{#SCHEDULER.ID}]: Runnable tasks	Current number of workers that are associated with the scheduler that goes by its ID [{#SCHEDULER.ID}] and have assigned tasks waiting to be scheduled on the runnable queue.	Dependent item	gcp.cloudsql.mssql.scheduler.runnable_tasks[{#SCHEDULER.ID}] Preprocessing JSON Path: `$.runnable_tasks`
Scheduler [{#SCHEDULER.ID}]: Work queue	Current number of tasks in the pending queue associated with the scheduler that goes by its ID [{#SCHEDULER.ID}]. These tasks are waiting for a worker to pick them up.	Dependent item	gcp.cloudsql.mssql.scheduler.work_queue[{#SCHEDULER.ID}] Preprocessing JSON Path: `$.work_queue`

Zabbix version 7.4 7.2 7.0 6.4 6.0

Source: templates/cloud/gcp

GCP Cloud SQL MSSQL by HTTP

Overview

This template is designed to monitor Google Cloud Platform Cloud SQL MSSQL instances by Zabbix.

Requirements

Zabbix version: 6.4 and higher.

Tested versions

This template has been tested on:

GCP Cloud SQL MSSQL versions: 2022 Standard/Enterprise, 2019 Standard/Enterprise, 2017 Standard/Enterprise.

Configuration

Setup

This template will be automatically connected to discovered entities with all their required parameters pre-defined.

Macros used

Name	Description	Default
{$GCP.DATA.TIMEOUT}	A response timeout for an API.	`15s`
{$GCP.TIME.WINDOW}	Time interval for the data requests. Supported usage type: 1. The default update interval for most of the items. 2. The minimal time window for the data requested in the Monitoring Query Language REST API request.	`5m`
{$GCP.PROXY}	Sets HTTP proxy value. If this macro is empty then no proxy is used.
{$CLOUD_SQL.MSSQL.RES.NAME.MATCHES}	The filter to include GCP Cloud SQL MSSQL resources by namespace.	`.*`
{$CLOUD_SQL.MSSQL.RES.NAME.NOT_MATCHES}	The filter to exclude GCP Cloud SQL MSSQL resources by namespace.	`CHANGE_IF_NEEDED`
{$CLOUD_SQL.MSSQL.DB.NAME.MATCHES}	The filter to include GCP Cloud SQL MSSQL databases by namespace.	`.*`
{$CLOUD_SQL.MSSQL.DB.NAME.NOT_MATCHES}	The filter to exclude GCP Cloud SQL MSSQL databases by namespace.	`CHANGE_IF_NEEDED`
{$CLOUD_SQL.MSSQL.SCHEDULER.ID.MATCHES}	The filter to include GCP Cloud SQL MSSQL schedulers by namespace.	`.*`
{$CLOUD_SQL.MSSQL.SCHEDULER.ID.NOT_MATCHES}	The filter to exclude GCP Cloud SQL MSSQL schedulers by namespace.	`CHANGE_IF_NEEDED`
{$CLOUD_SQL.MSSQL.DISK.UTIL.WARN}	GCP Cloud SQL MSSQL instance warning disk usage threshold.	`80`
{$CLOUD_SQL.MSSQL.DISK.UTIL.CRIT}	GCP Cloud SQL MSSQL instance critical disk usage threshold.	`90`
{$CLOUD_SQL.MSSQL.CPU.UTIL.MAX}	GCP Cloud SQL MSSQL instance CPU usage threshold.	`95`
{$CLOUD_SQL.MSSQL.RAM.UTIL.MAX}	GCP Cloud SQL MSSQL instance RAM usage threshold.	`90`

Items

Name	Description	Type	Key and additional info
GCP Cloud SQL MSSQL: Metrics get	MSSQL metrics data in raw format.	Script	gcp.cloudsql.mssql.metrics.get Preprocessing Check for not supported value ⛔️Custom on fail: Discard value
GCP Cloud SQL MSSQL: Reserved CPU cores	Number of cores reserved for the database.	Dependent item	gcp.cloudsql.mssql.cpu.reserved_cores Preprocessing JSON Path: `$.base_reserved_cores`
GCP Cloud SQL MSSQL: CPU usage time	Cumulative CPU usage time in seconds.	Dependent item	gcp.cloudsql.mssql.cpu.usage_time Preprocessing JSON Path: `$.base_usage_time`
GCP Cloud SQL MSSQL: CPU utilization	Current CPU utilization represented as a percentage of the reserved CPU that is currently in use.	Dependent item	gcp.cloudsql.mssql.cpu.utilization Preprocessing JSON Path: `$.base_utilization` Custom multiplier: `100`
GCP Cloud SQL MSSQL: Disk size	Maximum data disk size in bytes.	Dependent item	gcp.cloudsql.mssql.disk.quota Preprocessing JSON Path: `$.mssql_quota`
GCP Cloud SQL MSSQL: Disk bytes used	Data utilization in bytes.	Dependent item	gcp.cloudsql.mssql.disk.bytes_used Preprocessing JSON Path: `$.mssql_bytes_used`
GCP Cloud SQL MSSQL: Disk read I/O	Delta count of data disk read I/O operations.	Dependent item	gcp.cloudsql.mssql.disk.read_ops_count Preprocessing JSON Path: `$.base_read_ops_count`
GCP Cloud SQL MSSQL: Disk write I/O	Delta count of data disk write I/O operations.	Dependent item	gcp.cloudsql.mssql.disk.write_ops_count Preprocessing JSON Path: `$.base_write_ops_count`
GCP Cloud SQL MSSQL: Disk utilization	The fraction of the disk quota that is currently in use. Shown as percentage.	Dependent item	gcp.cloudsql.mssql.disk.utilization Preprocessing JSON Path: `$.mssql_utilization` Custom multiplier: `100`
GCP Cloud SQL MSSQL: Memory size	Maximum RAM size in bytes.	Dependent item	gcp.cloudsql.mssql.memory.quota Preprocessing JSON Path: `$.base_quota`
GCP Cloud SQL MSSQL: Memory used by DB engine	Total RAM usage in bytes. This metric reports the RAM usage of the database process, including the buffer/cache.	Dependent item	gcp.cloudsql.mssql.memory.total_usage Preprocessing JSON Path: `$.base_total_usage`
GCP Cloud SQL MSSQL: Memory usage	The RAM usage in bytes. This metric reports the RAM usage of the server, excluding the buffer/cache.	Dependent item	gcp.cloudsql.mssql.memory.usage Preprocessing JSON Path: `$.base_usage`
GCP Cloud SQL MSSQL: Memory utilization	The fraction of the memory quota that is currently in use. Shown as percentage.	Dependent item	gcp.cloudsql.mssql.memory.utilization Preprocessing JSON Path: `$.base_ram_pused`
GCP Cloud SQL MSSQL: Network: Received bytes	Delta count of bytes received through the network.	Dependent item	gcp.cloudsql.mssql.network.received_bytes_count Preprocessing JSON Path: `$.base_received_bytes_count`
GCP Cloud SQL MSSQL: Network: Sent bytes	Delta count of bytes sent through the network.	Dependent item	gcp.cloudsql.mssql.network.sent_bytes_count Preprocessing JSON Path: `$.base_sent_bytes_count`
GCP Cloud SQL MSSQL: Connections	Number of connections to the databases on the Cloud SQL instance.	Dependent item	gcp.cloudsql.mssql.network.connections Preprocessing JSON Path: `$.base_connections`
GCP Cloud SQL MSSQL: Instance state	GCP Cloud SQL MSSQL Current instance state.	HTTP agent	gcp.cloudsql.mssql.inst.state Preprocessing JSON Path: `$.timeSeriesData[0].pointData[0].values[0].stringValue` ⛔️Custom on fail: Set value to: `10` JavaScript: `The text is too long. Please see the template.` Discard unchanged with heartbeat: `10m`
GCP Cloud SQL MSSQL: DB engine state	GCP Cloud SQL MSSQL DB Engine State.	HTTP agent	gcp.cloudsql.mssql.db.state Preprocessing Check for not supported value ⛔️Custom on fail: Discard value JSON Path: `$.timeSeriesData[0].pointData[0].values[0].int64Value` ⛔️Custom on fail: Discard value Discard unchanged with heartbeat: `10m`
GCP Cloud SQL MSSQL: Connection resets	Total number of login operations started from the connection pool since the last restart of SQL Server service.	Dependent item	gcp.cloudsql.mssql.conn.connection_reset_count Preprocessing JSON Path: `$.mssql_connection_reset_count`
GCP Cloud SQL MSSQL: Login attempts	Total number of login attempts since the last restart of SQL Server service. This does not include pooled connections.	Dependent item	gcp.cloudsql.mssql.conn.login_attempt_count Preprocessing JSON Path: `$.mssql_login_attempt_count`
GCP Cloud SQL MSSQL: Logouts	Total number of logout operations since the last restart of SQL Server service.	Dependent item	gcp.cloudsql.mssql.conn.logout_count Preprocessing JSON Path: `$.mssql_logout_count`
GCP Cloud SQL MSSQL: Processes blocked	Current number of blocked processes.	Dependent item	gcp.cloudsql.mssql.conn.processes_blocked Preprocessing JSON Path: `$.mssql_processes_blocked`
GCP Cloud SQL MSSQL: Buffer cache hit ratio	Current percentage of pages found in the buffer cache without having to read from disk. The ratio is the total number of cache hits divided by the total number of cache lookups.	Dependent item	gcp.cloudsql.mssql.memory.buffer_cache_hit_ratio Preprocessing JSON Path: `$.mssql_buffer_cache_hit_ratio`
GCP Cloud SQL MSSQL: Checkpoint pages	Total number of pages flushed to disk by a checkpoint or other operation that requires all dirty pages to be flushed.	Dependent item	gcp.cloudsql.mssql.memory.checkpoint_page_count Preprocessing JSON Path: `$.mssql_checkpoint_page_count`
GCP Cloud SQL MSSQL: Free list stalls	Total number of requests that had to wait for a free page.	Dependent item	gcp.cloudsql.mssql.memory.free_list_stall_count Preprocessing JSON Path: `$.mssql_free_list_stall_count`
GCP Cloud SQL MSSQL: Lazy writes	Total number of buffers written by the buffer manager's lazy writer. The lazy writer is a system process that flushes out batches of dirty, aged buffers (buffers that contain changes that must be written back to disk before the buffer can be reused for a different page) and makes them available to user processes.	Dependent item	gcp.cloudsql.mssql.memory.lazy_write_count Preprocessing JSON Path: `$.mssql_lazy_write_count`
GCP Cloud SQL MSSQL: Memory grants pending	Current number of processes waiting for a workspace memory grant.	Dependent item	gcp.cloudsql.mssql.memory.memory_grants_pending Preprocessing JSON Path: `$.mssql_memory_grants_pending`
GCP Cloud SQL MSSQL: Page life expectancy	Current number of seconds a page will stay in the buffer pool without references.	Dependent item	gcp.cloudsql.mssql.memory.page_life_expectancy Preprocessing JSON Path: `$.mssql_page_life_expectancy`
GCP Cloud SQL MSSQL: Batch requests	Total number of Transact-SQL command batches received.	Dependent item	gcp.cloudsql.mssql.trans.batch_request_count Preprocessing JSON Path: `$.mssql_batch_request_count`
GCP Cloud SQL MSSQL: Forwarded records	Total number of records fetched through forwarded record pointers.	Dependent item	gcp.cloudsql.mssql.trans.forwarded_record_count Preprocessing JSON Path: `$.mssql_forwarded_record_count`
GCP Cloud SQL MSSQL: Full scans	Total number of unrestricted full scans. These can be either base-table or full-index scans.	Dependent item	gcp.cloudsql.mssql.trans.full_scan_count Preprocessing JSON Path: `$.mssql_full_scan_count`
GCP Cloud SQL MSSQL: Page splits	Total number of page splits that occur as the result of overflowing index pages.	Dependent item	gcp.cloudsql.mssql.trans.page_split_count Preprocessing JSON Path: `$.mssql_page_split_count`
GCP Cloud SQL MSSQL: Probe scans	Total number of probe scans that are used to find at least one single qualified row in an index or base table directly.	Dependent item	gcp.cloudsql.mssql.trans.probe_scan_count Preprocessing JSON Path: `$.mssql_probe_scan_count`
GCP Cloud SQL MSSQL: SQL compilations	Total number of SQL compilations.	Dependent item	gcp.cloudsql.mssql.trans.sql_compilation_count Preprocessing JSON Path: `$.mssql_sql_compilation_count`
GCP Cloud SQL MSSQL: SQL recompilations	Total number of SQL recompilations.	Dependent item	gcp.cloudsql.mssql.trans.sql_recompilation_count Preprocessing JSON Path: `$.mssql_sql_recompilation_count`
GCP Cloud SQL MSSQL: Read page operations	Total number of physical database page reads. This metric counts physical page reads across all databases.	Dependent item	gcp.cloudsql.mssql.memory.page_ops.read Preprocessing JSON Path: `$.mssql_read`
GCP Cloud SQL MSSQL: Write age operations	Total number of physical database page writes. This metric counts physical page writes across all databases.	Dependent item	gcp.cloudsql.mssql.memory.page_ops.write Preprocessing JSON Path: `$.mssql_write`
GCP Cloud SQL MSSQL: Audits size	Tracks the size in bytes of stored SQLServer audit files on an instance. Empty value if there are no audits enabled.	Dependent item	gcp.cloudsql.mssql.audits_size Preprocessing JSON Path: `$.base_audits_size` ⛔️Custom on fail: Discard value
GCP Cloud SQL MSSQL: Audits successfully uploaded	Tracks the size in bytes of stored SQLServer audit files on an instance. Empty value if there are no audits enabled.	Dependent item	gcp.cloudsql.mssql.audits_upload_count Preprocessing JSON Path: `$.mssql_success` ⛔️Custom on fail: Discard value
GCP Cloud SQL MSSQL: Resources get	MSSQL resources data in raw format.	Script	gcp.cloudsql.mssql.resources.get Preprocessing Check for not supported value ⛔️Custom on fail: Discard value
GCP Cloud SQL MSSQL: Databases get	MSSQL databases data in raw format.	Script	gcp.cloudsql.mssql.db.get Preprocessing Check for not supported value ⛔️Custom on fail: Discard value
GCP Cloud SQL MSSQL: Schedulers get	MSSQL schedulers data in raw format.	Script	gcp.cloudsql.mssql.schedulers.get Preprocessing Check for not supported value ⛔️Custom on fail: Discard value

Triggers

Name	Description	Expression	Severity	Dependencies and additional info
GCP Cloud SQL MSSQL: High CPU utilization	The CPU utilization is too high. The system might be slow to respond.	`min(/GCP Cloud SQL MSSQL by HTTP/gcp.cloudsql.mssql.cpu.utilization,5m) >= {$CLOUD_SQL.MSSQL.CPU.UTIL.MAX}`	Average
GCP Cloud SQL MSSQL: Disk space is low	High utilization of the storage space.	`last(/GCP Cloud SQL MSSQL by HTTP/gcp.cloudsql.mssql.disk.utilization) >= {$CLOUD_SQL.MSSQL.DISK.UTIL.WARN}`	Warning	Depends on: GCP Cloud SQL MSSQL: Disk space is critically low
GCP Cloud SQL MSSQL: Disk space is critically low	Critical utilization of the disk space.	`last(/GCP Cloud SQL MSSQL by HTTP/gcp.cloudsql.mssql.disk.utilization) >= {$CLOUD_SQL.MSSQL.DISK.UTIL.CRIT}`	Average
GCP Cloud SQL MSSQL: High memory utilization	RAM utilization is too high. The system might be slow to respond.	`min(/GCP Cloud SQL MSSQL by HTTP/gcp.cloudsql.mssql.memory.utilization,5m) >= {$CLOUD_SQL.MSSQL.RAM.UTIL.MAX}`	High
GCP Cloud SQL MSSQL: Instance is in suspended state	The instance is in suspended state. It is not available, for example, due to problems with billing.	`last(/GCP Cloud SQL MSSQL by HTTP/gcp.cloudsql.mssql.inst.state) = 1`	Warning
GCP Cloud SQL MSSQL: Instance is stopped by the owner	The instance has been stopped by the owner. It is not currently running, but it's ready to be restarted.	`last(/GCP Cloud SQL MSSQL by HTTP/gcp.cloudsql.mssql.inst.state) = 2`	Info
GCP Cloud SQL MSSQL: Instance is in maintenance	The instance is down for maintenance.	`last(/GCP Cloud SQL MSSQL by HTTP/gcp.cloudsql.mssql.inst.state) = 4`	Info
GCP Cloud SQL MSSQL: Instance is in failed state	The instance creation failed, or an operation left the instance in an own bad state.	`last(/GCP Cloud SQL MSSQL by HTTP/gcp.cloudsql.mssql.inst.state) = 5`	Average
GCP Cloud SQL MSSQL: Instance is in unknown state	The state of the instance is unknown.	`last(/GCP Cloud SQL MSSQL by HTTP/gcp.cloudsql.mssql.inst.state) = 6`	Average
GCP Cloud SQL MSSQL: Failed to get the instance state	Failed to get the instance state. Check access permissions to GCP API or service account.	`last(/GCP Cloud SQL MSSQL by HTTP/gcp.cloudsql.mssql.inst.state) = 10`	Average
GCP Cloud SQL MSSQL: Database engine is down	Database engine is down. If an instance experiences unplanned (non-maintenance) downtime, the instance state will still be RUNNING, but the database engine state metric will report 0.	`last(/GCP Cloud SQL MSSQL by HTTP/gcp.cloudsql.mssql.db.state)=0`	Average	Depends on: GCP Cloud SQL MSSQL: Instance is stopped by the owner GCP Cloud SQL MSSQL: Instance is in suspended state GCP Cloud SQL MSSQL: Instance is in maintenance GCP Cloud SQL MSSQL: Instance is in failed state GCP Cloud SQL MSSQL: Instance is in unknown state GCP Cloud SQL MSSQL: Failed to get the instance state

LLD rule Resources discovery

Name Description Type Key and additional info

Resources discovery

Resources discovery.

Dependent item

gcp.cloudsql.resources.discovery

Preprocessing

Discard unchanged with heartbeat: 3h

Item prototypes for Resources discovery

Name	Description	Type	Key and additional info
GCP Cloud SQL MSSQL: Resource [{#RESOURCE.NAME}]: Raw data	Data in raw format for the [{#RESOURCE.NAME}] resource.	Dependent item	gcp.cloudsql.mssql.resource.raw[{#RESOURCE.NAME}] Preprocessing JSON Path: `$[?(@.resource == "{#RESOURCE.NAME}")].metrics.first()`
GCP Cloud SQL MSSQL: Resource [{#RESOURCE.NAME}]: Deadlocks	Total number of lock requests that resulted in a deadlock for the [{#RESOURCE.NAME}] resource.	Dependent item	gcp.cloudsql.mssql.resource.deadlock_count[{#RESOURCE.NAME}] Preprocessing JSON Path: `$.deadlock_count`
GCP Cloud SQL MSSQL: Resource [{#RESOURCE.NAME}]: Lock waits	Total number of lock requests that required the caller to wait for the [{#RESOURCE.NAME}] resource.	Dependent item	gcp.cloudsql.mssql.resource.lock_wait_count[{#RESOURCE.NAME}] Preprocessing JSON Path: `$.lock_wait_count`
GCP Cloud SQL MSSQL: Resource [{#RESOURCE.NAME}]: Lock wait time	Total time lock requests were waiting for locks for the [{#RESOURCE.NAME}] resource.	Dependent item	gcp.cloudsql.mssql.resource.lock_wait_time[{#RESOURCE.NAME}] Preprocessing JSON Path: `$.lock_wait_time`

LLD rule Databases discovery

Name Description Type Key and additional info

Databases discovery

Databases discovery.

Dependent item

gcp.cloudsql.db.discovery

Preprocessing

Discard unchanged with heartbeat: 3h

Item prototypes for Databases discovery

Name Description Type Key and additional info

GCP Cloud SQL MSSQL: Database [{#DB.NAME}]: Raw data

Data in raw format for the [{#DB.NAME}] database.

Dependent item

gcp.cloudsql.mssql.db.raw[{#DB.NAME}]

Preprocessing

JSON Path: $[?(@.database == "{#DB.NAME}")].metrics.first()

GCP Cloud SQL MSSQL: Database [{#DB.NAME}]: Log bytes flushed

Total number of log bytes flushed for the [{#DB.NAME}] database.

Dependent item

gcp.cloudsql.mssql.db.log_bytes_flushed_count[{#DB.NAME}]

Preprocessing

JSON Path: $.log_bytes_flushed_count

GCP Cloud SQL MSSQL: Database [{#DB.NAME}]: Transactions started

Total number of transactions started for the [{#DB.NAME}] database.

Dependent item

gcp.cloudsql.mssql.db.transaction_count[{#DB.NAME}]

Preprocessing

JSON Path: $.transaction_count

LLD rule Schedulers discovery

Name Description Type Key and additional info

Schedulers discovery

Schedulers discovery.

Dependent item

gcp.cloudsql.schedulers.discovery

Preprocessing

Discard unchanged with heartbeat: 3h

Item prototypes for Schedulers discovery

Name	Description	Type	Key and additional info
GCP Cloud SQL MSSQL: Scheduler [{#SCHEDULER.ID}]: Raw data	Data in raw format associated with the scheduler that goes by its ID [{#SCHEDULER.ID}].	Dependent item	gcp.cloudsql.mssql.scheduler.raw[{#SCHEDULER.ID}] Preprocessing JSON Path: `$[?(@.scheduler == "{#SCHEDULER.ID}")].metrics.first()`
GCP Cloud SQL MSSQL: Scheduler [{#SCHEDULER.ID}]: Active workers	Current number of active workers associated with the scheduler that goes by its ID [{#SCHEDULER.ID}]. An active worker is never preemptive, must have an associated task, and is either running, runnable, or suspended.	Dependent item	gcp.cloudsql.mssql.scheduler.active_workers[{#SCHEDULER.ID}] Preprocessing JSON Path: `$.active_workers`
GCP Cloud SQL MSSQL: Scheduler [{#SCHEDULER.ID}]: Current tasks	Current number of present tasks associated with the scheduler that goes by its ID [{#SCHEDULER.ID}]. This count includes tasks that are waiting for a worker to execute them and tasks that are currently waiting or running (in SUSPENDED or RUNNABLE state).	Dependent item	gcp.cloudsql.mssql.scheduler.current_tasks[{#SCHEDULER.ID}] Preprocessing JSON Path: `$.current_tasks`
GCP Cloud SQL MSSQL: Scheduler [{#SCHEDULER.ID}]: Current workers	Current number of workers associated with the scheduler that goes by its ID [{#SCHEDULER.ID}]. It includes workers that are not assigned any task.	Dependent item	gcp.cloudsql.mssql.scheduler.current_workers[{#SCHEDULER.ID}] Preprocessing JSON Path: `$.current_workers`
GCP Cloud SQL MSSQL: Scheduler [{#SCHEDULER.ID}]: Pending I/O operations	Current number of pending I/Os waiting to be completed that are associated with the scheduler that goes by its ID [{#SCHEDULER.ID}]. Each scheduler has a list of pending I/Os that are checked to determine whether they have been completed every time there is a context switch. The count is incremented when the request is inserted. This count is decremented when the request is completed. This number does not indicate the state of the I/Os.	Dependent item	gcp.cloudsql.mssql.scheduler.pending_disk_io[{#SCHEDULER.ID}] Preprocessing JSON Path: `$.pending_disk_io`
GCP Cloud SQL MSSQL: Scheduler [{#SCHEDULER.ID}]: Runnable tasks	Current number of workers that are associated with the scheduler that goes by its ID [{#SCHEDULER.ID}] and have assigned tasks waiting to be scheduled on the runnable queue.	Dependent item	gcp.cloudsql.mssql.scheduler.runnable_tasks[{#SCHEDULER.ID}] Preprocessing JSON Path: `$.runnable_tasks`
GCP Cloud SQL MSSQL: Scheduler [{#SCHEDULER.ID}]: Work queue	Current number of tasks in the pending queue associated with the scheduler that goes by its ID [{#SCHEDULER.ID}]. These tasks are waiting for a worker to pick them up.	Dependent item	gcp.cloudsql.mssql.scheduler.work_queue[{#SCHEDULER.ID}] Preprocessing JSON Path: `$.work_queue`

Zabbix version 7.4 7.2 7.0 6.4 6.0

Source: templates/cloud/gcp

GCP Cloud SQL MSSQL by HTTP

Overview

This template is designed to monitor Google Cloud Platform Cloud SQL MSSQL instances by Zabbix.

Requirements

Zabbix version: 6.0 and higher.

Tested versions

This template has been tested on:

GCP Cloud SQL MSSQL versions: 2022 Standard/Enterprise, 2019 Standard/Enterprise, 2017 Standard/Enterprise.

Configuration

Setup

This template will be automatically connected to discovered entities with all their required parameters pre-defined.

Macros used

Name	Description	Default
{$GCP.DATA.TIMEOUT}	A response timeout for an API.	`15s`
{$GCP.TIME.WINDOW}	Time interval for the data requests. Supported usage type: 1. The default update interval for most of the items. 2. The minimal time window for the data requested in the Monitoring Query Language REST API request.	`5m`
{$GCP.PROXY}	Sets HTTP proxy value. If this macro is empty then no proxy is used.
{$CLOUD_SQL.MSSQL.RES.NAME.MATCHES}	The filter to include GCP Cloud SQL MSSQL resources by namespace.	`.*`
{$CLOUD_SQL.MSSQL.RES.NAME.NOT_MATCHES}	The filter to exclude GCP Cloud SQL MSSQL resources by namespace.	`CHANGE_IF_NEEDED`
{$CLOUD_SQL.MSSQL.DB.NAME.MATCHES}	The filter to include GCP Cloud SQL MSSQL databases by namespace.	`.*`
{$CLOUD_SQL.MSSQL.DB.NAME.NOT_MATCHES}	The filter to exclude GCP Cloud SQL MSSQL databases by namespace.	`CHANGE_IF_NEEDED`
{$CLOUD_SQL.MSSQL.SCHEDULER.ID.MATCHES}	The filter to include GCP Cloud SQL MSSQL schedulers by namespace.	`.*`
{$CLOUD_SQL.MSSQL.SCHEDULER.ID.NOT_MATCHES}	The filter to exclude GCP Cloud SQL MSSQL schedulers by namespace.	`CHANGE_IF_NEEDED`
{$CLOUD_SQL.MSSQL.DISK.UTIL.WARN}	GCP Cloud SQL MSSQL instance warning disk usage threshold.	`80`
{$CLOUD_SQL.MSSQL.DISK.UTIL.CRIT}	GCP Cloud SQL MSSQL instance critical disk usage threshold.	`90`
{$CLOUD_SQL.MSSQL.CPU.UTIL.MAX}	GCP Cloud SQL MSSQL instance CPU usage threshold.	`95`
{$CLOUD_SQL.MSSQL.RAM.UTIL.MAX}	GCP Cloud SQL MSSQL instance RAM usage threshold.	`90`

Items

Name	Description	Type	Key and additional info
GCP Cloud SQL MSSQL: Metrics get	MSSQL metrics data in raw format.	Script	gcp.cloudsql.mssql.metrics.get Preprocessing Check for not supported value ⛔️Custom on fail: Discard value
GCP Cloud SQL MSSQL: Reserved CPU cores	Number of cores reserved for the database.	Dependent item	gcp.cloudsql.mssql.cpu.reserved_cores Preprocessing JSON Path: `$.base_reserved_cores`
GCP Cloud SQL MSSQL: CPU usage time	Cumulative CPU usage time in seconds.	Dependent item	gcp.cloudsql.mssql.cpu.usage_time Preprocessing JSON Path: `$.base_usage_time`
GCP Cloud SQL MSSQL: CPU utilization	Current CPU utilization represented as a percentage of the reserved CPU that is currently in use.	Dependent item	gcp.cloudsql.mssql.cpu.utilization Preprocessing JSON Path: `$.base_utilization` Custom multiplier: `100`
GCP Cloud SQL MSSQL: Disk size	Maximum data disk size in bytes.	Dependent item	gcp.cloudsql.mssql.disk.quota Preprocessing JSON Path: `$.mssql_quota`
GCP Cloud SQL MSSQL: Disk bytes used	Data utilization in bytes.	Dependent item	gcp.cloudsql.mssql.disk.bytes_used Preprocessing JSON Path: `$.mssql_bytes_used`
GCP Cloud SQL MSSQL: Disk read I/O	Delta count of data disk read I/O operations.	Dependent item	gcp.cloudsql.mssql.disk.read_ops_count Preprocessing JSON Path: `$.base_read_ops_count`
GCP Cloud SQL MSSQL: Disk write I/O	Delta count of data disk write I/O operations.	Dependent item	gcp.cloudsql.mssql.disk.write_ops_count Preprocessing JSON Path: `$.base_write_ops_count`
GCP Cloud SQL MSSQL: Disk utilization	The fraction of the disk quota that is currently in use. Shown as percentage.	Dependent item	gcp.cloudsql.mssql.disk.utilization Preprocessing JSON Path: `$.mssql_utilization` Custom multiplier: `100`
GCP Cloud SQL MSSQL: Memory size	Maximum RAM size in bytes.	Dependent item	gcp.cloudsql.mssql.memory.quota Preprocessing JSON Path: `$.base_quota`
GCP Cloud SQL MSSQL: Memory used by DB engine	Total RAM usage in bytes. This metric reports the RAM usage of the database process, including the buffer/cache.	Dependent item	gcp.cloudsql.mssql.memory.total_usage Preprocessing JSON Path: `$.base_total_usage`
GCP Cloud SQL MSSQL: Memory usage	The RAM usage in bytes. This metric reports the RAM usage of the server, excluding the buffer/cache.	Dependent item	gcp.cloudsql.mssql.memory.usage Preprocessing JSON Path: `$.base_usage`
GCP Cloud SQL MSSQL: Memory utilization	The fraction of the memory quota that is currently in use. Shown as percentage.	Dependent item	gcp.cloudsql.mssql.memory.utilization Preprocessing JSON Path: `$.base_ram_pused`
GCP Cloud SQL MSSQL: Network: Received bytes	Delta count of bytes received through the network.	Dependent item	gcp.cloudsql.mssql.network.received_bytes_count Preprocessing JSON Path: `$.base_received_bytes_count`
GCP Cloud SQL MSSQL: Network: Sent bytes	Delta count of bytes sent through the network.	Dependent item	gcp.cloudsql.mssql.network.sent_bytes_count Preprocessing JSON Path: `$.base_sent_bytes_count`
GCP Cloud SQL MSSQL: Connections	Number of connections to the databases on the Cloud SQL instance.	Dependent item	gcp.cloudsql.mssql.network.connections Preprocessing JSON Path: `$.base_connections`
GCP Cloud SQL MSSQL: Instance state	GCP Cloud SQL MSSQL Current instance state.	HTTP agent	gcp.cloudsql.mssql.inst.state Preprocessing JSON Path: `$.timeSeriesData[0].pointData[0].values[0].stringValue` ⛔️Custom on fail: Set value to: `10` JavaScript: `The text is too long. Please see the template.` Discard unchanged with heartbeat: `10m`
GCP Cloud SQL MSSQL: DB engine state	GCP Cloud SQL MSSQL DB Engine State.	HTTP agent	gcp.cloudsql.mssql.db.state Preprocessing Check for not supported value ⛔️Custom on fail: Discard value JSON Path: `$.timeSeriesData[0].pointData[0].values[0].int64Value` ⛔️Custom on fail: Discard value Discard unchanged with heartbeat: `10m`
GCP Cloud SQL MSSQL: Connection resets	Total number of login operations started from the connection pool since the last restart of SQL Server service.	Dependent item	gcp.cloudsql.mssql.conn.connection_reset_count Preprocessing JSON Path: `$.mssql_connection_reset_count`
GCP Cloud SQL MSSQL: Login attempts	Total number of login attempts since the last restart of SQL Server service. This does not include pooled connections.	Dependent item	gcp.cloudsql.mssql.conn.login_attempt_count Preprocessing JSON Path: `$.mssql_login_attempt_count`
GCP Cloud SQL MSSQL: Logouts	Total number of logout operations since the last restart of SQL Server service.	Dependent item	gcp.cloudsql.mssql.conn.logout_count Preprocessing JSON Path: `$.mssql_logout_count`
GCP Cloud SQL MSSQL: Processes blocked	Current number of blocked processes.	Dependent item	gcp.cloudsql.mssql.conn.processes_blocked Preprocessing JSON Path: `$.mssql_processes_blocked`
GCP Cloud SQL MSSQL: Buffer cache hit ratio	Current percentage of pages found in the buffer cache without having to read from disk. The ratio is the total number of cache hits divided by the total number of cache lookups.	Dependent item	gcp.cloudsql.mssql.memory.buffer_cache_hit_ratio Preprocessing JSON Path: `$.mssql_buffer_cache_hit_ratio`
GCP Cloud SQL MSSQL: Checkpoint pages	Total number of pages flushed to disk by a checkpoint or other operation that requires all dirty pages to be flushed.	Dependent item	gcp.cloudsql.mssql.memory.checkpoint_page_count Preprocessing JSON Path: `$.mssql_checkpoint_page_count`
GCP Cloud SQL MSSQL: Free list stalls	Total number of requests that had to wait for a free page.	Dependent item	gcp.cloudsql.mssql.memory.free_list_stall_count Preprocessing JSON Path: `$.mssql_free_list_stall_count`
GCP Cloud SQL MSSQL: Lazy writes	Total number of buffers written by the buffer manager's lazy writer. The lazy writer is a system process that flushes out batches of dirty, aged buffers (buffers that contain changes that must be written back to disk before the buffer can be reused for a different page) and makes them available to user processes.	Dependent item	gcp.cloudsql.mssql.memory.lazy_write_count Preprocessing JSON Path: `$.mssql_lazy_write_count`
GCP Cloud SQL MSSQL: Memory grants pending	Current number of processes waiting for a workspace memory grant.	Dependent item	gcp.cloudsql.mssql.memory.memory_grants_pending Preprocessing JSON Path: `$.mssql_memory_grants_pending`
GCP Cloud SQL MSSQL: Page life expectancy	Current number of seconds a page will stay in the buffer pool without references.	Dependent item	gcp.cloudsql.mssql.memory.page_life_expectancy Preprocessing JSON Path: `$.mssql_page_life_expectancy`
GCP Cloud SQL MSSQL: Batch requests	Total number of Transact-SQL command batches received.	Dependent item	gcp.cloudsql.mssql.trans.batch_request_count Preprocessing JSON Path: `$.mssql_batch_request_count`
GCP Cloud SQL MSSQL: Forwarded records	Total number of records fetched through forwarded record pointers.	Dependent item	gcp.cloudsql.mssql.trans.forwarded_record_count Preprocessing JSON Path: `$.mssql_forwarded_record_count`
GCP Cloud SQL MSSQL: Full scans	Total number of unrestricted full scans. These can be either base-table or full-index scans.	Dependent item	gcp.cloudsql.mssql.trans.full_scan_count Preprocessing JSON Path: `$.mssql_full_scan_count`
GCP Cloud SQL MSSQL: Page splits	Total number of page splits that occur as the result of overflowing index pages.	Dependent item	gcp.cloudsql.mssql.trans.page_split_count Preprocessing JSON Path: `$.mssql_page_split_count`
GCP Cloud SQL MSSQL: Probe scans	Total number of probe scans that are used to find at least one single qualified row in an index or base table directly.	Dependent item	gcp.cloudsql.mssql.trans.probe_scan_count Preprocessing JSON Path: `$.mssql_probe_scan_count`
GCP Cloud SQL MSSQL: SQL compilations	Total number of SQL compilations.	Dependent item	gcp.cloudsql.mssql.trans.sql_compilation_count Preprocessing JSON Path: `$.mssql_sql_compilation_count`
GCP Cloud SQL MSSQL: SQL recompilations	Total number of SQL recompilations.	Dependent item	gcp.cloudsql.mssql.trans.sql_recompilation_count Preprocessing JSON Path: `$.mssql_sql_recompilation_count`
GCP Cloud SQL MSSQL: Read page operations	Total number of physical database page reads. This metric counts physical page reads across all databases.	Dependent item	gcp.cloudsql.mssql.memory.page_ops.read Preprocessing JSON Path: `$.mssql_read`
GCP Cloud SQL MSSQL: Write age operations	Total number of physical database page writes. This metric counts physical page writes across all databases.	Dependent item	gcp.cloudsql.mssql.memory.page_ops.write Preprocessing JSON Path: `$.mssql_write`
GCP Cloud SQL MSSQL: Audits size	Tracks the size in bytes of stored SQLServer audit files on an instance. Empty value if there are no audits enabled.	Dependent item	gcp.cloudsql.mssql.audits_size Preprocessing JSON Path: `$.base_audits_size` ⛔️Custom on fail: Discard value
GCP Cloud SQL MSSQL: Audits successfully uploaded	Tracks the size in bytes of stored SQLServer audit files on an instance. Empty value if there are no audits enabled.	Dependent item	gcp.cloudsql.mssql.audits_upload_count Preprocessing JSON Path: `$.mssql_success` ⛔️Custom on fail: Discard value
GCP Cloud SQL MSSQL: Resources get	MSSQL resources data in raw format.	Script	gcp.cloudsql.mssql.resources.get Preprocessing Check for not supported value ⛔️Custom on fail: Discard value
GCP Cloud SQL MSSQL: Databases get	MSSQL databases data in raw format.	Script	gcp.cloudsql.mssql.db.get Preprocessing Check for not supported value ⛔️Custom on fail: Discard value
GCP Cloud SQL MSSQL: Schedulers get	MSSQL schedulers data in raw format.	Script	gcp.cloudsql.mssql.schedulers.get Preprocessing Check for not supported value ⛔️Custom on fail: Discard value

Triggers

Name	Description	Expression	Severity	Dependencies and additional info
GCP Cloud SQL MSSQL: High CPU utilization	The CPU utilization is too high. The system might be slow to respond.	`min(/GCP Cloud SQL MSSQL by HTTP/gcp.cloudsql.mssql.cpu.utilization,5m) >= {$CLOUD_SQL.MSSQL.CPU.UTIL.MAX}`	Average
GCP Cloud SQL MSSQL: Disk space is low	High utilization of the storage space.	`last(/GCP Cloud SQL MSSQL by HTTP/gcp.cloudsql.mssql.disk.utilization) >= {$CLOUD_SQL.MSSQL.DISK.UTIL.WARN}`	Warning	Depends on: GCP Cloud SQL MSSQL: Disk space is critically low
GCP Cloud SQL MSSQL: Disk space is critically low	Critical utilization of the disk space.	`last(/GCP Cloud SQL MSSQL by HTTP/gcp.cloudsql.mssql.disk.utilization) >= {$CLOUD_SQL.MSSQL.DISK.UTIL.CRIT}`	Average
GCP Cloud SQL MSSQL: High memory utilization	RAM utilization is too high. The system might be slow to respond.	`min(/GCP Cloud SQL MSSQL by HTTP/gcp.cloudsql.mssql.memory.utilization,5m) >= {$CLOUD_SQL.MSSQL.RAM.UTIL.MAX}`	High
GCP Cloud SQL MSSQL: Instance is in suspended state	The instance is in suspended state. It is not available, for example, due to problems with billing.	`last(/GCP Cloud SQL MSSQL by HTTP/gcp.cloudsql.mssql.inst.state) = 1`	Warning
GCP Cloud SQL MSSQL: Instance is stopped by the owner	The instance has been stopped by the owner. It is not currently running, but it's ready to be restarted.	`last(/GCP Cloud SQL MSSQL by HTTP/gcp.cloudsql.mssql.inst.state) = 2`	Info
GCP Cloud SQL MSSQL: Instance is in maintenance	The instance is down for maintenance.	`last(/GCP Cloud SQL MSSQL by HTTP/gcp.cloudsql.mssql.inst.state) = 4`	Info
GCP Cloud SQL MSSQL: Instance is in failed state	The instance creation failed, or an operation left the instance in an own bad state.	`last(/GCP Cloud SQL MSSQL by HTTP/gcp.cloudsql.mssql.inst.state) = 5`	Average
GCP Cloud SQL MSSQL: Instance is in unknown state	The state of the instance is unknown.	`last(/GCP Cloud SQL MSSQL by HTTP/gcp.cloudsql.mssql.inst.state) = 6`	Average
GCP Cloud SQL MSSQL: Failed to get the instance state	Failed to get the instance state. Check access permissions to GCP API or service account.	`last(/GCP Cloud SQL MSSQL by HTTP/gcp.cloudsql.mssql.inst.state) = 10`	Average
GCP Cloud SQL MSSQL: Database engine is down	Database engine is down. If an instance experiences unplanned (non-maintenance) downtime, the instance state will still be RUNNING, but the database engine state metric will report 0.	`last(/GCP Cloud SQL MSSQL by HTTP/gcp.cloudsql.mssql.db.state)=0`	Average	Depends on: GCP Cloud SQL MSSQL: Instance is stopped by the owner GCP Cloud SQL MSSQL: Instance is in suspended state GCP Cloud SQL MSSQL: Instance is in maintenance GCP Cloud SQL MSSQL: Instance is in failed state GCP Cloud SQL MSSQL: Instance is in unknown state GCP Cloud SQL MSSQL: Failed to get the instance state

LLD rule Resources discovery

Name Description Type Key and additional info

Resources discovery

Resources discovery.

Dependent item

gcp.cloudsql.resources.discovery

Preprocessing

Discard unchanged with heartbeat: 3h

Item prototypes for Resources discovery

Name	Description	Type	Key and additional info
GCP Cloud SQL MSSQL: Resource [{#RESOURCE.NAME}]: Raw data	Data in raw format for the [{#RESOURCE.NAME}] resource.	Dependent item	gcp.cloudsql.mssql.resource.raw[{#RESOURCE.NAME}] Preprocessing JSON Path: `$[?(@.resource == "{#RESOURCE.NAME}")].metrics.first()`
GCP Cloud SQL MSSQL: Resource [{#RESOURCE.NAME}]: Deadlocks	Total number of lock requests that resulted in a deadlock for the [{#RESOURCE.NAME}] resource.	Dependent item	gcp.cloudsql.mssql.resource.deadlock_count[{#RESOURCE.NAME}] Preprocessing JSON Path: `$.deadlock_count`
GCP Cloud SQL MSSQL: Resource [{#RESOURCE.NAME}]: Lock waits	Total number of lock requests that required the caller to wait for the [{#RESOURCE.NAME}] resource.	Dependent item	gcp.cloudsql.mssql.resource.lock_wait_count[{#RESOURCE.NAME}] Preprocessing JSON Path: `$.lock_wait_count`
GCP Cloud SQL MSSQL: Resource [{#RESOURCE.NAME}]: Lock wait time	Total time lock requests were waiting for locks for the [{#RESOURCE.NAME}] resource.	Dependent item	gcp.cloudsql.mssql.resource.lock_wait_time[{#RESOURCE.NAME}] Preprocessing JSON Path: `$.lock_wait_time`

LLD rule Databases discovery

Name Description Type Key and additional info

Databases discovery

Databases discovery.

Dependent item

gcp.cloudsql.db.discovery

Preprocessing

Discard unchanged with heartbeat: 3h

Item prototypes for Databases discovery

Name Description Type Key and additional info

GCP Cloud SQL MSSQL: Database [{#DB.NAME}]: Raw data

Data in raw format for the [{#DB.NAME}] database.

Dependent item

gcp.cloudsql.mssql.db.raw[{#DB.NAME}]

Preprocessing

JSON Path: $[?(@.database == "{#DB.NAME}")].metrics.first()

GCP Cloud SQL MSSQL: Database [{#DB.NAME}]: Log bytes flushed

Total number of log bytes flushed for the [{#DB.NAME}] database.

Dependent item

gcp.cloudsql.mssql.db.log_bytes_flushed_count[{#DB.NAME}]

Preprocessing

JSON Path: $.log_bytes_flushed_count

GCP Cloud SQL MSSQL: Database [{#DB.NAME}]: Transactions started

Total number of transactions started for the [{#DB.NAME}] database.

Dependent item

gcp.cloudsql.mssql.db.transaction_count[{#DB.NAME}]

Preprocessing

JSON Path: $.transaction_count

LLD rule Schedulers discovery

Name Description Type Key and additional info

Schedulers discovery

Schedulers discovery.

Dependent item

gcp.cloudsql.schedulers.discovery

Preprocessing

Discard unchanged with heartbeat: 3h

Item prototypes for Schedulers discovery

Name	Description	Type	Key and additional info
GCP Cloud SQL MSSQL: Scheduler [{#SCHEDULER.ID}]: Raw data	Data in raw format associated with the scheduler that goes by its ID [{#SCHEDULER.ID}].	Dependent item	gcp.cloudsql.mssql.scheduler.raw[{#SCHEDULER.ID}] Preprocessing JSON Path: `$[?(@.scheduler == "{#SCHEDULER.ID}")].metrics.first()`
GCP Cloud SQL MSSQL: Scheduler [{#SCHEDULER.ID}]: Active workers	Current number of active workers associated with the scheduler that goes by its ID [{#SCHEDULER.ID}]. An active worker is never preemptive, must have an associated task, and is either running, runnable, or suspended.	Dependent item	gcp.cloudsql.mssql.scheduler.active_workers[{#SCHEDULER.ID}] Preprocessing JSON Path: `$.active_workers`
GCP Cloud SQL MSSQL: Scheduler [{#SCHEDULER.ID}]: Current tasks	Current number of present tasks associated with the scheduler that goes by its ID [{#SCHEDULER.ID}]. This count includes tasks that are waiting for a worker to execute them and tasks that are currently waiting or running (in SUSPENDED or RUNNABLE state).	Dependent item	gcp.cloudsql.mssql.scheduler.current_tasks[{#SCHEDULER.ID}] Preprocessing JSON Path: `$.current_tasks`
GCP Cloud SQL MSSQL: Scheduler [{#SCHEDULER.ID}]: Current workers	Current number of workers associated with the scheduler that goes by its ID [{#SCHEDULER.ID}]. It includes workers that are not assigned any task.	Dependent item	gcp.cloudsql.mssql.scheduler.current_workers[{#SCHEDULER.ID}] Preprocessing JSON Path: `$.current_workers`
GCP Cloud SQL MSSQL: Scheduler [{#SCHEDULER.ID}]: Pending I/O operations	Current number of pending I/Os waiting to be completed that are associated with the scheduler that goes by its ID [{#SCHEDULER.ID}]. Each scheduler has a list of pending I/Os that are checked to determine whether they have been completed every time there is a context switch. The count is incremented when the request is inserted. This count is decremented when the request is completed. This number does not indicate the state of the I/Os.	Dependent item	gcp.cloudsql.mssql.scheduler.pending_disk_io[{#SCHEDULER.ID}] Preprocessing JSON Path: `$.pending_disk_io`
GCP Cloud SQL MSSQL: Scheduler [{#SCHEDULER.ID}]: Runnable tasks	Current number of workers that are associated with the scheduler that goes by its ID [{#SCHEDULER.ID}] and have assigned tasks waiting to be scheduled on the runnable queue.	Dependent item	gcp.cloudsql.mssql.scheduler.runnable_tasks[{#SCHEDULER.ID}] Preprocessing JSON Path: `$.runnable_tasks`
GCP Cloud SQL MSSQL: Scheduler [{#SCHEDULER.ID}]: Work queue	Current number of tasks in the pending queue associated with the scheduler that goes by its ID [{#SCHEDULER.ID}]. These tasks are waiting for a worker to pick them up.	Dependent item	gcp.cloudsql.mssql.scheduler.work_queue[{#SCHEDULER.ID}] Preprocessing JSON Path: `$.work_queue`

Zabbix version 7.4 7.2 7.0 6.4 6.0

Source: templates/cloud/gcp

GCP Cloud SQL MSSQL Replica by HTTP

Overview

This template is designed to monitor Google Cloud Platform Cloud SQL MSSQL read-only replica instances by Zabbix.

Requirements

Zabbix version: 7.4 and higher.

Tested versions

This template has been tested on:

GCP Cloud SQL MSSQL read replicas versions: 2019 Standard/Enterprise, 2017 Standard/Enterprise

Configuration

Setup

This template will be automatically connected to discovered entities with all their required parameters pre-defined.

Macros used

Name	Description	Default
{$GCP.DATA.TIMEOUT}	A response timeout for an API.	`15s`
{$GCP.TIME.WINDOW}	Time interval for the data requests. Supported usage type: 1. The default update interval for most of the items. 2. The minimal time window for the data requested in the Monitoring Query Language REST API request.	`5m`
{$GCP.PROXY}	Sets HTTP proxy value. If this macro is empty then no proxy is used.
{$HTTP.TLS.VERIFY}	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 "GCP Cloud SQL MSSQL Replica", e.g. {$HTTP.TLS.VERIFY:"GCP Cloud SQL MSSQL Replica"}.	`full`

Items

Name	Description	Type	Key and additional info
Replica metrics get	MSSQL replica metrics data in raw format.	Script	gcp.cloudsql.mssql.repl.metrics.get Preprocessing Check for not supported value: `any error` ⛔️Custom on fail: Discard value
Bytes sent to replica	Total number of bytes sent to the remote availability replica. For an async replica, returns the number of bytes before compression. For a sync replica without compression, returns the actual number of bytes.	Dependent item	gcp.cloudsql.mssql.repl.bytes_sent_to_replica_count Preprocessing JSON Path: `$.bytes_sent_to_replica_count`
Resent messages	Total count of Always On messages to resend. This includes messages that were attempted to be sent but failed and require resending.	Dependent item	gcp.cloudsql.mssql.repl.resent_message_count Preprocessing JSON Path: `$.resent_message_count`
Log apply pending queue	Current number of log blocks that are waiting to be applied to replica.	Dependent item	gcp.cloudsql.mssql.repl.log_apply_pending_queue Preprocessing JSON Path: `$.log_apply_pending_queue`
Log bytes received	Total size of log records received by the replica.	Dependent item	gcp.cloudsql.mssql.repl.log_bytes_received_count Preprocessing JSON Path: `$.log_bytes_received_count`
Recovery queue	Current size of log records in bytes in the replica's log files that have not been redone.	Dependent item	gcp.cloudsql.mssql.repl.recovery_queue Preprocessing JSON Path: `$.recovery_queue` Custom multiplier: `1024`
Redone bytes	Total size in bytes of redone log records.	Dependent item	gcp.cloudsql.mssql.repl.redone_bytes_count Preprocessing JSON Path: `$.redone_bytes_count`

Feedback

Please report any issues with the template at https://support.zabbix.com

You can also provide feedback, discuss the template, or ask for help at ZABBIX forums

Zabbix version 7.4 7.2 7.0 6.4 6.0

Source: templates/cloud/gcp

GCP Cloud SQL MSSQL Replica by HTTP

Overview

This template is designed to monitor Google Cloud Platform Cloud SQL MSSQL read-only replica instances by Zabbix.

Requirements

Zabbix version: 7.2 and higher.

Tested versions

This template has been tested on:

GCP Cloud SQL MSSQL read replicas versions: 2019 Standard/Enterprise, 2017 Standard/Enterprise

Configuration

Setup

This template will be automatically connected to discovered entities with all their required parameters pre-defined.

Macros used

Name Description Default

{$GCP.DATA.TIMEOUT}

A response timeout for an API.

15s

{$GCP.TIME.WINDOW}

Time interval for the data requests.

Supported usage type:

1. The default update interval for most of the items.

2. The minimal time window for the data requested in the Monitoring Query Language REST API request.

5m

{$GCP.PROXY}

Sets HTTP proxy value. If this macro is empty then no proxy is used.

Items

Name	Description	Type	Key and additional info
Replica metrics get	MSSQL replica metrics data in raw format.	Script	gcp.cloudsql.mssql.repl.metrics.get Preprocessing Check for not supported value: `any error` ⛔️Custom on fail: Discard value
Bytes sent to replica	Total number of bytes sent to the remote availability replica. For an async replica, returns the number of bytes before compression. For a sync replica without compression, returns the actual number of bytes.	Dependent item	gcp.cloudsql.mssql.repl.bytes_sent_to_replica_count Preprocessing JSON Path: `$.bytes_sent_to_replica_count`
Resent messages	Total count of Always On messages to resend. This includes messages that were attempted to be sent but failed and require resending.	Dependent item	gcp.cloudsql.mssql.repl.resent_message_count Preprocessing JSON Path: `$.resent_message_count`
Log apply pending queue	Current number of log blocks that are waiting to be applied to replica.	Dependent item	gcp.cloudsql.mssql.repl.log_apply_pending_queue Preprocessing JSON Path: `$.log_apply_pending_queue`
Log bytes received	Total size of log records received by the replica.	Dependent item	gcp.cloudsql.mssql.repl.log_bytes_received_count Preprocessing JSON Path: `$.log_bytes_received_count`
Recovery queue	Current size of log records in bytes in the replica's log files that have not been redone.	Dependent item	gcp.cloudsql.mssql.repl.recovery_queue Preprocessing JSON Path: `$.recovery_queue` Custom multiplier: `1024`
Redone bytes	Total size in bytes of redone log records.	Dependent item	gcp.cloudsql.mssql.repl.redone_bytes_count Preprocessing JSON Path: `$.redone_bytes_count`

Feedback

Please report any issues with the template at https://support.zabbix.com

You can also provide feedback, discuss the template, or ask for help at ZABBIX forums

Zabbix version 7.4 7.2 7.0 6.4 6.0

Source: templates/cloud/gcp

GCP Cloud SQL MSSQL Replica by HTTP

Overview

This template is designed to monitor Google Cloud Platform Cloud SQL MSSQL read-only replica instances by Zabbix.

Requirements

Zabbix version: 7.0 and higher.

Tested versions

This template has been tested on:

GCP Cloud SQL MSSQL read replicas versions: 2019 Standard/Enterprise, 2017 Standard/Enterprise

Configuration

Setup

This template will be automatically connected to discovered entities with all their required parameters pre-defined.

Macros used

Name	Description	Default
{$GCP.DATA.TIMEOUT}	A response timeout for an API.	`15s`
{$GCP.TIME.WINDOW}	Time interval for the data requests. Supported usage type: 1. The default update interval for most of the items. 2. The minimal time window for the data requested in the Monitoring Query Language REST API request.	`5m`
{$GCP.PROXY}	Sets HTTP proxy value. If this macro is empty then no proxy is used.
{$HTTP.TLS.VERIFY}	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 "GCP Cloud SQL MSSQL Replica", e.g. {$HTTP.TLS.VERIFY:"GCP Cloud SQL MSSQL Replica"}.	`full`

Items

Name	Description	Type	Key and additional info
Replica metrics get	MSSQL replica metrics data in raw format.	Script	gcp.cloudsql.mssql.repl.metrics.get Preprocessing Check for not supported value: `any error` ⛔️Custom on fail: Discard value
Bytes sent to replica	Total number of bytes sent to the remote availability replica. For an async replica, returns the number of bytes before compression. For a sync replica without compression, returns the actual number of bytes.	Dependent item	gcp.cloudsql.mssql.repl.bytes_sent_to_replica_count Preprocessing JSON Path: `$.bytes_sent_to_replica_count`
Resent messages	Total count of Always On messages to resend. This includes messages that were attempted to be sent but failed and require resending.	Dependent item	gcp.cloudsql.mssql.repl.resent_message_count Preprocessing JSON Path: `$.resent_message_count`
Log apply pending queue	Current number of log blocks that are waiting to be applied to replica.	Dependent item	gcp.cloudsql.mssql.repl.log_apply_pending_queue Preprocessing JSON Path: `$.log_apply_pending_queue`
Log bytes received	Total size of log records received by the replica.	Dependent item	gcp.cloudsql.mssql.repl.log_bytes_received_count Preprocessing JSON Path: `$.log_bytes_received_count`
Recovery queue	Current size of log records in bytes in the replica's log files that have not been redone.	Dependent item	gcp.cloudsql.mssql.repl.recovery_queue Preprocessing JSON Path: `$.recovery_queue` Custom multiplier: `1024`
Redone bytes	Total size in bytes of redone log records.	Dependent item	gcp.cloudsql.mssql.repl.redone_bytes_count Preprocessing JSON Path: `$.redone_bytes_count`

Feedback

Please report any issues with the template at https://support.zabbix.com

You can also provide feedback, discuss the template, or ask for help at ZABBIX forums

Zabbix version 7.4 7.2 7.0 6.4 6.0

Source: templates/cloud/gcp

GCP Cloud SQL MSSQL Replica by HTTP

Overview

This template is designed to monitor Google Cloud Platform Cloud SQL MSSQL read-only replica instances by Zabbix.

Requirements

Zabbix version: 6.4 and higher.

Tested versions

This template has been tested on:

GCP Cloud SQL MSSQL read replicas versions: 2019 Standard/Enterprise, 2017 Standard/Enterprise

Configuration

Setup

This template will be automatically connected to discovered entities with all their required parameters pre-defined.

Macros used

Name Description Default

{$GCP.DATA.TIMEOUT}

A response timeout for an API.

15s

{$GCP.TIME.WINDOW}

Time interval for the data requests.

Supported usage type:

1. The default update interval for most of the items.

2. The minimal time window for the data requested in the Monitoring Query Language REST API request.

5m

{$GCP.PROXY}

Sets HTTP proxy value. If this macro is empty then no proxy is used.

Items

Name	Description	Type	Key and additional info
GCP Cloud SQL MSSQL: Replica metrics get	MSSQL replica metrics data in raw format.	Script	gcp.cloudsql.mssql.repl.metrics.get Preprocessing Check for not supported value ⛔️Custom on fail: Discard value
GCP Cloud SQL MSSQL: Bytes sent to replica	Total number of bytes sent to the remote availability replica. For an async replica, returns the number of bytes before compression. For a sync replica without compression, returns the actual number of bytes.	Dependent item	gcp.cloudsql.mssql.repl.bytes_sent_to_replica_count Preprocessing JSON Path: `$.bytes_sent_to_replica_count`
GCP Cloud SQL MSSQL: Resent messages	Total count of Always On messages to resend. This includes messages that were attempted to be sent but failed and require resending.	Dependent item	gcp.cloudsql.mssql.repl.resent_message_count Preprocessing JSON Path: `$.resent_message_count`
GCP Cloud SQL MSSQL: Log apply pending queue	Current number of log blocks that are waiting to be applied to replica.	Dependent item	gcp.cloudsql.mssql.repl.log_apply_pending_queue Preprocessing JSON Path: `$.log_apply_pending_queue`
GCP Cloud SQL MSSQL: Log bytes received	Total size of log records received by the replica.	Dependent item	gcp.cloudsql.mssql.repl.log_bytes_received_count Preprocessing JSON Path: `$.log_bytes_received_count`
GCP Cloud SQL MSSQL: Recovery queue	Current size of log records in bytes in the replica's log files that have not been redone.	Dependent item	gcp.cloudsql.mssql.repl.recovery_queue Preprocessing JSON Path: `$.recovery_queue` Custom multiplier: `1024`
GCP Cloud SQL MSSQL: Redone bytes	Total size in bytes of redone log records.	Dependent item	gcp.cloudsql.mssql.repl.redone_bytes_count Preprocessing JSON Path: `$.redone_bytes_count`

Feedback

Please report any issues with the template at https://support.zabbix.com

You can also provide feedback, discuss the template, or ask for help at ZABBIX forums

Zabbix version 7.4 7.2 7.0 6.4 6.0

Source: templates/cloud/gcp

GCP Cloud SQL MSSQL Replica by HTTP

Overview

This template is designed to monitor Google Cloud Platform Cloud SQL MSSQL read-only replica instances by Zabbix.

Requirements

Zabbix version: 6.0 and higher.

Tested versions

This template has been tested on:

GCP Cloud SQL MSSQL read replicas versions: 2019 Standard/Enterprise, 2017 Standard/Enterprise

Configuration

Setup

This template will be automatically connected to discovered entities with all their required parameters pre-defined.

Macros used

Name Description Default

{$GCP.DATA.TIMEOUT}

A response timeout for an API.

15s

{$GCP.TIME.WINDOW}

Time interval for the data requests.

Supported usage type:

1. The default update interval for most of the items.

2. The minimal time window for the data requested in the Monitoring Query Language REST API request.

5m

{$GCP.PROXY}

Sets HTTP proxy value. If this macro is empty then no proxy is used.

Items

Name	Description	Type	Key and additional info
GCP Cloud SQL MSSQL: Replica metrics get	MSSQL replica metrics data in raw format.	Script	gcp.cloudsql.mssql.repl.metrics.get Preprocessing Check for not supported value ⛔️Custom on fail: Discard value
GCP Cloud SQL MSSQL: Bytes sent to replica	Total number of bytes sent to the remote availability replica. For an async replica, returns the number of bytes before compression. For a sync replica without compression, returns the actual number of bytes.	Dependent item	gcp.cloudsql.mssql.repl.bytes_sent_to_replica_count Preprocessing JSON Path: `$.bytes_sent_to_replica_count`
GCP Cloud SQL MSSQL: Resent messages	Total count of Always On messages to resend. This includes messages that were attempted to be sent but failed and require resending.	Dependent item	gcp.cloudsql.mssql.repl.resent_message_count Preprocessing JSON Path: `$.resent_message_count`
GCP Cloud SQL MSSQL: Log apply pending queue	Current number of log blocks that are waiting to be applied to replica.	Dependent item	gcp.cloudsql.mssql.repl.log_apply_pending_queue Preprocessing JSON Path: `$.log_apply_pending_queue`
GCP Cloud SQL MSSQL: Log bytes received	Total size of log records received by the replica.	Dependent item	gcp.cloudsql.mssql.repl.log_bytes_received_count Preprocessing JSON Path: `$.log_bytes_received_count`
GCP Cloud SQL MSSQL: Recovery queue	Current size of log records in bytes in the replica's log files that have not been redone.	Dependent item	gcp.cloudsql.mssql.repl.recovery_queue Preprocessing JSON Path: `$.recovery_queue` Custom multiplier: `1024`
GCP Cloud SQL MSSQL: Redone bytes	Total size in bytes of redone log records.	Dependent item	gcp.cloudsql.mssql.repl.redone_bytes_count Preprocessing JSON Path: `$.redone_bytes_count`

Feedback

Please report any issues with the template at https://support.zabbix.com

You can also provide feedback, discuss the template, or ask for help at ZABBIX forums

Zabbix 7.4 - Less work. More depth.

Vyzkoušejte Zabbix Cloud s bezplatnou zkušební verzí

Staňte se partnerem Zabbixu

Zabbix Academy is launched!

Přidejte se k našemu globálnímu týmu!

Zabbix + GCP Cloud SQL

GCP Cloud SQL

Dostupná řešení

GCP Cloud SQL MySQL by HTTP

Overview

Requirements

Tested versions

Configuration

Setup

Macros used

Items

Triggers

GCP Cloud SQL MySQL by HTTP

Overview

Requirements

Tested versions

Configuration

Setup

Macros used

Items

Triggers

GCP Cloud SQL MySQL by HTTP

Overview

Requirements

Tested versions

Configuration

Setup

Macros used

Items

Triggers

GCP Cloud SQL MySQL by HTTP

Overview

Requirements

Tested versions

Configuration

Setup

Macros used

Items

Triggers

GCP Cloud SQL MySQL by HTTP

Overview

Requirements

Tested versions

Configuration

Setup

Macros used

Items

Triggers

GCP Cloud SQL MySQL Replica by HTTP

Overview

Requirements

Tested versions

Configuration

Setup

Macros used

Items

GCP Cloud SQL MySQL Replica by HTTP

Overview

Requirements

Tested versions

Configuration

Setup

Macros used

Items

GCP Cloud SQL MySQL Replica by HTTP

Overview

Requirements

Tested versions

Configuration

Setup

Macros used

Items

GCP Cloud SQL MySQL Replica by HTTP

Overview

Requirements