Google Cloud SQL monitoring
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
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 set | Name | Unit | GCP 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 |