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
- Polling frequency
- Supported metrics
- Threshold configuration
- IT Automation
- Configuration Rules
- Summary
- Configuration Details
- Reports
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:
- Log in to your Site24x7 account.
- Go to Cloud > GCP > Add GCP Monitor or Admin > Cloud Monitoring > Google Cloud Platform(GCP).
- Provide a unique display name for identification purposes.
- Upload a service account JSON file to authenticate Site24x7 for performing resource discovery.
- Select Cloud Spanner from the Select the Resources for Monitoring list.
- 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.
- 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:
- Log in to your Site24x7 account.
- Go to Cloud > GCP and select your GCP monitor.
- Click the hamburger
icon next to Service View and select Edit, which brings you to the Edit GCP Monitor page. - On the Edit GCP Monitor page, select Cloud Spanner from the Select the Resources for Monitoring list and click Save.
- 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
- In the Site24x7 web client, go to the Admin section on the left navigation pane.
- Select Configuration Profiles from the left pane and select Threshold and Availability from the drop-down menu.
- Click Add Threshold Profile in the top-right corner.
- For Monitor Type, select Cloud Spanner.
- Now you can set the threshold values for the metrics listed above.
- Monitor-level configuration
- In the Site24x7 web client, go to Cloud > GCP > Cloud Spanner.
- Select a resource you would like to set a threshold for, then click the hamburger icon.
- Select Edit, which directs you to the Edit Cloud Spanner Monitor page.
- You can set the threshold values for the metrics with the Threshold and Availability option.
- 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.
Related content
- Monitoring Google Cloud Platform
- List of Google Cloud services supported for monitoring
- Possible reasons why GCP resources are not added for monitoring in Site24x7
- What permissions should I have in my Google account to enable Site24x7's Google Cloud Platform (GCP) monitoring?
- How to create a service account JSON file to authenticate Site24x7 for the discovery of GCP resources
- How to create a service account in the GCP console