Google Cloud Spanner monitoring integration

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.