Monitor Google Cloud SQL
Dynatrace GCP integration leverages data collected from the Google Operation API to constantly monitor health and performance of Google Cloud Platform 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 GCP 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.
Extensions for GCP services
After adding a service to monitoring, it appears as an enabled extension in Dynatrace. Then, your dashboards and custom events for alerting are instantly available in your Dynatrace environment. To see the list of extensions, in the Dynatrace menu, go to Extensions.
Note: If you want to stop a service from sending metrics to Dynatrace, removing the relevant extension isn't enough. You also need to remove the service from monitoring. For details, see Add or remove services.
View metrics
After deploying the integration, you can see metrics from monitored services in the Metrics browser, the 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 | 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 |
| 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 |
| 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 | 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 | cloudsql.googleapis.com/database/state | ||
| cloudsql_database/default_metrics | Server up | Count | cloudsql.googleapis.com/database/up |
| cloudsql_database/default_metrics | Uptime | Second | cloudsql.googleapis.com/database/uptime |