Help Docs

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.

Table of contents

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 Hamburger icon 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.
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 Hamburger icon 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:

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

Configuration Details

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

  1. Go to Cloud > GCP > Cloud Spanner.
  2. Select a resource.
  3. 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:

  1. Go to the Reports section on the left navigation pane.
  2. Select Cloud Spanner from the menu on the left.
  3. 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:

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

Related content

Was this document helpful?

Shortlink has been copied!