Google Cloud SQLGoogle Cloud SQL
Get insights into Google Cloud SQL service metrics collected from the Google Operations API to ensure health of your cloud infrastructure.
Extension
- Product information
- Release notes
Overview
This Dynatrace extension leverages data collected from the Google Operations API to constantly monitor health and performance of Google Cloud SQL services. This extension combines all relevant data into pre-configured dashboards and provides alerting and event tracking.
This is intended for users, who want to:
- enrich their monitoring data with metrics and logs from Google Operations API
This enables you to:
-
View and analyze 40 metrics that are specific to Google Cloud SQL, like Auto-failover Requests, Available for failover, CPU reserved cores, and more.
-
Use dashboard presets for immediate visibility into availability, usage, and performance of your Google Cloud SQL services.
-
Build custom dashboards for your cloud infrastructure.
-
Analyze Google Cloud SQL logs.
-
Use preconfigured alerting.
-
Set custom alerts that trigger remediation workflows.
Google Cloud SQL metric and log ingestion requires advanced GCP integration.
Compatibility requirements
- Dynatrace GCP integration version 1.0.0+. To enable metric and log ingestion, see Dynatrace Documentation.
- Dynatrace version 1.256+
Details
This extension package contains:
- Configuration for Google Cloud SQL metric ingest based on your selected feature set (see the full list of feature sets and metrics)
- Google Cloud SQL preconfigured dashboard
- Topology mapping and service instance analysis view
- Google Cloud SQL predefined alerts for:
Cloud SQL Database CPU utilization [GCP]
To provide correlation and causation analysis all ingested metrics and logs are analyzed by the Dynatrace Davis AI engine, which consumes DDUs.
Get started
To add this extension to your environment:
- Follow the instructions detailed in Dynatrace Documentation. (Ignore the “Download” button below.)
- Ensure that you have GCP integration running in your environment and that Google Cloud SQL service is configured.
Following GCP integration and Google Cloud SQL configuration:
- The first data points will be ingested by Dynatrace Davis within ~5 minutes.
- Work with the Google Cloud SQL preconfigured dashboard to understand its capabilities.
- Explore Google Cloud SQL metrics in Data Explorer and create custom charts.
- Activate predefined alerting or set custom events for alerting
Extension content
Content typeNumber of items included
screen injections
1
generic relationship
1
alerts
1
screen actions
1
dashboards
1
screen layout
1
list screen layout
1
generic type
2
screen entities lists
2
metric metadata
59
Feature sets
Below is a complete list of the feature sets provided in this version. To ensure a good fit for your needs, individual feature sets can be activated and deactivated by your administrator during configuration.
Feature setsNumber of metrics included
| Metric name | Metric key | Description | Unit |
|---|---|---|---|
| Auto-failover Requests | cloud.gcp.cloudsql_googleapis_com.database.auto_failover_request_count | - | Count |
| Available for failover | cloud.gcp.cloudsql_googleapis_com.database.available_for_failover | - | Count |
| CPU reserved cores | cloud.gcp.cloudsql_googleapis_com.database.cpu.reserved_cores | - | Count |
| CPU usage | cloud.gcp.cloudsql_googleapis_com.database.cpu.usage_time.count | - | Second |
| CPU utilization | cloud.gcp.cloudsql_googleapis_com.database.cpu.utilization | - | Percent |
| Bytes used | cloud.gcp.cloudsql_googleapis_com.database.disk.bytes_used | - | Byte |
| Disk quota | cloud.gcp.cloudsql_googleapis_com.database.disk.quota | - | Byte |
| Disk read IO | cloud.gcp.cloudsql_googleapis_com.database.disk.read_ops_count | - | Count |
| Disk utilization | cloud.gcp.cloudsql_googleapis_com.database.disk.utilization | - | Count |
| Disk write IO | cloud.gcp.cloudsql_googleapis_com.database.disk.write_ops_count | - | Count |
| Instance state | cloud.gcp.cloudsql_googleapis_com.database.instance_state | - | Unspecified |
| Memory quota | cloud.gcp.cloudsql_googleapis_com.database.memory.quota | - | Byte |
| Total memory usage | cloud.gcp.cloudsql_googleapis_com.database.memory.total_usage | - | Byte |
| Memory usage | cloud.gcp.cloudsql_googleapis_com.database.memory.usage | - | Byte |
| Memory utilization | cloud.gcp.cloudsql_googleapis_com.database.memory.utilization | - | Count |
| InnoDB dirty pages | cloud.gcp.cloudsql_googleapis_com.database.mysql.innodb_buffer_pool_pages_dirty | - | Count |
| InnoDB free pages | cloud.gcp.cloudsql_googleapis_com.database.mysql.innodb_buffer_pool_pages_free | - | Count |
| InnoDB total pages | cloud.gcp.cloudsql_googleapis_com.database.mysql.innodb_buffer_pool_pages_total | - | Count |
| InnoDB fsync calls | cloud.gcp.cloudsql_googleapis_com.database.mysql.innodb_data_fsyncs.count | - | Count |
| InnoDB log fsync calls | cloud.gcp.cloudsql_googleapis_com.database.mysql.innodb_os_log_fsyncs.count | - | Count |
| InnoDB pages read | cloud.gcp.cloudsql_googleapis_com.database.mysql.innodb_pages_read.count | - | Count |
| InnoDB pages written | cloud.gcp.cloudsql_googleapis_com.database.mysql.innodb_pages_written.count | - | Count |
| Queries | cloud.gcp.cloudsql_googleapis_com.database.mysql.queries.count | - | Count |
| Questions | cloud.gcp.cloudsql_googleapis_com.database.mysql.questions.count | - | Count |
| Network bytes received by MySQL | cloud.gcp.cloudsql_googleapis_com.database.mysql.received_bytes_count | - | Byte |
| Available for failover (Deprecated) | cloud.gcp.cloudsql_googleapis_com.database.mysql.replication.available_for_failover | - | Count |
| Last I/O thread error number. | cloud.gcp.cloudsql_googleapis_com.database.mysql.replication.last_io_errno | - | Count |
| Last SQL thread error number. | cloud.gcp.cloudsql_googleapis_com.database.mysql.replication.last_sql_errno | - | Count |
| Replica lag | cloud.gcp.cloudsql_googleapis_com.database.mysql.replication.seconds_behind_master | - | Second |
| Slave I/O thread running state | cloud.gcp.cloudsql_googleapis_com.database.mysql.replication.slave_io_running_state | - | Unspecified |
| Slave SQL thread running state | cloud.gcp.cloudsql_googleapis_com.database.mysql.replication.slave_sql_running_state | - | Unspecified |
| Network bytes sent by MySQL | cloud.gcp.cloudsql_googleapis_com.database.mysql.sent_bytes_count | - | Byte |
| Cloud SQL Connections | cloud.gcp.cloudsql_googleapis_com.database.network.connections | - | Count |
| Received bytes | cloud.gcp.cloudsql_googleapis_com.database.network.received_bytes_count | - | Byte |
| Sent bytes | cloud.gcp.cloudsql_googleapis_com.database.network.sent_bytes_count | - | Byte |
| PostgreSQL Connections | cloud.gcp.cloudsql_googleapis_com.database.postgresql.num_backends | - | Count |
| Lag bytes | cloud.gcp.cloudsql_googleapis_com.database.postgresql.replication.replica_byte_lag | - | Byte |
| Number of transactions | cloud.gcp.cloudsql_googleapis_com.database.postgresql.transaction_count | - | Count |
| Replication lag | cloud.gcp.cloudsql_googleapis_com.database.replication.replica_lag | - | Second |
| Server up | cloud.gcp.cloudsql_googleapis_com.database.up | - | Count |
| Uptime | cloud.gcp.cloudsql_googleapis_com.database.uptime.count | - | Second |
| Metric name | Metric key | Description | Unit |
|---|---|---|---|
| Execution time | cloud.gcp.cloudsql_googleapis_com.database.postgresql.insights.aggregate.execution_time.count | - | MicroSecond |
| IO time | cloud.gcp.cloudsql_googleapis_com.database.postgresql.insights.aggregate.io_time.count | - | MicroSecond |
| Latency | cloud.gcp.cloudsql_googleapis_com.database.postgresql.insights.aggregate.latencies | - | MicroSecond |
| Aggregated lock time | cloud.gcp.cloudsql_googleapis_com.database.postgresql.insights.aggregate.lock_time.count | - | MicroSecond |
| Affected rows | cloud.gcp.cloudsql_googleapis_com.database.postgresql.insights.aggregate.row_count | - | Count |
| Shared blocks cache access | cloud.gcp.cloudsql_googleapis_com.database.postgresql.insights.aggregate.shared_blk_access_count | - | Count |
| Per query execution time | cloud.gcp.cloudsql_googleapis_com.database.postgresql.insights.perquery.execution_time.count | - | MicroSecond |
| Per query IO time | cloud.gcp.cloudsql_googleapis_com.database.postgresql.insights.perquery.io_time.count | - | MicroSecond |
| Per query latency | cloud.gcp.cloudsql_googleapis_com.database.postgresql.insights.perquery.latencies | - | MicroSecond |
| Per query lock time | cloud.gcp.cloudsql_googleapis_com.database.postgresql.insights.perquery.lock_time.count | - | MicroSecond |
| Per query affected rows | cloud.gcp.cloudsql_googleapis_com.database.postgresql.insights.perquery.row_count | - | Count |
| Per query shared blocks cache access | cloud.gcp.cloudsql_googleapis_com.database.postgresql.insights.perquery.shared_blk_access_count | - | Count |
| Per tag execution time | cloud.gcp.cloudsql_googleapis_com.database.postgresql.insights.pertag.execution_time.count | - | MicroSecond |
| Per tag IO time | cloud.gcp.cloudsql_googleapis_com.database.postgresql.insights.pertag.io_time.count | - | MicroSecond |
| Per tag latency | cloud.gcp.cloudsql_googleapis_com.database.postgresql.insights.pertag.latencies | - | MicroSecond |
| Per tag lock time | cloud.gcp.cloudsql_googleapis_com.database.postgresql.insights.pertag.lock_time.count | - | MicroSecond |
| Per tag affected rows | cloud.gcp.cloudsql_googleapis_com.database.postgresql.insights.pertag.row_count | - | Count |
| Per tag shared blocks cache accessed | cloud.gcp.cloudsql_googleapis_com.database.postgresql.insights.pertag.shared_blk_access_count | - | Count |
Full version history
To have more information on how to install the downloaded package, please follow the instructions on this page.
ReleaseDate
Full version history
Version 1.1.2
Updated
- Feature sets & metrics section in HUB Product Information page
Full version history
Version 1.1.1
Fixed
- GCP project details page doesn't crash anymore when cloud:gcp:cloudsql_database type is not declared in environment
Full version history
Version 1.1.0
Added
- Metrics now support management-zone filtering (main entity type specified for metrics)
Full version history
Version 1.0.6
Added
- Release notes to published extension
- Auto publishing extensions to Hub
Full version history
Support for GCP overview
Full version history
Now you can enable monitoring of Query insights for PostgreSQL databases. Set of 18 metrics is bundled in a new featureset (postgresinsights).
Full version history
No release notes
