Try it free

Google Cloud SQL monitoring

  • Dynatrace Classic
  • How-to guide
  • 4-min read
  • Published Jan 17, 2022

Dynatrace Google Cloud integration leverages data collected from the Google Operation API to constantly monitor health and performance of Google Cloud Services. While combining all relevant data into dashboards, it also enables alerting and event tracking.

Prerequisites

Set up integration

Add services and feature sets Optional

After integration, Dynatrace automatically monitors a number of preset Google Cloud services and feature sets (metrics). Besides these, you can add more services or feature sets to monitoring. For details, see Add or remove services.

For a list of feature sets available for this service, see Metric table.

View metrics

After deploying the integration, you can see metrics from monitored services in the Metrics browser, Data Explorer, and your dashboard tiles.

Metric table

The following feature sets are available for Google Cloud SQL.

Feature setNameUnitGCP metric identifier

cloudsql_database/default_metrics

Auto-failover Requests

Count

cloudsql.googleapis.com/database/auto_failover_request_count

cloudsql_database/default_metrics

Available for failover

Count

cloudsql.googleapis.com/database/available_for_failover

cloudsql_database/default_metrics

CPU reserved cores

Count

cloudsql.googleapis.com/database/cpu/reserved_cores

cloudsql_database/default_metrics

CPU usage

Second

cloudsql.googleapis.com/database/cpu/usage_time

cloudsql_database/default_metrics

CPU utilization

Percent

cloudsql.googleapis.com/database/cpu/utilization

cloudsql_database/default_metrics

Bytes used

Byte

cloudsql.googleapis.com/database/disk/bytes_used

cloudsql_database/default_metrics

Disk quota

Byte

cloudsql.googleapis.com/database/disk/quota

cloudsql_database/default_metrics

Disk read IO

Count

cloudsql.googleapis.com/database/disk/read_ops_count

cloudsql_database/default_metrics

Disk utilization

Count

cloudsql.googleapis.com/database/disk/utilization

cloudsql_database/default_metrics

Disk write IO

Count

cloudsql.googleapis.com/database/disk/write_ops_count

cloudsql_database/default_metrics

Instance state

Unspecified

cloudsql.googleapis.com/database/instance_state

cloudsql_database/default_metrics

Memory quota

Byte

cloudsql.googleapis.com/database/memory/quota

cloudsql_database/default_metrics

Total memory usage

Byte

cloudsql.googleapis.com/database/memory/total_usage

cloudsql_database/default_metrics

Memory usage

Byte

cloudsql.googleapis.com/database/memory/usage

cloudsql_database/default_metrics

Memory utilization

Count

cloudsql.googleapis.com/database/memory/utilization

cloudsql_database/default_metrics

InnoDB dirty pages

Count

cloudsql.googleapis.com/database/mysql/innodb_buffer_pool_pages_dirty

cloudsql_database/default_metrics

InnoDB free pages

Count

cloudsql.googleapis.com/database/mysql/innodb_buffer_pool_pages_free

cloudsql_database/default_metrics

InnoDB total pages

Count

cloudsql.googleapis.com/database/mysql/innodb_buffer_pool_pages_total

cloudsql_database/default_metrics

InnoDB fsync calls

Count

cloudsql.googleapis.com/database/mysql/innodb_data_fsyncs

cloudsql_database/default_metrics

InnoDB log fsync calls

Count

cloudsql.googleapis.com/database/mysql/innodb_os_log_fsyncs

cloudsql_database/default_metrics

InnoDB pages read

Count

cloudsql.googleapis.com/database/mysql/innodb_pages_read

cloudsql_database/default_metrics

InnoDB pages written

Count

cloudsql.googleapis.com/database/mysql/innodb_pages_written

cloudsql_database/default_metrics

Queries

Count

cloudsql.googleapis.com/database/mysql/queries

cloudsql_database/default_metrics

Questions

Count

cloudsql.googleapis.com/database/mysql/questions

cloudsql_database/default_metrics

Network bytes received by MySQL

Byte

cloudsql.googleapis.com/database/mysql/received_bytes_count

cloudsql_database/default_metrics

Available for failover (Deprecated)

Count

cloudsql.googleapis.com/database/mysql/replication/available_for_failover

cloudsql_database/default_metrics

Last I/O thread error number

Count

cloudsql.googleapis.com/database/mysql/replication/last_io_errno

cloudsql_database/default_metrics

Last SQL thread error number

Count

cloudsql.googleapis.com/database/mysql/replication/last_sql_errno

cloudsql_database/default_metrics

Replica lag

Second

cloudsql.googleapis.com/database/mysql/replication/seconds_behind_master

cloudsql_database/default_metrics

Slave I/O thread running state

Unspecified

cloudsql.googleapis.com/database/mysql/replication/slave_io_running_state

cloudsql_database/default_metrics

Slave SQL thread running state

Unspecified

cloudsql.googleapis.com/database/mysql/replication/slave_sql_running_state

cloudsql_database/default_metrics

Network bytes sent by MySQL

Byte

cloudsql.googleapis.com/database/mysql/sent_bytes_count

cloudsql_database/default_metrics

Cloud SQL Connections

Count

cloudsql.googleapis.com/database/network/connections

cloudsql_database/default_metrics

Received bytes

Byte

cloudsql.googleapis.com/database/network/received_bytes_count

cloudsql_database/default_metrics

Sent bytes

Byte

cloudsql.googleapis.com/database/network/sent_bytes_count

cloudsql_database/default_metrics

Execution time

MicroSecond

cloudsql.googleapis.com/database/postgresql/insights/aggregate/execution_time

cloudsql_database/default_metrics

IO time

MicroSecond

cloudsql.googleapis.com/database/postgresql/insights/aggregate/io_time

cloudsql_database/default_metrics

Latency

MicroSecond

cloudsql.googleapis.com/database/postgresql/insights/aggregate/latencies

cloudsql_database/default_metrics

Aggregated lock time

MicroSecond

cloudsql.googleapis.com/database/postgresql/insights/aggregate/lock_time

cloudsql_database/default_metrics

Affected rows

Count

cloudsql.googleapis.com/database/postgresql/insights/aggregate/row_count

cloudsql_database/default_metrics

Shared blocks cache access

Count

cloudsql.googleapis.com/database/postgresql/insights/aggregate/shared_blk_access_count

cloudsql_database/default_metrics

Per query execution times

MicroSecond

cloudsql.googleapis.com/database/postgresql/insights/perquery/execution_time

cloudsql_database/default_metrics

Per query IO time

MicroSecond

cloudsql.googleapis.com/database/postgresql/insights/perquery/io_time

cloudsql_database/default_metrics

Per query latency

MicroSecond

cloudsql.googleapis.com/database/postgresql/insights/perquery/latencies

cloudsql_database/default_metrics

Per query lock time

MicroSecond

cloudsql.googleapis.com/database/postgresql/insights/perquery/lock_time

cloudsql_database/default_metrics

Per query affected rows

Count

cloudsql.googleapis.com/database/postgresql/insights/perquery/row_count

cloudsql_database/default_metrics

Per query Shared blocks cache access

Count

cloudsql.googleapis.com/database/postgresql/insights/perquery/shared_blk_access_count

cloudsql_database/default_metrics

Per tag execution time

MicroSecond

cloudsql.googleapis.com/database/postgresql/insights/pertag/execution_time

cloudsql_database/default_metrics

Per tag IO time

MicroSecond

cloudsql.googleapis.com/database/postgresql/insights/pertag/io_time

cloudsql_database/default_metrics

Per tag latency

MicroSecond

cloudsql.googleapis.com/database/postgresql/insights/pertag/latencies

cloudsql_database/default_metrics

Per tag lock time

MicroSecond

cloudsql.googleapis.com/database/postgresql/insights/pertag/lock_time

cloudsql_database/default_metrics

Per tag affected rows

Count

cloudsql.googleapis.com/database/postgresql/insights/pertag/row_count

cloudsql_database/default_metrics

Per tag shared blocks cache accessed

Count

cloudsql.googleapis.com/database/postgresql/insights/pertag/shared_blk_access_count

cloudsql_database/default_metrics

PostgreSQL Connections

Count

cloudsql.googleapis.com/database/postgresql/num_backends

cloudsql_database/default_metrics

Lag bytes

Byte

cloudsql.googleapis.com/database/postgresql/replication/replica_byte_lag

cloudsql_database/default_metrics

Number of transactions

Count

cloudsql.googleapis.com/database/postgresql/transaction_count

cloudsql_database/default_metrics

Replica lag

Second

cloudsql.googleapis.com/database/replication/replica_lag

cloudsql_database/default_metrics

Server up

Count

cloudsql.googleapis.com/database/up

cloudsql_database/default_metrics

Uptime

Second

cloudsql.googleapis.com/database/uptime

Related topics

  • Google Cloud integrations
Related tags
Infrastructure Observability