GCP Cloud SQL
Overview
The GCP Cloud SQL integration with ObserveOps (formerly known as AIOps) collects operational telemetry from Google Cloud SQL instances. It monitors instance state, CPU and memory utilization, disk I/O, network activity, replication lag, and database-engine-specific metrics across MySQL, PostgreSQL, and SQL Server.
These metrics help administrators track query performance, monitor connection health, identify replication issues, and maintain visibility across all Cloud SQL database engines.
Prerequisites
- The GCP project has Cloud SQL instances running.
- The service account used for integration has the Cloud SQL Viewer and Monitoring Viewer roles.
- Required GCP API endpoints are reachable from ObserveOps.
- The GCP project is added in discovery with correct credentials and region configuration.
List of Supported KPIs
MySQL
| Metric | Description | Type |
|---|---|---|
| gcp.mysql | Identifier of the Cloud SQL MySQL instance. | String |
| gcp.mysql.state | Current operational state of the MySQL instance. | String |
| gcp.mysql.cpu.percent | CPU utilization percentage of the MySQL instance. | Percent |
| gcp.mysql.memory.used.percent | Memory utilization percentage of the MySQL instance. | Percent |
| gcp.mysql.memory.bytes | Total memory capacity of the MySQL instance. | Bytes |
| gcp.mysql.memory.used.bytes | Amount of memory currently in use on the MySQL instance. | Bytes |
| gcp.mysql.network.sent.bytes | Total bytes sent over the network from the MySQL instance. | Bytes |
| gcp.mysql.network.received.bytes | Total bytes received over the network by the MySQL instance. | Bytes |
| gcp.mysql.disk.used.bytes | Total disk storage used by the MySQL instance. | Bytes |
| gcp.mysql.disk.quota.bytes | Disk storage quota allocated to the MySQL instance. | Bytes |
| gcp.mysql.disk.read.iops | Read I/O operations per second on the MySQL instance disk. | Count/sec |
| gcp.mysql.disk.write.iops | Write I/O operations per second on the MySQL instance disk. | Count/sec |
| gcp.mysql.replication.lag.seconds | Replication lag in seconds for the MySQL instance replica. | Seconds |
| gcp.mysql.connections | Number of active connections to the MySQL instance. | Count |
| gcp.mysql.queries | Total number of queries executed on the MySQL instance. | Count |
| gcp.mysql.questions | Total number of client statements executed on the MySQL instance. | Count |
| gcp.mysql.innodb.data.fsyncs | Number of InnoDB fsync operations performed. | Count |
| gcp.mysql.innodb.os.log.fsyncs | Number of InnoDB OS log fsync operations performed. | Count |
| gcp.mysql.innodb.pages.read | Number of InnoDB pages read from disk. | Count |
| gcp.mysql.innodb.pages.written | Number of InnoDB pages written to disk. | Count |
| gcp.mysql.received.bytes | Total bytes received by the MySQL server. | Bytes |
| gcp.mysql.sent.bytes | Total bytes sent by the MySQL server. | Bytes |
PostgreSQL
| Metric | Description | Type |
|---|---|---|
| gcp.postgresql | Identifier of the Cloud SQL PostgreSQL instance. | String |
| gcp.postgresql.state | Current operational state of the PostgreSQL instance. | String |
| gcp.postgresql.cpu.percent | CPU utilization percentage of the PostgreSQL instance. | Percent |
| gcp.postgresql.memory.used.percent | Memory utilization percentage of the PostgreSQL instance. | Percent |
| gcp.postgresql.memory.bytes | Total memory capacity of the PostgreSQL instance. | Bytes |
| gcp.postgresql.memory.used.bytes | Amount of memory currently in use on the PostgreSQL instance. | Bytes |
| gcp.postgresql.network.sent.bytes | Total bytes sent over the network from the PostgreSQL instance. | Bytes |
| gcp.postgresql.network.received.bytes | Total bytes received over the network by the PostgreSQL instance. | Bytes |
| gcp.postgresql.disk.used.bytes | Total disk storage used by the PostgreSQL instance. | Bytes |
| gcp.postgresql.disk.quota.bytes | Disk storage quota allocated to the PostgreSQL instance. | Bytes |
| gcp.postgresql.disk.read.iops | Read I/O operations per second on the PostgreSQL instance disk. | Count/sec |
| gcp.postgresql.disk.write.iops | Write I/O operations per second on the PostgreSQL instance disk. | Count/sec |
| gcp.postgresql.replication.lag.seconds | Replication lag in seconds for the PostgreSQL instance replica. | Seconds |
| gcp.postgresql.connections | Number of active connections to the PostgreSQL instance. | Count |
| gcp.postgresql.num.backends | Number of active backend processes on the PostgreSQL instance. | Count |
| gcp.postgresql.deadlocks | Total number of deadlocks detected on the PostgreSQL instance. | Count |
| gcp.postgresql.blocks.read | Total disk blocks read by the PostgreSQL instance. | Count |
| gcp.postgresql.blocks.hit | Total buffer hits on the PostgreSQL instance. | Count |
| gcp.postgresql.temp.bytes | Total bytes written to temporary files by the PostgreSQL instance. | Bytes |
| gcp.postgresql.temp.files | Total number of temporary files created by the PostgreSQL instance. | Count |
| gcp.postgresql.tup.fetched | Total number of rows fetched by queries on the PostgreSQL instance. | Count |
| gcp.postgresql.tup.returned | Total number of rows returned by queries on the PostgreSQL instance. | Count |
| gcp.postgresql.tup.inserted | Total number of rows inserted on the PostgreSQL instance. | Count |
| gcp.postgresql.tup.updated | Total number of rows updated on the PostgreSQL instance. | Count |
| gcp.postgresql.tup.deleted | Total number of rows deleted on the PostgreSQL instance. | Count |
SQL Server
| Metric | Description | Type |
|---|---|---|
| gcp.sql.server | Identifier of the Cloud SQL SQL Server instance. | String |
| gcp.sql.server.state | Current operational state of the SQL Server instance. | String |
| gcp.sql.server.cpu.percent | CPU utilization percentage of the SQL Server instance. | Percent |
| gcp.sql.server.memory.used.percent | Memory utilization percentage of the SQL Server instance. | Percent |
| gcp.sql.server.memory.bytes | Total memory capacity of the SQL Server instance. | Bytes |
| gcp.sql.server.memory.used.bytes | Amount of memory currently in use on the SQL Server instance. | Bytes |
| gcp.sql.server.network.sent.bytes | Total bytes sent over the network from the SQL Server instance. | Bytes |
| gcp.sql.server.network.received.bytes | Total bytes received over the network by the SQL Server instance. | Bytes |
| gcp.sql.server.disk.used.bytes | Total disk storage used by the SQL Server instance. | Bytes |
| gcp.sql.server.disk.quota.bytes | Disk storage quota allocated to the SQL Server instance. | Bytes |
| gcp.sql.server.disk.read.iops | Read I/O operations per second on the SQL Server instance disk. | Count/sec |
| gcp.sql.server.disk.write.iops | Write I/O operations per second on the SQL Server instance disk. | Count/sec |
| gcp.sql.server.replication.lag.seconds | Replication lag in seconds for the SQL Server instance replica. | Seconds |
| gcp.sql.server.connections | Number of active connections to the SQL Server instance. | Count |
| gcp.sql.server.user.connections | Number of active user connections to the SQL Server instance. | Count |
| gcp.sql.server.transactions.per.second | Number of transactions executed per second on the SQL Server instance. | Count/sec |
| gcp.sql.server.lock.waits.per.second | Number of lock waits per second on the SQL Server instance. | Count/sec |
| gcp.sql.server.deadlocks.per.second | Number of deadlocks per second on the SQL Server instance. | Count/sec |
| gcp.sql.server.page.reads.per.second | Number of page reads per second on the SQL Server instance. | Count/sec |
| gcp.sql.server.page.writes.per.second | Number of page writes per second on the SQL Server instance. | Count/sec |
| gcp.sql.server.batch.requests.per.second | Number of batch requests received per second by the SQL Server instance. | Count/sec |