You can learn about Google Cloud database products by entering prompts into Gemini about the following:
- Database Center concepts. For example, you can prompt Gemini to provide guidance about how Database Center measures your database fleet health.
- Database Center health issues. For example, you can prompt Gemini to explain why it's an issue that your database has public IP enabled.
The following are example prompts to help you learn general information about Database Center:
- "How does Database Center measure my database fleet health?"
- "What data sources does Database Center use?"
- "What does it mean for a database resource to be failover protected?"
Before you begin
Ensure that Database Center is set up for your organization.
- Ensure that Gemini Cloud Assist is set up for your Google Cloud user account and project.
Ensure that a Google Cloud project is open. If you try to use Gemini chat at the folder or organization level, you're prompted to open a Google Cloud project.
- Sign in to your Google Cloud account. If you're new to Google Cloud, create an account to evaluate how our products perform in real-world scenarios. New customers also get $300 in free credits to run, test, and deploy workloads.
-
In the Google Cloud console, on the project selector page, select or create a Google Cloud project.
-
Verify that billing is enabled for your Google Cloud project.
-
In the Google Cloud console, on the project selector page, select or create a Google Cloud project.
-
Verify that billing is enabled for your Google Cloud project.
Use Gemini to learn about fleet health issues
You can use Gemini Cloud Assist to track health issues in Database Center, and Gemini chat to learn more about your database fleet and inventory.
Use Gemini chat
To use Gemini chat to learn more about database fleet health issues and Database Center, follow these steps:
In the Google Cloud console, go to the Database Center page.
To open Gemini, click spark Gemini.
Click Start chatting.
In the Gemini chat enter a prompt, for example,
What is a database fleet?To send the prompt, click Send. Gemini returns a response similar to the following:
A database fleet consists of all the provisioned database resources across all Google Cloud database products that your organization uses. Database resources are the clusters, instances, and virtual machines that power your workloads. Database Center supports Cloud SQL for MySQL, Cloud SQL for PostgreSQL, and AlloyDB.
Use Gemini Cloud Assist
Use Gemini Cloud Assist to detect and publish intelligent performance insights and recommendations at the fleet level for your organization. Gemini Cloud Assist lets you investigate select scenarios and performance issues with granular metrics using system insights and query insights integration. Gemini Cloud Assist also provides cost optimization recommendations.
The following is a list of Database Center recommendations provided by Gemini Cloud Assist.
Performance insights and recommendations
The following performance insights and recommendations for certain database products are detected for Database Center by Gemini Cloud Assist:
Insight or recommendation |
Database products |
|---|---|
Inefficient queries and index advisor to enhance query performance |
Cloud SQL, AlloyDB for PostgreSQL |
The Analyze system performance option in the High Resource Utilization recommendation |
Cloud SQL, AlloyDB for PostgreSQL |
Cost recommendations
The following are the cost recommendations detected for Database Center by Gemini Cloud Assist:
Cost recommendation |
Recommendation details |
Database products |
|---|---|---|
Over provisioned resource |
Checks if a database resource had low CPU and memory utilization during the past 30 days |
Cloud SQL |
Idle resource |
Checks if a database resource had a low level of activity during the past 30 days |
Cloud SQL |