Google Cloud SQL monitoring

  • 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_metricsAuto-failover RequestsCountcloudsql.googleapis.com/database/auto_failover_request_count
cloudsql_database/default_metricsAvailable for failoverCountcloudsql.googleapis.com/database/available_for_failover
cloudsql_database/default_metricsCPU reserved coresCountcloudsql.googleapis.com/database/cpu/reserved_cores
cloudsql_database/default_metricsCPU usageSecondcloudsql.googleapis.com/database/cpu/usage_time
cloudsql_database/default_metricsCPU utilizationPercentcloudsql.googleapis.com/database/cpu/utilization
cloudsql_database/default_metricsBytes usedBytecloudsql.googleapis.com/database/disk/bytes_used
cloudsql_database/default_metricsDisk quotaBytecloudsql.googleapis.com/database/disk/quota
cloudsql_database/default_metricsDisk read IOCountcloudsql.googleapis.com/database/disk/read_ops_count
cloudsql_database/default_metricsDisk utilizationCountcloudsql.googleapis.com/database/disk/utilization
cloudsql_database/default_metricsDisk write IOCountcloudsql.googleapis.com/database/disk/write_ops_count
cloudsql_database/default_metricsInstance stateUnspecifiedcloudsql.googleapis.com/database/instance_state
cloudsql_database/default_metricsMemory quotaBytecloudsql.googleapis.com/database/memory/quota
cloudsql_database/default_metricsTotal memory usageBytecloudsql.googleapis.com/database/memory/total_usage
cloudsql_database/default_metricsMemory usageBytecloudsql.googleapis.com/database/memory/usage
cloudsql_database/default_metricsMemory utilizationCountcloudsql.googleapis.com/database/memory/utilization
cloudsql_database/default_metricsInnoDB dirty pagesCountcloudsql.googleapis.com/database/mysql/innodb_buffer_pool_pages_dirty
cloudsql_database/default_metricsInnoDB free pagesCountcloudsql.googleapis.com/database/mysql/innodb_buffer_pool_pages_free
cloudsql_database/default_metricsInnoDB total pagesCountcloudsql.googleapis.com/database/mysql/innodb_buffer_pool_pages_total
cloudsql_database/default_metricsInnoDB fsync callsCountcloudsql.googleapis.com/database/mysql/innodb_data_fsyncs
cloudsql_database/default_metricsInnoDB log fsync callsCountcloudsql.googleapis.com/database/mysql/innodb_os_log_fsyncs
cloudsql_database/default_metricsInnoDB pages readCountcloudsql.googleapis.com/database/mysql/innodb_pages_read
cloudsql_database/default_metricsInnoDB pages writtenCountcloudsql.googleapis.com/database/mysql/innodb_pages_written
cloudsql_database/default_metricsQueriesCountcloudsql.googleapis.com/database/mysql/queries
cloudsql_database/default_metricsQuestionsCountcloudsql.googleapis.com/database/mysql/questions
cloudsql_database/default_metricsNetwork bytes received by MySQLBytecloudsql.googleapis.com/database/mysql/received_bytes_count
cloudsql_database/default_metricsAvailable for failover (Deprecated)Countcloudsql.googleapis.com/database/mysql/replication/available_for_failover
cloudsql_database/default_metricsLast I/O thread error numberCountcloudsql.googleapis.com/database/mysql/replication/last_io_errno
cloudsql_database/default_metricsLast SQL thread error numberCountcloudsql.googleapis.com/database/mysql/replication/last_sql_errno
cloudsql_database/default_metricsReplica lagSecondcloudsql.googleapis.com/database/mysql/replication/seconds_behind_master
cloudsql_database/default_metricsSlave I/O thread running stateUnspecifiedcloudsql.googleapis.com/database/mysql/replication/slave_io_running_state
cloudsql_database/default_metricsSlave SQL thread running stateUnspecifiedcloudsql.googleapis.com/database/mysql/replication/slave_sql_running_state
cloudsql_database/default_metricsNetwork bytes sent by MySQLBytecloudsql.googleapis.com/database/mysql/sent_bytes_count
cloudsql_database/default_metricsCloud SQL ConnectionsCountcloudsql.googleapis.com/database/network/connections
cloudsql_database/default_metricsReceived bytesBytecloudsql.googleapis.com/database/network/received_bytes_count
cloudsql_database/default_metricsSent bytesBytecloudsql.googleapis.com/database/network/sent_bytes_count
cloudsql_database/default_metricsExecution timeMicroSecondcloudsql.googleapis.com/database/postgresql/insights/aggregate/execution_time
cloudsql_database/default_metricsIO timeMicroSecondcloudsql.googleapis.com/database/postgresql/insights/aggregate/io_time
cloudsql_database/default_metricsLatencyMicroSecondcloudsql.googleapis.com/database/postgresql/insights/aggregate/latencies
cloudsql_database/default_metricsAggregated lock timeMicroSecondcloudsql.googleapis.com/database/postgresql/insights/aggregate/lock_time
cloudsql_database/default_metricsAffected rowsCountcloudsql.googleapis.com/database/postgresql/insights/aggregate/row_count
cloudsql_database/default_metricsShared blocks cache accessCountcloudsql.googleapis.com/database/postgresql/insights/aggregate/shared_blk_access_count
cloudsql_database/default_metricsPer query execution timesMicroSecondcloudsql.googleapis.com/database/postgresql/insights/perquery/execution_time
cloudsql_database/default_metricsPer query IO timeMicroSecondcloudsql.googleapis.com/database/postgresql/insights/perquery/io_time
cloudsql_database/default_metricsPer query latencyMicroSecondcloudsql.googleapis.com/database/postgresql/insights/perquery/latencies
cloudsql_database/default_metricsPer query lock timeMicroSecondcloudsql.googleapis.com/database/postgresql/insights/perquery/lock_time
cloudsql_database/default_metricsPer query affected rowsCountcloudsql.googleapis.com/database/postgresql/insights/perquery/row_count
cloudsql_database/default_metricsPer query Shared blocks cache accessCountcloudsql.googleapis.com/database/postgresql/insights/perquery/shared_blk_access_count
cloudsql_database/default_metricsPer tag execution timeMicroSecondcloudsql.googleapis.com/database/postgresql/insights/pertag/execution_time
cloudsql_database/default_metricsPer tag IO timeMicroSecondcloudsql.googleapis.com/database/postgresql/insights/pertag/io_time
cloudsql_database/default_metricsPer tag latencyMicroSecondcloudsql.googleapis.com/database/postgresql/insights/pertag/latencies
cloudsql_database/default_metricsPer tag lock timeMicroSecondcloudsql.googleapis.com/database/postgresql/insights/pertag/lock_time
cloudsql_database/default_metricsPer tag affected rowsCountcloudsql.googleapis.com/database/postgresql/insights/pertag/row_count
cloudsql_database/default_metricsPer tag shared blocks cache accessedCountcloudsql.googleapis.com/database/postgresql/insights/pertag/shared_blk_access_count
cloudsql_database/default_metricsPostgreSQL ConnectionsCountcloudsql.googleapis.com/database/postgresql/num_backends
cloudsql_database/default_metricsLag bytesBytecloudsql.googleapis.com/database/postgresql/replication/replica_byte_lag
cloudsql_database/default_metricsNumber of transactionsCountcloudsql.googleapis.com/database/postgresql/transaction_count
cloudsql_database/default_metricsReplica lagSecondcloudsql.googleapis.com/database/replication/replica_lag
cloudsql_database/default_metricsServer upCountcloudsql.googleapis.com/database/up
cloudsql_database/default_metricsUptimeSecondcloudsql.googleapis.com/database/uptime
Related tags
Infrastructure Observability