Proactive database optimization with query insights in Database Center

Key Takeaways

Welcome to Database Center. In this video, you'll learn how to proactively optimize your database performance using query insights. Database Center gives you a fleet-wide view. The performance tab provides intelligent recommendations flagging databases with inefficient queries or high resource utilization. Let's drill down into this Cloud SQL instance that's showing high CPU utilization. Within the instance, you can access query insights. This powerful tool helps you detect, diagnose, and prevent query performance problems. Please note that query insights is generally available for Cloud SQL, AlloyDB, and Spanner. Support for Firestore and databases running on Compute Engine is coming soon. Check our documentation for more information. Link in the description if you're watching on YouTube and in the course if you're on Google skills. Query insights immediately displays the most resource-intensive queries. You can view metrics like execution time, database load, and wait events. For example, this query seems to have a high execution time. Drilling in, you get detailed statistics, the query text, and sometimes even the execution plan. You can analyze how this query's performance has trended over time helping pinpoint when a problem started. You can also run investigations on latency and query performance. Upon completion of an investigation, you can view specific details and insights on issues and observations that inform you why an issue has occurred. Query insights often provides actionable recommendations like suggesting an index to improve performance. By integrating query insights, Database Center doesn't just show you that there's a problem, but helps you find the root cause across your database fleet. There's much more to learn and you can enroll on Google skills by clicking the link in the description. Thanks for watching.