You are managing multiple applications connecting to a database on Cloud SQL for PostgreSQL. You need to be able to monitor database performance to easily identify applications with long-running and resource-intensive queries. What should you do?
A.
Use log messages produced by Cloud SQL.
B.
Use Query Insights for Cloud SQL.
C.
Use the Cloud Monitoring dashboard with available metrics from Cloud SQL.
D.
Use Cloud SQL instance monitoring in the Google Cloud Console.
Answer should be B: As long-running query and resource intensive queries are available in query insight providing details about which queries are taking how much time and resource utilization at what stage.
C is correct answer. We can use Cloud SQL Instance monitoring as well, but need to build the custom metrics for the metrics needed. Instead with Cloud Monitoring these metrics are already available. https://cloud.google.com/sql/docs/mysql/monitor-instance#cloud-monitoring https://cloud.google.com/sql/docs/sqlserver/admin-api/metrics
The Cloud SQL System insights dashboard helps you detect and analyze system performance problems.
.
https://cloud.google.com/sql/docs/postgres/monitor-instance#sql-system-insights
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
dynamic_dba
Highly Voted 1 year, 7 months agochelbsik
Highly Voted 1 year, 10 months agohanayome
Most Recent 5 months, 3 weeks agoH_S
1 year, 7 months agoNirca
1 year, 7 months agoSidsA
1 year, 8 months agoBlueocean
1 year, 10 months agopk349
1 year, 10 months agoGCP72
1 year, 10 months agojitu028
1 year, 10 months agorange9005
1 year, 10 months agoKloudgeek
1 year, 10 months agorange9005
1 year, 10 months ago