Monday, February 8, 2021

Detect, diagnose, and prevent performance problems using Cloud SQL Insights

Cloud SQL Insights, a database observability tool for your Cloud SQL database has just arrived in GCP
Source: Google Cloud Blog

Cloud SQL Insights, a database observability tool has just arrived in GCP.

With Insights, developers can quickly inspect and address database performance issues in Cloud SQL, allowing for faster iteration on applications freeing DBAs to work on non-development tasks.

Insights brings developers self-service monitoring and diagnosis tooling so they can proactively prevent query performance problems.

Availability

Insights is currently available for Cloud SQL for PostgreSQL.

How Insights works

Insights complements APM and observability tools by providing database metrics through the open standard OpenTelemetry and Cloud Monitoring and Cloud Trace APIs. This makes it easy to do end-to-end tracing in your system, from the database up to the application layer. 

Using Cloud Insights

Once Insights is installed, developers are able to see metrics and inspect queries directly from GCP:

Source: Google Cloud Blog

The interface also helps identifying performance problems with pre-built dashboards:

Source: Google Cloud Blog

Sql Commenter

With Insights, Google also released SQL Commenter, an open-source library that that automatically instruments queries. SQL Commenter supports many popular ORMs such as Hibernate, Spring, Express, Django, Flask, and others.

Learn More

To learn more about Insights, pricing and feature check the official documentation.

See Also

Featured Article

Detect, diagnose, and prevent performance problems using Cloud SQL Insights

Cloud SQL Insights, a database observability tool for your Cloud SQL database has just arrived in GCP ...

Popular this Week