This document describes how you can use Gemini assistance to help youuse system insights to optimize and troubleshoot your Spanner resources.

1. In the Google Cloud console, go to theSpanner Instances page.

   Go to Spanner Instances

2. To open theOverview page of an instance, click the instance name.

3. To open Gemini, clicksparkGemini.

4. In the Gemini pane, enter a prompt that describes theinformation you're interested in. The prompt must request information aboutsystem insights—for example:

   • "What was the peak database CPU utilization in the last 24 hours?"
   • "What is the peak transaction latency for this database Instance around2pm today?"
   • "What is the database load trend for this instance in the last week?"
   • "What is the peak cpu utilization by priority only for system operationsfor database instance in the last hour?"
   • "What is the p99 request latency for this database Instance in the last24 hours?"

   The duration for the prompt request must be within the past seven days. Theduration can be specified in the following ways:

   • Append a duration to the prompt. For example, to get information aboutthe past day, add "in the last 24 hours" or "in the last day" to theend of the prompt.
   • In the Google Cloud console by doing the following:
     1. In Spanner, clickSystem insights in the left pane.
     2. Click1 hour,6 hours,1 day,7 days. ClickCustomto specify a custom duration that's within the past seven days.
   • Don't specify a duration in the prompt or the Google Cloud console to usethe default duration of the last one hour.

   If the specified duration extends further in the past than the last sevendays, then an error is returned.

5. To send the prompt, click sendsendSend. Gemini returns a response to your prompt.

What's next

• Write SQL with Gemini assistance.
• Learn about how tooptimize Spanner performance.
• Learn how tomonitor instances with system insights.