Google Cloud Spanner monitoring integration

Monitoring your GCP Cloud Spanner is highly essential as this enables you to optimize the performance of your database services. With Site24x7's integration, track the performance of your Google Cloud Spanner and identify bottlenecks that will hinder your database capabilities in the near future.

Setup and configuration

Adding Google Cloud Spanner while configuring a new Google Cloud monitor

If you have not configured a Google Cloud monitor yet, add one by following the steps below:
1. Log in to your Site24x7 account.
2. Go to Cloud > GCP > Add GCP Monitor or Admin > Cloud Monitoring > Google Cloud Platform(GCP).
3. Provide a unique display name for identification purposes.
4. Upload a service account JSON file to authenticate Site24x7 for performing resource discovery.
5. Select Cloud Spanner from the Select the Resources for Monitoring list.
6. Select existing Notification Profiles, User Alerts Groups, Tags, and IT Automation Templates or add new ones. You can also integrate Site24x7's alarms with your preferred third-party service.
7. Click Start GCP Monitoring.
Adding Google Cloud Spanner to an existing Google Cloud monitor

If you already have a Google Cloud monitor configured for the service account, you can add Google Cloud Spanner by following the steps below:
1. Log in to your Site24x7 account.
2. Go to Cloud > GCP and select your GCP monitor.
3. Click the hamburger icon next to Service View and select Edit, which brings you to the Edit GCP Monitor page.
4. On the Edit GCP Monitor page, select Cloud Spanner from the Select the Resources for Monitoring list and click Save.
5. After successful configuration, go to Cloud > GCP > Cloud Spanner. Now you can view the discovered Google Cloud Spanner resources.

Note

It will take approximately five minutes to discover new GCP resources.

Polling frequency

Site24x7's Google Cloud Spanner monitor collects minute-wise metric data, and the statuses of your Google Cloud Spanner are reported every five minutes.

Supported metrics

Metric name	Description	Statistic	Unit
API Request Rate	The rate of the Cloud Spanner API requests	Average	Count per second
Bytes received by Cloud Spanner	The average amount of the uncompressed request bytes received by Cloud Spanner	Average	Bytes
Bytes Sent by Cloud Spanner	The average amount of the uncompressed response bytes sent by Cloud Spanner	Average	Bytes
CPU Utilization	The percent utilization of provisioned CPU	Average	Percentage
Nodes	The total number of nodes	Total	Count
Request Latencies	The distribution of server request latencies for a database	Total	Seconds
Sessions	The total number of sessions in use	Total	Count
Storage Used	The amount of storage used	Total	Bytes
API Requests	The total number of Cloud Spanner API requests	Total	Count
Request Latencies by Transaction Type	The average distribution of server request latencies segregated by transaction types	Average	Seconds
Backup Storage Used	The total amount of backup storage space utilized	Total	Bytes
Smoothed CPU Utilization	The average smoothed utilization of provisioned CPU for the past 24 hours	Average	Percentage
CPU Utilization by Operation Type	The average utilization of the provisioned CPU segregated based on operation types	Average	Percentage
CPU Utilization by Priority	The average utilization of the provisioned CPU segregated based on priority	Average	Percentage
Processing Unit Second	The total number of processing units used for DataBoost operations	Total	Count
Leader Percentage by Region	The share of leaders segregated based on cloud regions	Total	Percentage
Processing Units	The total number of processing units	Total	Count
Storage Limit	The total storage limit allocated for an instance	Total	Bytes
Storage Limit per Processing Unit	The total storage limit per processing unit	Total	Bytes
Storage Utilization	The fraction of storage space utilized by the instance from the storage space limit	Average	Percentage
Lock Wait Time	The total lock wait time for all the lock conflicts that occurred in the database	Total	Seconds
Count of Queries	The total count of queries segregated by database name, status, query type, and the optimizer version used	Total	Count
Bytes Returned Count	The average amount of data returned by the queries excluding the transmission encoding overhead	Average	Bytes
Query CPU Time	The total CPU time Cloud Spanner spent on operations to execute the queries	Total	Seconds
Query execution count	The total number of times the Cloud Spanner saw queries during the data collection period	Total	Count
Query Failures	The total number of times queries failed during the data collection period	Total	Count
Query Latencies	The average latency of all the queries executed	Average	Seconds
Remote Service Calls Count	The total count of all remote service calls	Total	Count
Remote Service Calls Latencies	The average latency experienced by all remote service calls	Average	Milliseconds
Remote Service Network Bytes	The total amount of network data exchanged with the remote service	Total	Bytes
Remote Service Rows Count	The total count of rows processed by a remote service	Total	Count
Remote Service Rows Latencies	The average latency occurred while processing rows by a remote service	Average	Milliseconds
Rows Returned Count	The total number of rows that the queries returned	Total	Count
Rows Scanned Count	The total number of rows that the queries scanned excluding the deleted values	Total	Count
Bytes Returned Count	The total amount of data that the reads returned excluding the transmission encoding overhead	Total	Bytes
Client Wait Time	The average time spent waiting due to throttling	Average	Seconds
Read CPU Time	The time spent to execute the reads excluding prefetch CPU and other overheads	Average	Seconds
Read Execution Count	The total number of shape reads during the data collection period	Total	Count
Leader Refresh Delay	The average time spend to co-ordinate the read actions across instances in multi region configurations	Average	Seconds
Locking Delays	The total time spent in waiting due to locking	Total	Seconds
Rows Returned Count	The total number of rows returned by the reads	Total	Count
Rows Deleted	The total number of rows deleted by policy since the last data collection	Total	Count
Processed Watermark Age	The time difference between the read timestamp and the last successful execution	Average	Seconds
Total Number of Undeletable Rows	The total number of rows in all the tables in the database that can't be deleted	Total	Count
Bytes Written	The amount of data written by the transactions	Total	Bytes
Transaction Commit Attempts	The total number of commit attempts for the transactions	Total	Count
Transaction Commit Retries	The total number of commit attempts that are retried after being previously aborted	Total	Count
Transaction Participants	The total number of participants in each commit attempt	Total	Count
Transaction Latencies	The average latency between the first operation to the transaction to either commit or abort	Average	Seconds

Threshold configuration

Global configuration
1. In the Site24x7 web client, go to the Admin section on the left navigation pane.
2. Select Configuration Profiles from the left pane and select Threshold and Availability from the drop-down menu.
3. Click Add Threshold Profile in the top-right corner.
4. For Monitor Type, select Cloud Spanner.
5. Now you can set the threshold values for the metrics listed above.
Monitor-level configuration
1. In the Site24x7 web client, go to Cloud > GCP > Cloud Spanner.
2. Select a resource you would like to set a threshold for, then click the hamburger icon.
3. Select Edit, which directs you to the Edit Cloud Spanner Monitor page.
4. You can set the threshold values for the metrics with the Threshold and Availability option.
5. You can also configure IT Automation at the attribute level.

IT Automation

With Site24x7's IT Automation tools, you can streamline your operations, reduce manual effort, and proactively address performance issues. The alarm engine in Site24x7 continually evaluates system events based on the thresholds you have set. When a breach occurs, the mapped automation associated with that event is triggered, ensuring prompt remediation and minimizing the impact on your IT infrastructure.

How to configure IT Automation for a monitor

Configuration Rules

Site24x7's Configuration Rules feature lets you edit multiple monitors and streamline the configuration process for your monitoring resources. With Configuration Rules, you can easily associate different monitor groups or add specific tags to multiple monitors simultaneously. This eliminates the need to manually edit each monitor individually, saving you valuable time and effort.

How to add Configuration Rules

Summary

The Summary tab will give you the performance data organized by time for the metrics listed above. To view the summary:

Go to Cloud > GCP > Cloud Spanner.
Select a resource.
Click the Summary tab.

Configuration Details

The Configuration Details tab provides details on the configurations of application instances. To get the configuration details:

Go to Cloud > GCP > Cloud Spanner.
Select a resource.
Click the Configuration Details tab.

Reports

Gain in-depth data about the various parameters of your monitored resources and accentuate your service performance using our insightful reports.

To view reports for a Google Cloud Spanner resource:

Go to the Reports section on the left navigation pane.
Select Cloud Spanner from the menu on the left.
You can find the Availability Summary Report, Performance Report, and Inventory Report for one selected monitor. Or you can get the Summary Report, Availability Summary Report, Health Trend Report, and Performance Report for all the Google Cloud Spanner monitors.

You can also get reports from the Summary tab of the Google Cloud Spanner monitor:

Click the Summary tab.
Get the Availability Summary Report of the monitor by clicking Availability.
You can also find the Performance Report of the monitor by clicking any chart title.