New Relic's integrations with the Google Cloud Platform (GCP) include an integration to report Google Cloud Spanner data to New Relic. This document explains how to activate the GCP Cloud Spanner integration and describes the data that can be reported.
Features
Google Cloud Spanner service is a globally-distributed relational database service built for the cloud. Using the Google Spanner Console, developers can create a Cloud Spanner instance, add schemas, write and modify data, and run queries.
Activate integration
To enable the integration follow standard procedures to connect your GCP service to New Relic.
Polling frequency
New Relic integrations query your GCP services according to a polling interval, which varies depending on the integration. The polling frequency for Google Cloud Spanner is five minutes. The resolution is 1 data point every minute.
Find and use data
After activating the integration and waiting a few minutes (based on the polling frequency), data will appear in the New Relic UI. To find and use your data, including links to your dashboards and alert settings, go to one.newrelic.com > Infrastructure > GCP > (select an integration).
Metric data
To view metric data for your GCP Spanner integration in New Relic, create NRQL queries for GcpSpannerInstanceSample
and GcpSpannerDatabaseSample
events and their related attributes.
GcpSpannerInstanceSample
Query GcpSpannerInstanceSample
events in New Relic to view data for the following attributes:
-
Attribute Description instance.cpu.Utilization
Utilization of the provisioned CPU, between 0 and 1.
instance.cpu.utilization_by_priority
Utilization of the provisioned CPU by priority, between 0 and 1.
instance.cpu.smoothed_utilization
24-hour smoothed utilization of the provisioned CPU , between 0 and 1.
instance.nodes
Total number of nodes. instance.sessions
Number of sessions in use. instance.storage.UsedBytes
Storage used in bytes.
GcpSpannerDatabaseSample
Query GcpSpannerDatabaseSample
events in New Relic to view data for the following attributes:
-
Attribute Description api.ReceivedBytes
Uncompressed request bytes received by Cloud Spanner. api.Requests
Rate of Cloud Spanner API requests. api.RequestLatencies
Distribution of server request latencies for a database. This includes latency of request processing in Cloud Spanner backends and API layer. It does not include network or reverse-proxy overhead between clients and servers. api.SentBytes
Uncompressed response bytes sent by Cloud Spanner.
Inventory data
To view inventory data for GCP Spanner services, go to one.newrelic.com > Infrastructure > Inventory and search for or select the following:
gcp/spanner/instance
-
Name Description projectId
The project where the instance is.
zone
The region where the instance is. name
The Id of the instance (not the name). state*
The state of the instance. nodeCount*
The number of nodes the instance has. instanceName*
The name of the instance. labels*
The labels set for the instance.
* Only available if the GCP project is linked to New Relic through a service account.
gcp/spanner/database
-
Name Description projectId
The project where the database is.
zone
The region where the database is. name
The Id of the database (not the name). instanceId
The Id of the instance where the database is. dl*
The SQL definition of the instance. state*
The state of the database.
* Only available if the GCP project is linked to New Relic through a service account.